Complete development of a relational database

Assignment Help Database Management System

Reference no: EM13811199

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

3. Deliverables include copies of the following files:

-The Visio ERD file (mdbXXX.vcd)

-The ORACLE script file (mdbXXX.sql)

-The spool output file (mdbXXX.lst)

Development Suggestions for the mdbXXX.sql File

1. Ensure that the entire script is working before you "un-comment" the spool statements.

2. Develop your script one step at a time.

3. Include your personal and program information in the script file comment.

4. Suggested steps in developing the SQL script file:

SET system parameters
DROP TABLE firstTable
CREATE TABLE firstTable
DESC firstTable
INSERT VALUES INTO firstTable
CREATE VIEW if needed
SELECT * FROM firstTable
Repeat for secondTable
Repeat for rest of tables
JOIN all of the tables to produce the desired Report
-- SPOOL OFF

Table of Data

Patient Name	Patient Number	Medication Name	No. of Tablets	Dosage/ Tablet	Frequency	Admitted	Rm.	Dr.
Fred	1001	Prozac	2	3 grams	annually	30-MAR-07	101	Payne
Fred	1001	Aspirin	6	1 gram	daily	30-MAR-07	101	Payne
Fred	1001	Valium	9	2 grams	weekly	30-MAR-07	101	Payne
Sam	1005	Spam	1	3 grams	2 x daily	02-APR-07	150	Acres
Sam	1005	Prozac	2	6 grams	daily	02-APR-07	150	Acres
Betty	1010	Spam	1	4 grams	daily	11-MAY-07	222	Itchi
Betty	1010	Aspirin	6	3 grams	daily	11-MAY-07	222	Itchi
Betty	1010	Valium	9	1 gram	weekly	11-MAY-07	222	Itchi
Betty	1010	Sugar Water	11	1 gram	monthly	11-MAY-07	222	Itchi

Reference no: EM13811199

Questions Cloud

What is the system capacity : What is the system capacity, and which is the bottleneck department? How much slack (unused capacity) is available in other departments?

Calculate the capacity of each machine center : Calculate the capacity of each machine center and the capacity of the system. Analyze where the focus of the company's efforts should be if Beck wants to expand capacity. Determine how much extra capacity he can get without causing another operatio..

Impact of an individual personality on work performance : Explain the impact of an individual's personality on work performance. Identify at least 3 strategies an organization can use to maximize the contribution of individuals.

Write the nuclear equation for decay : Write the nuclear equation for decay - Calculate the binding energy per nucleon and How many nuclei are initial present in a 25.0 mg sample?

Complete development of a relational database : Complete development of a relational database. You are to do the following: Use Visio to create the appropriate diagrams. Create a script named mdbXXX.sql (where XXX are your initials) that Create the tables in 3NF needed to implement your DB schema

Examine the relationship between negotiation : The purpose of this assignment is to examine the relationship between negotiation, ethics, and effective leadership.

Schedule a meeting with a vendor who lives there : While working in Somalia, you schedule a meeting with a vendor who lives there. When he shows up 20 minutes after the meeting was scheduled, should you take it as a sign of incompetence or disrespect? Explain your answer using concepts from the te..

Implement the priorityq class using a heap instead : Implement the PriorityQ class using a heap instead of an array

Qualified national or international standards body : What is the certification when a qualified national or international standards body or similar certifying agency audits and certifies that a company is ISO 9000-compliant?

User Account

All Pages