Simple Database task. Draft Database


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

the data.

4. Put the ER diagram and the description in a single word file. Zip the word file and the SQL

file together

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

including comments.

Habilidades: Administração de Bancos de Dados, Desenvolvimento de Banco de Dados, Programação de Banco de Dados, MySQL, SQL

Veja mais: simple coldfusion customer database, simple php mysql database, day sales tracker, database planning example, it 204 milestone three, birchwood lane schools database, 7-2 final project: database proposal and implementation plan report, task access database, designing day sales plan, simple task list php, develop simple task, simple form script database, database synchronization xml day, simple projects based database, sample simple task describe, simple website login database, simple login logout database, simple cms access database, how do sales agents get paid, I am seeking a virtual assistant to do a simple task every day

Acerca do Empregador:
( 2 comentários ) Dublin, Ireland

ID do Projeto: #18913599

Concedido a:


I am a Database Developer. I have 5 years of experience working with SQL/MYSQL and Oracle. I am currently working on SQL server 2008 and Oracle10g. I can Develop you ER Diagrams (Crows foot notation), EERD, I can conve Mais

€150 EUR em 7 dias
(16 Comentários)

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

€222 EUR in 10 dias
(17 Comentários)

Hi Sir, I have reviewed your job description as well & very confident to handle this project perfectly. I'm confident you will be happy with my job.I always have a clear focus on delivering results. I am expert in W Mais

€50 EUR in 3 dias
(7 Comentários)

I am a Senior Web Developer. I have 7+years experience of developing web sites. You can see my skills through these sites what i have built. [login to view URL] [login to view URL] -> mobile J Mais

€222 EUR in 3 dias
(5 Comentários)

Hi I`m very interested in your job. And I have read your task description very carefully. I have over 11 years of development experiences for SPA(Single Page Application) and Complex website and Integration Back-e Mais

€155 EUR in 3 dias
(4 Comentários)

Hi. I've read your description. I'd welcome the opportunity to discuss the project in more details. Thank you. Alyona.

€220 EUR in 3 dias
(2 Comentários)

Hi, I can design database. I have a good experience in it. Looking forward to work with you. Regards

€80 EUR in 7 dias
(4 Comentários)

Hello, After reading this job description, I am convinced that I would be a perfect fit for this role. That is because of - I am a PHP expert who has 12 years of experience with laravel, codeignitor, wordpress/MyS Mais

€30 EUR in 3 dias
(5 Comentários)