Question: Data Model . Data models are a reflection of how the business operates. Only when there is a foundational change in the business process and

Data Model. Data models are a reflection of how the business operates. Only when there is a foundational change in the business process and culture will the data model change. However, the database design changes frequently driven by human resources, budgets, and technology.

Design a conceptual data model in Crow feet notation of what the database design above in Microsoft Access portrays.The conceptual data model and its relationships are not the same as the database design. You would need to determine the entities and relationships that fit the database design. The data model focuses on the correctness of notation, functional dependencies, relationships, cardinalities, attributes, and entities.

Managers ManagerFirstName ManagerlastName ManagerTitle EmployeeFirstName EmployeeLastName Employee Title Sales Company Name RecipientFirstName RecipientLastName Product Quanity Address Apt City Province PostalCode PricePerUnit TotalPrice Sales ManFirstName Sales ManLastName Operation Expenses Employee First Name/VendorName EmployeelastName Paymenttype Payment Amount Payment Date Address Quanity Apt Province Postal Code Comments

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!