From the account we can find the customer to whom the

This preview shows page 4 - 6 out of 10 pages.

From the ACCOUNT, we can find the CUSTOMER to whom the order belongs to. CUSTOMER ID Name Address Phone DateOfBirth PrimaryLanguage ACCOUNT AccountNo Balance LastPaymentAmount LastpaymentDate Type ORDER OrderID OrderDate CreditAuthStatus ITEM ItemNo Description Color Size Pattern Type EMPLOYEE ID Name Address Phone DateOfHire Title Age Salary {Skill} BRANCH BranchNo Address SquareFootage DEPENDENT Name Age Relationship Places ConsistsOf Sells PlacedAt Uses Works In Contains Quantity Quantity Has
Image of page 4

Subscribe to view the full document.

IS112 Data Management Extra In-Class Exercise 1 Page 5 9. EMPLOYEE EmpNO Name BirthDate JobTitle Married Date DEPARTMENT Name Phone VENDOR Name Address CITY Name State Population SKILL SkillNO Description PROJECT_ASSIGN MENT StartDate EndDate PROJECT ProjectNO EstimatedCost Marries to Reports to owns has has ASSOCIATION IsMainCity has has EQUIPMENT SeriesNo Name Description PURCHASE ORDER No Date [TotalPrice] issues has PURCHASEITEM UnitPrice Quantity has has uses Note: The Marries To relationship between EMPLOYEE and EMPLOYEE could be ignored if the question had asked for Married Date but not the spouse information. MarriedDate should then be an attribute of Employee
Image of page 5