Acs Assignment 2, University of Winnipeg

1451 words 6 pages
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

Related

  • EDA ASSIGNMENT 2
    2375 words | 10 pages
  • Harris Seafood Assignment 2
    976 words | 4 pages
  • LIS2780 Assignments Spring15 2
    2338 words | 10 pages
  • MU1 Assignment 2
    1737 words | 7 pages
  • Assignment 2: Organizational Structure
    1635 words | 7 pages
  • Assignment 2
    1014 words | 5 pages
  • Week 2 Ind assignment
    1098 words | 5 pages
  • CNDV 5301 Assignment 2
    1017 words | 5 pages
  • Acct 562 Assignment 2
    2163 words | 9 pages
  • Dtlls Assignment 2
    3533 words | 15 pages