(THIS QUESTION HAS BEEN REJECTED MULTIPLE TIMES, PROVIDE PROPER REASONING BEFORE YOU REJECT AGAIN, NOT LOOKING TO FILL ALL THE DATA IN THE TABLE BUT SAMPLE QUERIES) I need with sql queries to create a database and appropriate tables as listed Need tables created, set constraints on attributes, set the relationship between the entities in the DB

(THIS QUESTION HAS BEEN REJECTED MULTIPLE TIMES, PROVIDE PROPER REASONING BEFORE YOU REJECT AGAIN, NOT LOOKING TO FILL ALL THE DATA IN THE TABLE BUT SAMPLE QUERIES) I need with sql queries to create a database and appropriate tables as listed Need tables created, set constraints on attributes, set the relationship between the entities in the DB. (Looking for detailed SQL queries.) example: CREATE DATABASE my_records; use my_records; Create Tables CREATE TABLE `parts` ( `parts_num` varchar(255) NOT NULL, `description_parts` varchar(255) NOT NULL ); Transcribed Image Text: This is a simple list table of a company trying to keep track of parts that they sell and orders that came in purchasing
those parts (in other words, not a database but a flat one table file). You will design a database for this company so that
they won’t be relying on a simple 1 table list system to keep track of their data. Looking at the table below, identify the
separate entities and attributes and design a logical level Entity Relationship Diagram for this company.
OrderNum
OrderDate
PartNum
Description
NumOrdered
QuotedPrice
10/20/2010
10/20/2010
10/20/2010
$21.95
$495.00
$399.99
$329.95
$595.00
21608
AT94
Iron
11
21610
DR93
Gas Range
1
21610
DW11
Washer
1
10/21/2010
10/21/2010
10/23/2010
10/23/2010
21613
KL62
Dryer
4
21614
КТОЗ
Dishwasher
Home Gym
$794.95
$150.00
$495.00
$1290.00
21617
BV06
2
21617
CD52
Microwave Oven
4
10/23/2010
10/23/2010
21619
DR93
Gas Range
1
21523
KV29
Treadmill

-25-


Buy plagiarism free, original and professional custom paper online now at a cheaper price. Submit your order proudly with us



Essay Hope