INDIVIDUAL PROJECT PHASE I

IN ORDER TO GET FULL CREDIT YOUR WORK MUST NO MATCH THAT OF ANY OTHER STUDENTS.

You are a consultant that have been hired by XYZ company to provide a project proposal to design and implement a database management solution. Currently, XYZ does not have in place a repository database where they can centralize all their information.

XYZ would like to have in place a Database system that would allow them to centralize all their data in order to create reports and easy management of records.

Each question is worth 25 pts.

Write about the benefits of implementing a Database System. No less than 200 and no more than 500 words.

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.

Online shopping database system

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.

Create an ERD Diagram.