Sketch entity-relationship diagram of database table

Assignment Help Software Engineering

Reference no: EM1366629

1. The table shown below lists sample dentist/patient appointment data. A patient is given an appointment at a specific time and date with a dentist located at a particular office. On each day of appointments, a dentist is allocated to a specific office for that day. (20 pts.)

Staff No Dentist Name Pat. No. Pat. Name Appointment Office
Date Time

S101 T. Smith P100 G. White 9/12 10:00 L15
S101 T. Smith P105 J. Bell 9/12 12:30 L15
A264 M. Sagaria P108 I. McKay 9/12 10:00 L10
A264 M. Sagaria P108 I. McKay 9/14 14:15 L10
V555 R. Plevin P105 J. Bell 9/14 16:30 L15
V555 R. Plevin P110 P. Wax 9/15 18:00 L13

A. Give examples of insertion, deletion and update anomalies with the above table.

B. Convert the table to 3NF. Represent your answer in DBDL. (i.e. Give table name and fields. Underline the primary key. Draw an entity-relationship diagram showing all relationships.)

Reference no: EM1366629

Questions Cloud

Sketch dfsa for identifiers-contain only letters and digits : Sketch a DFSA for identifiers which contain only letters and digits, where identifier should have at least one letter, but it need not be first character.

Value of branding in health care : Evaluate the value of branding in health care. Specifically, under what conditions do you feel that it is beneficial for health care organizations to use branding?

Provide short answer : According to the December 22, 2003 issue of Forbes, given below are the ten questions every investor should ask before purchasing a stock;

Role of health information manager : You are the Health Information Manager for Castello Community Hospital and after having submitting a request for proposal (RFP) for a new major database information system and having it approved

Sketch entity-relationship diagram of database table : Convert table to 3NF. Represent your answer in DBDL. Give table name and fields. Underline primary key. Sketch entity-relationship diagram showing all relationships.

Calculate the amount of the equal periodic payments : Following are the present value factors for $1 discounted as 8 percent for 1 to 5 periods. Each of the following items is based on 8 percent interest compounded yearly from day of deposit to day of withdrawal.

Federal patient protection : How might the new federal Patient Protection and Affordable Care Act of 2010 affect the revenue of the health care industry?

How software architecture department can support production : Explain how Software Architecture Department can support production, inventory, sales, and marketing to assure Zilack can meet its business objectives.

Compute the required annual investment : A businesswoman wishes to invest a certain sum of money at the end of every year for five years. The investment will receive 6 percent compounded yearly.

User Account

All Pages