Amazon e-commerce database with design, implementation and reports

The project for database management will be to build an e-commerce database. The project is to be done in small groups and is due by the last day of classes. Use Amazon as an example e-commerce site and try to replicate the features of this site in your database (ie. should include features for users (buyers & sellers), products, reviews, categories, orders, etc.) You may need to create an Amazon account to explore the functionality of the website and to see what kinds of information they store for users and products.

The deliverables for this project are as follows;

1. A complete ERD, fully labeled, for the e-commerce site. You may include previous drafts of the ERD with notes and annotations explaining your process. I encourage teams to include a brief text explaining their process and design choices.
2. A data dictionary to accompany the final ERD. The data dictionary should fully explain the details of the ERD, and be reflected in the subsequent script files. 
3. A text file called Structure.sql which includes the SQL scripts needed to build the database based on the ERD. At the top of the file, before the CREATE TABLE statements, you must include DROP TABLE statements so that you can automatically drop and recreate tables as often as you need to. Note that in order to maintain referential integrity, you must create and drop tables in a particular order: For creating tables, you must first create the table on the one side of a one-to-many relationship (your first tables created must not be on the many sides of any relationship). For dropping tables, you must first drop the table on the many sides of a one-to-many relationship (your first tables dropped must not be on the one side of any relationship). Thus, you will drop tables in the reverse order that you create them.
4. A text file named “Population.SQL” with the data population script. You will need to populate the database with fictitious data that you invent. You will need to keep in mind what sort of queries you’ll be developing in the following deliverable, so your fictitious data should be able to support the reports you will make. You don’t need to have hundreds of rows of data for each table, but there should be sufficient information to support the complex reports developed in the following requirement. 
5. A text file named “Reports.SQL” with the SQL queries for reports. You will need to generate 10 reports using your database. Essentially, these reports are the results from specific queries that could be used for a real business purpose (ie. Perform an RFM analysis on the customers, determine which customers have the highest lifetime value, determine the order history for a specific customer, etc). Some reports may be very simple, while others should be more complex. Think about some business intelligence tasks that could be done using this data. 
6. A word processor file named “Screenshots” with the screenshots from the table listings from Structure.SQL and each of the reports from Reports.SQL. Essentially, these screenshots are to confirm that you ran these queries and they were successful. 
7. Each team member must submit a peer evaluation. The template for these peer evaluations is on Moodle. 

Organize your final deliverable in a professional manner. This is something you can show prospective clients and employers to give them an impression of the caliber of professionalism and quality of work you can be expected to produce.

Get Project Solution by contacting us

- via WhatsApp: +92-324-7042178
- via email: codelogixstudio@gmail.com