Question
ED needs to create a database to track their customers. Each customer receives a permanent ID when they call in. While on the phone, they
ED needs to create a database to track their customers. Each customer receives a permanent ID when they call in. While on the phone, they also gather information regarding the customer's name, address, and email. A customer can have multiple emails, but we need only one email to be on the order. Customers can be of two types individuals and corporate. Corporate customers have a tax id number that has to be stored by the company.
EDs products are stored in a back room. The employee sends the products to the address on file for each specific order. ED wants to track which employee packed the products for each order (one employee is assigned to each order). Employees first and last name, address, phone numbers, and how long the employee has worked for the company needs to be tracked.
Draw an object model that shows the necessary data components for the database in ST's new system. Include all cardinality and if you make assumptions please note them.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started