* The database that is going to be designed is Online shopping database system *

1. Develop a list that includes all the major entities (tables) needed for your propose Database System. You also need to provide a brief discussion for each entity. You need to have at least 7 and no more 12 tables for the project. See example below:

Entity	Entity Attributes	Description
Customer	Customer_ID	The customer entity captures information about the customer attributes. The entity attributes contain detail information about the customer identity which allows the company XYZ to better understand who they are working with.
	Customer_FirstName
	Customer_MiddleName
	Customer_LastName
	Customer_CompanyName
	Customer_CompanyTitle
	Customer_Address
	Customer_City
	Customer_Region
	Customer_PostalCode
	Customer_Country
	Customer_Phone
	Customer_Email

This is just an example, depending on the database systems you are designing your entities will be different.

3. Provide information about how these entities relate to each other. Refer to entity relationships (one to one, one to many, many to many).

Example:

A customer can have many orders and an order can have only one customer.

4. Create an ERD Diagram.