Complete development of a relational database

Assignment Help Database Management System

Reference no: EM13770148

Laboratory exercise involves a complete development of a relational database. You are to do the following:

1. Use Visio to create the appropriate diagrams.

2. Create a script named mdbXXX.sql (where XXX are your initials) that

Create the tables in 3NF needed to implement your DB schema.
Your tables must include primary and foreign keyconstraints.
Populate the database.
Create the report that includes all three patients.
Each student will be required to add an individual query. See your instructor for the specifications of your query.

Patient Doctor Room Admitted Required Medication

-------------------------------------------------------------------- -----------------------------------

1001 Fred Payne 101 MARCH 31, 2004 2 Prozac 3 grams annually

6 Aspirin 1 gram daily

9 Valium 2 grams weekly

Reference no: EM13770148

Questions Cloud

Describe the act and its implications for citizens privacy : Describe the act and its implications for citizens' privacy rights in the United States.

Construct probability distributions for sales-unit profits : Sales and profits for a new product are uncertain. The predicted sales may be as high as 10,000 units per year with a probability of 10%. The most likely value is 7,000 units per year. The pessimistic value is estimated to 5,000 units per year with a..

Write paper on the states tort claims act : Write a 1,550 to 1,850- word paper on the state's tort claims act where you reside or on the Federal Tort Claims Act of 1946

Decrease cost profits by decreasing its number of customers : Billboards cost money to make and don't really seem to significantly benefit anyone other than billboard-makers. A company c putting up billboards presumably increases profits from the resulting increased number of customers, but don't competing busi..

Complete development of a relational database : Complete development of a relational database. Create the tables in 3NF needed to implement your DB schema.

Other chemical release and waste management attributes : Click on the "other chemical release and waste management attributes" link. List the categories for which Coconino is in the Dirtiest/Worst counties in the United States (80-100%). How do you account for these levels being so high?

Users of accounting information and the financial : Who is responsible for the preparation of the financial statements that are included in a companys annual report - who performs an audit of the financial statements referred to in part.

What possible influence does the csi effect : How accurate is the popular media representation of forensic science? How does this influence popular opinion on justice-related issues? What possible influence does the "CSI" effect have on the judicial process

What has been mcdonald''s competitive advantage : What has been McDonald's competitive advantage? Looking externally (PESTAL) what is McDonald's best opportunity for competitive advantage in the future (only chose one)?

User Account

All Pages