cis336_lab_1_solutions-1

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

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

View Full Document Right Arrow Icon
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 DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 06/24/2011.

Page1 / 3

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

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online