CIS321_W5_iLab_Milestone_4_PartII_Solution-1

CIS321_W5_iLab_Milestone_4_PartII_Solution-1 - Week 5:...

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

View Full Document Right Arrow Icon
Week 5: Milestone 4, Part II Solution CIS321_W5_iLab_Milestone_4_PartII_Solution .docx Page 1 Data Modeling: Fully-Attributed ERD Employee PK EmployeeID EmployeeLastName EmployeeFirstName EmployeeOfficePhone FK1 ClassID FK2 BuildingID Equip_Repair PK EquipRepairID FK1 CheckOutID EquipDamage EquipRepairCost EquipRepairDate EquipName Skill_Classification PK ClassID ClassDescription Tracked_Equip PK,FK1 EquipID EquipSerialNum EquipAisle Untracked_Equip PK,FK1 EquipID EquipBin EquipQtyOnHand Check_Out_Transaction PK CheckOutID QtyCheckedOut DateCheckedOut ExpectRtnDate FK2 EquipID FK1 EmployeeID Equipment PK,FK1 EquipID EquipName CostPerUnit Purchase_Request PK PurchaseRequestID PurchaseRequestEquipmentID PurchaseRequestReason PurchaseRequestDate FK1 EmployeeID FK2 CheckOutID Purchase_Order PK PurchaseOrderNum EquipVendor QtyOrdered CostPerUnit DateOrdered DateReceived FK2 EquipID FK1 PurchaseRequestID Makes a Purchases Checks In/Out Has Checks In/Out Is a Is a Has Caused By Ordered Equip_Skill
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.

Page1 / 2

CIS321_W5_iLab_Milestone_4_PartII_Solution-1 - Week 5:...

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