CIS 336 iLab 2 The Expanded Entity Relationship Diagram FOR MORE CLASSES VISIT www. cis336study. com
transitive. Paste your solution into the answer sheet, and label it, Answer # 1.
2. Using the answer to exercise 1, remove all partial dependencies and draw the new dependency diagrams. For each new table created, specify its normal form( 1NF, 2NF, 3NF). Paste your solution into the answer sheet, and label it, Answer # 2.
3. Using the answer to exercise 3, remove all transitive dependencies, and draw the new dependency diagrams. For each new or revised table, specify its normal form. Paste your solution into the answer sheet, and label it, Answer # 3.
4. Draw the ERD for exercise 3, using Crow‘ s Foot notation. Paste your solution into the answer sheet, and label it, Answer # 4.
---------------------------------------------------------------------------------------
CIS 336 iLab 2 The Expanded Entity Relationship Diagram FOR MORE CLASSES VISIT www. cis336study. com
CIS336 Lab 2: The Expanded Entity Relationship Diagram LAB OVERVIEW Scenario and Summary
This lab introduces the next step in creating a data model, the Entity Relationship Diagram( ERD). You will be given a business scenario for a University Medical Center, which is a small community hospital. The business specifications will outline a number of things about the business, some of which will apply directly to the database you are