Week5.Case Study ECS - Milestone 4 Part II Solution

Week5.Case Study ECS - Milestone 4 Part II Solution - One...

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

View Full Document Right Arrow Icon
SADM 5/ed - CASE STUDY 2 ECS - Milestone 4 Part II: Data Modeling Page: 4-1 MILESTONE 4 – DATA MODELING SOLUTION PART II  Fully Attributed Data Model
Background image of page 1

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

View Full DocumentRight Arrow Icon
SADM 5/ed - CASE STUDY 2 ECS - Milestone 4 Part II: Data Modeling Page: 4-2 Explanation: One employee can make one or more check-out transactions. One check-out Transaction can only belong to one employee. One type of equipment can be in one or more check-out transactions. One check- out transaction can only check out one type of equipment. One equipment repair can only belong to one check-ut transaction. One check-out transaction can only have one equipment repair. One building can have one or more employees. One employee can only be in one building. One employee can make zero or more purchase requests.
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: One purchase request can only be made by one employee. One purchase request can have one purchase order. One purchase order can only be in one purchase request. One purchase request is caused by one check-out transaction. One check-out transaction may create a purchase request. One skill classification can have many types of equipment. One type of equipment may have zero or more skill classifications. Many-to-Many Relationship. Equip_Skill is an associative table. One type of equipment may be tracked. One tracked type of equipment is one type of equipment. One type of equipment may be untracked. One untracked type of equipment is one type of equipment....
View Full Document

Page1 / 2

Week5.Case Study ECS - Milestone 4 Part II Solution - One...

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