Lab 7 - Lab 07 Answer Key 1 In the employee training data...

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

View Full Document Right Arrow Icon
Lab 07 Answer Key 1. In the employee training data structure shown below, EmpID is the primary key of the Employee entity. EmpID cannot be the primary key of the Attendance entity because it is not unique. However, if EmpID was unique in the Attendance entity, what would be the cardinality of the relationship between Attendance and Employee? EmpID ClassID Date Complete 1005 C115 4/16/2003 Yes 1006 C115 4/16/2003 Yes 1005 O211 4/18/2003 Yes EmpID Firstname Lastname Dept 1005 Robert Wise Sales 1006 Michelle Linden Acctg ClassID Classname NumHours Mandatory C115 Meeting Customer Needs 3 Yes O211 Basic Computer Training 4 No S110 Fire Safety 1 Yes Employee entity Class entity Attendance entity It would have to be one-to-one. Since a primary key is unique (can have only one instance of a given value), then any time two entities have the same primary key, they must be in a one-to-one relationship.
Background image of page 1

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

View Full DocumentRight Arrow Icon
2. Draw in Visio a data design that would track information recorded on the employee time card shown below. Determine needed attributes, primary and foreign keys, and
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.

This note was uploaded on 01/30/2012 for the course CNIT 180 taught by Professor Victorbarlow during the Spring '12 term at Purdue.

Page1 / 3

Lab 7 - Lab 07 Answer Key 1 In the employee training data...

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

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