Question: Create a Database Model for the following description: [The model should show all entities, relationships between entities and cardinality including mandatory-optional requirements.] XYZ is an

Create a Database Model for the following description:

[The model should show all entities, relationships between entities and cardinality including mandatory-optional requirements.]

XYZ is an online retailer that sells apparel and accessories. The company offers fashionable and affordable clothing, shoes and accessories.

XYZ has enjoyed steady sales and earnings growth and has a need to automate their reporting system. The company needs a database that will record sales, gather customer information, and provide stock information.

The system will store information for each customer like name, address, phone number, and email. The system will use unique IDs assigned to each customer for recording transactions. The system will use unique IDs for each inventory item. Customers will also be able to track their orders with a unique tracking number.

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 Databases Questions!