This will help you determine your data model and database design. One department is supported by one
Fantastic news! We've Found the answer you've been seeking!
Question:
This will help you determine your data model and database design.
One department is supported by one or more employee(s)
One employee applies one or more skill(s)
One customer submits one or more purchase(s)
One product can be delivered for one or more purchase(s)
Entity - CUSTOMER, INVOICE, PURCHASE, EMPLOYEE, DEPARTMENT
Attribute - Address, City, Province
2- Add an EMPLOYEE entity with the identifying attributes FirstName and LastName
3- Add the Position and Salary regular attributes to the EMPLOYEE entity
Could you please check if it is correct?
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date: