NB: CREATE A DATABASE SYSTEM WITH NECESSARY CODES SO I CAN RUN THEM

Design a Database for an enterprise. From a database perspective it is a special store that has no physical location and has anonymous customers. Various user interfaces and applications access the database to record sales, initiate reorders and new orders that arrive. You can use Walmart or best buy as your enterprise.

The table should contain the following:

CUSTOMERS; CustomerID Lname Fname

STORES; StoreID, City, telephone, address

CUSTOMERS; CustomerID, Lname, Fname.

ORDERCOST; PurchaseOrder, PurchaseDate, GoodsID, Quantity

You can add any table needed for an enterprise if needed.

You can design and develop one application system in real life.

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.

3. Populate Relations

Include enough data to make answers to your queries interesting and

nontrivial for test purposes.

You may find it is helpful to write a program to generate test data.

4. Queries: You should run a number of test queries to see that you have loaded your database in the way you intended. The queries listed below are those that your clients (managers from the retail enterprise) may find of interest.

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.

These interfaces can be built as

Web applications using Java applets or a scripting language.

Other GUI development tools you may know

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.