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.

Reviews

Write a Review

Software Engineering Questions & Answers

  Research report on software design

Write a Research Report on software design and answer diffrent type of questions related to design. Report contain diffrent basic questions related to software design.

  A case study in c to java conversion and extensibility

A Case Study in C to Java Conversion and Extensibility

  Create a structural model

Structural modeling is a different view of the same system that you analyzed from a functional perspective. This model shows how data is organized within the system.

  Write an report on a significant software security

Write an report on a significant software security

  Development of a small software system

Analysis, design and development of a small software system.

  Systems analysis and design requirements

Systems Analysis and Design requirements

  Create a complete limited entry decision table

Create a complete limited entry decision table

  Explain flow boundaries map

Explain flow boundaries map the dfd into a software architecture using transform mapping.

  Frame diagrams

Prepare a frame diagram for the software systems.

  Identified systems and elements of the sap system

Identify computing devices, which could be used to support Your Improved Process

  Design a wireframe prototype

Design a wireframe prototype to meet the needs of the personas and requirements.

  Explain the characteristics of visual studio 2005

Explain the characteristics of Visual Studio 2005.

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