Acs Assignment 2, University of Winnipeg
ACS 1803 – ASSIGNMENT 2
Due: February 11, 2013
To be done individually.
1)
a) 8 A hospital ward wants to computerize its data about patients and medications / dosages prescribed for the patients. {In your mind, compare this situation with the in-class example about students, courses and grades: student is like patient, course is like medication and grade is dosage}.
Then, use the following fields of hospital data that are put into one file (table): patient No., patient name, patient address, patient birth date; medication name, medication dosage (this means how many tablets or teaspoons of that medication the patient must take each day).
Use the following data:
John Smith
Date of Birth: Oct.10.1969
Address:123 Dialysis Way.
Prescription: Prilosec. Three tablets daily
Adavart . Three tablets daily
Patient ID: 1849
Marla Johnson
Date of Birth: Jan.31.1955
Address:842 Blossom St.
Prescription: Oxycontin Two teaspoons daily
Neulasta. Four tablets daily
Lamictal Two tablets daily
Patient ID: 1850
Jane Doe
Date of Birth: Aug.01.1949
Address:725 Olive Ave.
Prescription: Remicade. Three tablets daily
Diovan. Four tablets daily
Gardasil. One teaspoon daily
Patient ID: 1851
Show this in one table with all your data records. Then explain fully why this would not be a good way of organizing data on disk.
b) 10 Convert the one table in the previous question to a relational database design. Fill each table in your design with data from the previous question such that no information is lost. Show how your design satisfies the criteria for being a relational database, and why it is better to store data on disk in this way rather than all in one table.
c) 7 What is database management system? What steps would the hospital ward need to take to prepare its data to be ready for producing meaningful output from the DBMS?d) 5 What are two main forms of output from a DBMS? Provide one example of each form of output using
hospital
Due: February 11, 2013
To be done individually.
1)
a) 8 A hospital ward wants to computerize its data about patients and medications / dosages prescribed for the patients. {In your mind, compare this situation with the in-class example about students, courses and grades: student is like patient, course is like medication and grade is dosage}.
Then, use the following fields of hospital data that are put into one file (table): patient No., patient name, patient address, patient birth date; medication name, medication dosage (this means how many tablets or teaspoons of that medication the patient must take each day).
Use the following data:
John Smith
Date of Birth: Oct.10.1969
Address:123 Dialysis Way.
Prescription: Prilosec. Three tablets daily
Adavart . Three tablets daily
Patient ID: 1849
Marla Johnson
Date of Birth: Jan.31.1955
Address:842 Blossom St.
Prescription: Oxycontin Two teaspoons daily
Neulasta. Four tablets daily
Lamictal Two tablets daily
Patient ID: 1850
Jane Doe
Date of Birth: Aug.01.1949
Address:725 Olive Ave.
Prescription: Remicade. Three tablets daily
Diovan. Four tablets daily
Gardasil. One teaspoon daily
Patient ID: 1851
Show this in one table with all your data records. Then explain fully why this would not be a good way of organizing data on disk.
b) 10 Convert the one table in the previous question to a relational database design. Fill each table in your design with data from the previous question such that no information is lost. Show how your design satisfies the criteria for being a relational database, and why it is better to store data on disk in this way rather than all in one table.
c) 7 What is database management system? What steps would the hospital ward need to take to prepare its data to be ready for producing meaningful output from the DBMS?d) 5 What are two main forms of output from a DBMS? Provide one example of each form of output using
hospital