CUSTOMERID INT (fk) DONUT_ORDER_ID INT (pk) ers
QUNOATENSTIVTYARTCAHBLA
ER (255)
QUANTITY INT
DONUT_ORDER_ID INT (pk) (fk) DONUT_ID INT (pk)(fk)
ORDER TABLE
DATE DATETIME
1:M
One Customer can place many Ord Customer table has single pk DONUT TABLE DONUT_ID INT (pk)
DONUT_NAME VARCHAR (100)
DONUT_DESCRIPTION VARCHAR (255)
UNIT_PRICE DECIMAL (10,2)
WGU c170 PROJECT WITH COMPLETE SOLUTION
1NF 2NF
Highlighted fields will form a Composite primary key. City State and Zip were separated And are now atomic
DONUT ORDER ID (PK)
(FK)
QUANTITY
DONUT ID (PK)(FK)
No duplicate data, each of the above tables has a Primary Key, and a key (foreign) that can refer to another table in the group.3NF No of Keys.transitive dependency. New table has 2 the PKs from the other tables as Foreign
ER DIAGRAM
Each table has a primary key which can refer to another one of the tables in this group.
DONUT ORDER ID
DONUT ID
DATE
CUSTOMER ID
LAST NAME
FIRST NAME
STREET ADDRESS
CITY STATE
ZIP CODE
HOME PHONE
MOBILE PHONE
OTHER PHONE
DESCRIPTION
QTY
UNIT PRICE
NOTES
DONUT NAME
DONUT ORDER
ID(PK)
DATE
CUSTOMER ID
LAST NAME
FIRST NAME
STREET ADDRESS
APT CITY STATE
ZIP CODE
HOME PHONE
MOBILE PHONE
OTHER PHONE
NOTES
DONUT ID (PK)
DONUT NAME
DONUT DESCRIPTION
UNIT PRICE
CUSTOMER ID (PK)
LAST NAME
FIRST NAME
STREET ADDRESS
APT CITY STATE
ZIP CODE
HOME PHONE
MOBILE PHONE
OTHER PHONE
DATE
CUSTOMER ID (FK)
NOTES
DONUT ORDER ID
(PK)
DONUT ORDER ID
(PK)(FK)
QUANTITY
DONUT ID (PK)(FK)
DONUT ID (PK)
DONUT NAME
DONUT
DESCRIPTION
UNIT PRICE 1 / 2
CUSTOMER TABLE
CUSTOMER_ID INT (pk)
LAST_NAME VARCHAR
(30)
FIRST_NAME VARCHAR (30)
STREET_ADDRESS VARCHAR (100)
APT INT,
CITY VARCHAR (30)
STATE VARCHAR (30)
ZIP_CODE INT
HOME_PHONE VARCHAR (20)
MOBILE_PHONE VARCHAR (20)
OTHER_PHONE VARCHAR (20)
WGU c170 PROJECT WITH COMPLETE SOLUTION One order can have many different quantities
1:M
of donut types One donut order can hold many different quantities of donut types
1:M
create table customers( customer_i d INT,
- / 2