Write some software
$10-30 USD
货到付款
I need you to develop some software for me. I would like this software to be developed using SQL. Create an ER Diagram representing the invoices below. This may be hand-drawn if necessary.
Convert the ER Diagram to a relational schema.
Normalize the schema.
Develop the DDL for the schema.
Create the tables (i.e. execute the DDL) in Access (or MySQL).
Populate the tables with data taken from the invoices.
Develop SQL to answer these two queries:
How many parts did Jim Shoe purchase in November, 2006?
What was the total amount of all purchases by Speed Racer?
Please submit:
1. ER Diagram
2. DDL
3. SQL queries
4. Output from the query execution (may be a screen shot).
项目ID: #10704238
关于项目
授予:
I have developed several databases during my projects and currently at my work one of the main technologies that I work on is MySQL. I can definitely finish the task in time.