{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

cis336_lab_1_solutions-1

cis336_lab_1_solutions-1 - CIS336 Lab Solution A Lab#1 B...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
A. Lab #1 B. Lab Type: Application Server Experimental C. Lab Title: Simple Relationship Diagrams D. Date Developed: 10/01/2004 Lab Developer/Campus: William McClure. DeVry Dallas Date Revised: Lab Reviser/Campus: E. Desired (Lab) Learning Outcome: After completing the lab, students should be able to successfully identify the processes required to develop a simple relationship diagram showing the 1:M relationships between identified entities. F. Solution: 1. Identify the foreign keys and draw a relationship diagram for the simplified Order Entry database. The CustNo column references the Customer table and the EmpNo column references the Employee table. For each relationship, identify the “1” table and the “Many” table. Ans: In the relationship diagram, primary keys are separated and noted by the PK and foreign keys are noted by a FK. The arrow head denotes the one side of a relationship. CIS336 - Lab Solution
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
CUSTOMER PK CustNo CustFirstName CustLastName CustCity CustState CustZip CustBal EMPLOYEE PK EmpNo
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}