Design a database in MYSQL following these instructions;

NB: I need you to run you to create this database & provide me with the necessary DDL to run it & java codes

Enterprise description:

The enterprise is a retailer, such as a department store, discount store, supermarket, convenience store, etc.; each of you will choose a specific retailer (either use a real one as your model or a made-up one).

The enterprise: You may pick the enterprise that you will model. Id like to see a wide variety chosen, so here is a list to serve as starting point to give you ideas, but

other choices are welcome, indeed encouraged: Walmart, Target, Costco, BJs, Best Buy, American Eagle, Nordstrom, Safeway, Aldi, Albertsons, Acme, HEB, Food Lion, etc. You are encouraged to consider your favorite retailers.

products: product name, product id, product type, brand, etc.

stores: store id, zip code, address, telephone

customers: customer id, customer name, phone number

Order: including order id, product code or product id, customer id, store id, amount, price, actual price, date time, etc.

You will need to create a precise design in .docx file and your application database, and implement the interfaces and applications using the database by PHP/Java, etc..

1. E-R Model Construct an E-R diagram representing the conceptual design of the database.

Be sure to identify primary keys, relationship, etc.

2. Relational Model

• Create an initial relational design from your E-R design.
• Create the relations in SQL Server/MySQL/Azure database.
• Create primary keys and constraints as appropriate.
• If as you refine your design, you discover flaws in the E-R design, go back and change it. Your final E-R design must be consistent with your relational design.
• 4. Queries: You should run a number of test queries to see that you have loaded your database in the way you intended.
• 5. Interfaces: There are several types of users who access the database.
• The database administrator (you) may use SQL either via the command line or SQL Developer.
• Online customers need an elegant Web interface or other GUI to order products. (After all, this is a database course, not the Web Apps course, nor the User Interface course.) These interfaces can be built as
• Web applications using Java applets or a scripting language.
• Other GUI development tools you may know (Since this course is not a Java course, nor a GUI course)
• What to turn in:
• 1. The final version of the project is to be turned in as a report file (eg: word file), including (1) E-R diagram, plus any explanatory notes
• . (2) Relational schema.

(3) A set of sample queries.

(4) The code to implement the various interfaces.