assignment9

assignment9 - b) disjoint, partial c) disjoint, total d)...

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

View Full Document Right Arrow Icon
CSIS3310 – Convert E-R Diagram into Tables List the table name and corresponding attribute names. Hint: For each relationship you should add a Foreign Key on the Child side or an intersection/associate table. 1) ITEM: Item-No, Description, Unit_Cost PATIENT: PatientNumber, Patient_Name, Physician_ID PHYSICIAN: Physician_ID, NAME PATIENT/ITEM_COMBINATION: PatientNumber, Item-No, TotalCost, Date, Quantit PATIENT/PHYSICIAN_COMBINATION: PatientNumber, Physician_ID, Treatment_Name, Treatment_Time
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) Convert E-R into Tables CUSTOMERS: CustomerID, CustomerFirst, CustomerLast INVENTORY: InventoryID, Make, Model, Year EMPLOYEE: EmployeeID, EmployeeFirst, EmployeeLast SALES: CustomerID, EmployeeID, InventoryID
Background image of page 2
3) Convert the following Forms to an E-R Diagrams: 4) Super-Type: Vehicle. Sub-Type: Car, Boat, Bus . This is an example of sub-types that are: a) overlapping, partial
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: b) disjoint, partial c) disjoint, total d) overlapping, total note that overlapping = inclusive, disjoint = exclusive total = complete, partial = incomplete 5) Transform the following ER relation into Tables. Place your answer on the next page. text text text DEPT VENDOR EMP PROJ has Assigned_ To Belongs_ To Relationship Married EName Date_Mar ried Cost P_ID Percent_ TIme E_ID Last_ Name Mid_Init First_ Name Skills D_ID Rel_ID D_Phone Last Meeting VName V_ID Internal External Phone Loc D D_Name DOB Skill# S_Desc VType DEPENDENT DEPT: D_ID, D_Phone VENDOR: V_ID, VType, VName DEPENDENT: D_Name, DOB, E_ID PROJ: P_ID, Cost EMP: E_ID, EName, D_ID SKILLS: Skill#, S_Desc EMP/SKILLS_COMBINATION: E_ID, Skill# EMP/PROJ_COMBINATION: E_ID, P_ID, Percent_Time DEPT/VENDOR_COMBINATION: D_ID, V_ID, Rel_ID, Last_Meeting...
View Full Document

Page1 / 5

assignment9 - b) disjoint, partial c) disjoint, total d)...

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

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