I need you to design and implement a database for an online
retailer. This is a draft.
1. Choose an online retail business
2. Create the database design on a paper
3. Develop an ER Diagram
4. Develop the complete database on a computer
5. Add sufficient records
1. ER Diagram of the database in a Word Document
2. a one-page description of what you did and why including all necessary assumptions
3. One SQL file with all the relevant SQL statements to create the database, the tables and
4. Put the ER diagram and the description in a single word file. Zip the word file and the SQL
During Creating the database, the data must show
1. The most expensive item sold?
2. How much salaries have you paid in the last 3 months?
3. The total sales of your business for each day in the past 2 weeks?
4. Which customer spend the most money in your business?
Ensure you have:
ERD: A Complete and accurate descriptive ER diagram.
Description: A comprehensive description of the entities and the design assumptions
SQL Statements: A complete, working SQL containing the right DDL and DML statements
8 freelancers estão ofertando em média €141 para esse trabalho
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards
Hi. I've read your description. I'd welcome the opportunity to discuss the project in more details. https://www.freelancer.com/u/oneginaalyona Thank you. Alyona.