The Average Age Of Mothers

3634 Words15 Pages
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
Get Access