create Data Model diagram. I have the following information's: 1- This will help you determine your data
Question:
create Data Model diagram. I have the following information's:
1- 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
4- Add the following entities to your diagram by referencing the Operating Model section on the first page of this document
DEPARTMENT, EMPLOYEE, CUSTOMER, PURCHASE, PRODUCT, SKILL
4- Add the cardinalities between the entities based on the Operating Model
5- Label each relationship according to the verb is specified in the Operating Mode
There is a DepartmentName, ProductName, FirstName, and LastName. In other cases an entity can be identified by its own attributes and the identifying attributes of its parents. PURCHASE is identified by FirstName, LastName, Product, and PurchaseDate. SKILL is identified by FirstName, LastName, and SkillName.
6. Examine each column headings from your .CSV files and add the appropriate attributes and identifying attributes to your data model diagram. For Employee Name and Customer Name add FirstName and LastName. For Address add Addresses.
7- Confirm SKILL and PURCHASE have the correct identifying attributes
8- Confirm PRODUCT has the ListedPrice attribute and PURCHASE has the PurchasePrice attribute.
9- Confirm CUSTOMER has the Company attribute
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George