Hi,
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
Checklist
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.
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 convert them to Rational DB, I can do its Normalization up to 3rd Normal form. I can show you my previous work related to DB. Please see my profile and reviews as well. Thanks
€150 EUR w 7 dni
4,8 (18 opinii)
5,3
5,3
7 freelancerzy składają oferty o średniej wysokości €157 EUR dla tej pracy
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`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-end API apps.
Especially, I am a senior in MYSQL and SQLite.
Database construction by using these MYSQL is no problem at me.
I can finish your job asap.
If you hire me, I will do my best for you and I can complete this job within your timeline successfully.
If there is any thinking about that, please contact me.
From your friendly developer..
Best regards !!
Thanks
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.