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 …show more content…

Setting schemas. Installing and using a large database involves “telling” the DBMS the logical and physical structure of the data and the relationships among the data for each user. 2. Establishing a data dictionary. In this case, the data dictionary should contain the following information: patient No., patient name, patient address, patient birth date; medication name, medication dosage. 3. Storing and retrieving data. Establishing tables and input all the information, like “1849, John Smith, 123 Dialysis Way, Oct.10.1969”, into them according to the data dictionary. 4. Manipulating data and generating reports. After a DBMS has been installed, users can use it to review reports and obtain important information.
d.)
There are two main forms of output from a DBMS, which are query and report. The query is a database function that extracts and displays information from a database given selection parameters. Database users use Structured Query Language (SQL) to select and extract data from a database, and the SQL is the industry standard language for relational databases.
The report is a compilation of data from the database that is organized and produced in printed format or presented on screen. The report generator is a specialized program that uses SQL to retrieve and manipulate data (aggregate, transform, or group), and the reports are designed using standard templates or can be custom generated