Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management System MCQs Multiple Choice Questions And Answers

Authors: Arshad Iqbal

1st Edition

1073328554, 978-1073328550

More Books

Students also viewed these Databases questions