Exam (elaborations)
WGU c170 PROJECT WITH COMPLETE SOLUTION
- Course
- Institution
WGU c170 PROJECT WITH COMPLETE SOLUTION
[Show more]
Seller
Follow
Classroom
Reviews received
Content preview
WGU C170 PROJECT WITH COMPLETE SOLUTION1NF 2NF
DONUT ORDER ID
DONUT ID DONUT ORDER
Highlighted fields will form a DONUT ID (PK)
DATE ID(PK)
Composite primary key. City DONUT NAME
CUSTOMER ID DATE
State and Zip were separated DONUT DESCRIPTION
LAST NAME CUSTOMER ID
UNIT PRICE
FIRST NAME And are now atomic LAST NAME
STREET ADDRESS FIRST NAME
CITY STREET ADDRESS
STATE APT DONUT ORDER ID (PK)
ZIP CODE CITY (FK)
HOME PHONE STATE QUANTITY
MOBILE PHONE ZIP CODE DONUT ID (PK)(FK)
OTHER PHONE HOME PHONE
DESCRIPTION MOBILE PHONE
QTY OTHER PHONE
UNIT PRICE NOTES
NOTES No duplicate data, each of the above tables has a Primary Key, and a key
DONUT NAME (foreign) that can refer to another table in the group.
3NF
CUSTOMER ID (PK)
DATE
LAST NAME
CUSTOMER ID (FK)
FIRST NAME
NOTES
STREET ADDRESS DONUT ORDER ID
DONUT ORDER ID
APT (PK)(FK)
(PK)
CITY No QUANTITY transitive dependency. New table has 2
STATE of DONUT ID (PK)(FK) the PKs from the other tables as Foreign
ZIP CODE DONUT ID (PK)
Keys.
HOME PHONE DONUT NAME
DONUT Each table has a primary key which can refer to another one of the
MOBILE PHONE
DESCRIPTION tables in this group.
OTHER PHONE
UNIT PRICE
ORDER TABLE
DATE DATETIME
1:M CUSTOMERID INT (fk)
DONUT TABLE
DONUT_ORDER_ID
DONUT_ID INT (pk) INT (pk)
One Customer can place many Orders
DONUT_NAMEQUANTITY
NOTES TABLE
VARCHAR
VARCHAR (255)
(100)
ER DIAGRAM Customer table has single pk
QUANTITY VARCHAR
DONUT_DESCRIPTION INT (255)
DONUT_ORDER_ID
UNIT_PRICE DECIMAL (10,2) INT (pk) (fk)
DONUT_ID INT (pk)(fk)
, One order can have many
different quantities
1:M
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) One donut order can hold
OTHER_PHONE VARCHAR (20) many different quantities
of donut types of donut types
1:M
create table customers(
customer_id INT,
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Classroom. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
70055 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now