ChMisc.appliance.ERD%20v2

ChMisc.appliance.ERD%20v2 - Tech(FK TechTime(FK Parts Used...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Appliance Conceptual ERD with additional required Entities owns a repaired by uses contained contains is assigned to recorded by Appliance Fully Attributed ERD with additional required Entities owns a repaired by uses contained contains is assigned to recorded by Customer Appliance Serv Order Parts Used Parts Technician Tech Time Customer Cust No (PK) Cust Name Cust Addr Cust Tel# Appliance Appliance# PK Appliance Desc Manufacturer Cust No (FK) Serv Order SO# Date in Date Complete Prob Desc Status Appl# (FK)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Tech # (FK) TechTime# (FK Parts Used SO# (PK) Part# (PK) Qty Used Parts Part# (PK) Part Desc Unit cost Min Stock Level Technician Tech# (PK) Tech Name Tech Rate Tech Time SO# (PK) Tech# (PK) Date (PK) Time (PK) Time Worked Instead of a compound primary key of SO#, Tech#, Date, Time,,, you can also consider a single attribute such as TechTime# that would represent a unique entry every time a Tech recorded their time...
View Full Document

This note was uploaded on 12/05/2011 for the course IST 352 taught by Professor Staff during the Fall '10 term at Syracuse.

Ask a homework question - tutors are online