The Average Age Of Mothers - 3634 Words

Scenario The designed database is used to record the births of all premature babies in a Hospital. Created database consists of four tables which are also referred as the dimensions of the database, and these tables are Patient, Duration, Doctor and Baby. Each dimension will consist of at least 5 attributes. With the use of this database Doctors are able to keep track of individual babies’ records and analyse different patterns such as how long a premature baby does needs medical attention and in average how many babies are admitted to this ward annually. ________________________________________ Objectives †¢ To list the average time scale baby would be in the hospital †¢ To list the average gender of babies recovers quickly †¢ To list the†¦show more content†¦SQL Queries Patient Table The SQL code is written to present all patients surnames within the database, and the above screenshot shows the SQL code and the results from the query. Baby Table The SQL code is written to provide all babies names along with their surname, and the above screenshot shows the SQL code and the results from the query. Doctor Table The SQL code is written to provide all Doctors names within the database along with their surname, I’ve customised this code so the names are sorted in alphabetical order and the above screenshot shows the SQL code and the results from the query. Duration Table This is simple SQL query which is used to present records from a specific table. The above screenshot shows the SQL code and the results from Duration table. Average number of survival As part of my objectives I needed find an average of number of babies whom survived from the records of the database, order to that I used the average function on SQL to run a query showing how many babies have survived from the 10 records. Number of babies survived I also stated in my objective that I would use COUNT function on my database therefore I used the table containing babies’ records to write SQL function that will run and count how many babies have survived from the 10 records. Multi Dimension Array Array 1 Array 2 Task 2 Mining association rules