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?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Develop a domain model for the case study

The objective of the assignment is to apply and consolidate skills acquired in the requirement and analysis disciplines through analysis of a simple case study, and to express the results through the relevant UML diagrams.

  Security associated with new project

Your company has put in the request for a new database system and you have been tasked with architecting the security associated with this new project.

  Write a two to three page paper in which youdocument the

write a two to three page paper in which youdocument the requirements based on the information provided and assumptions

  Role and tasks performed by database administrator

In 250 - 300 words describe role of a database administrator and the tasks performed by this role. Also, describe why this role is important in Database Management.

  Describe research database of research including the purpose

Describe the research database or collection of research including the purpose and the subject matter it covers. Explain how the database relates to your topic of interest/question.

  Microsoft access imagine that you work for a police

imagine that you work for a police department and have need to track the following type of data parolees being released

  Draw a data flow diagram

You have been provided three diagrams - a Context Diagram (DFD), Level-0 Diagram, and the A-0 Diagram (IDEF). For this problem, you will be asked to re-draw or construct the following diagrams:

  Determine the benefits of data mining to the businesses

Determine the benefits of data mining to the businesses when employing: Predictive analytics to understand the behavior of customers

  Does the resulting relation have an mvd

Does the above have one or more functional dependency (do not list FDs by applying derivation rules)? If so, what is it? Show how you will remove it by decomposition.

  What qualitative conclusions would you draw about efficacy

Focus on quantitative data. Based on the statistical data gleaned from the readings what qualitative conclusions would you draw about the efficacy of the many aspects of differentiated parent support?

  Programming with sql using number and date fun

Programming with SQL Objectives: Using Character, Number and Date Functions. • Create and execute single-row functions that perform case conversion and/or character manipulation. • Create and execute single-row number functions ROUND and TRUNC. •..

  Develop a database security policy

Develop a database security policy for a small organization that collects and analyzes evaluation data for a variety of non-governmental organizations - security policy describes what it means for an organization to be secure.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd