• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 2 out of 15 pages
Exam (elaborations)

WGU C170 Objective Assessment With Complete Solution

Document preview thumbnail
Preview 2 out of 15 pages

WGU C170 Objective Assessment With Complete Solution

Content preview

WGU C170 Objective Assessment – Edward M Burke
bb bb bb bb bb bb bb




First Normal Form – 1 Table
bb bb bb bb bb




I gleaned this table from the unstructured data contained within
bb bb bb bb bb bb bb bb bb




bb the order form. I made sure not to have any redundant groups,
bb bb bb bb bb bb bb bb bb bb bb




bb and each column in the table will contain atomic values. Donut ID,
bb bb bb bb bb bb bb bb bb bb bb




Donut Name, Donut Quantity, Unit Price, and Donut Description are
bb bb bb bb bb bb bb bb bb bb




bb an example of a repeating group. As I mentioned earlier, in order
bb bb bb bb bb bb bb bb bb bb bb




bb to achieve first normal form, we must eliminate
bb bb bb bb bb bb bb




repeating groups. This requires the use of a composite key made up of
bb bb bb bb bb bb bb bb bb bb bb bb




bb Donut Order ID and Donut ID.
bb bb bb bb bb




Second Normal Form – 3 Tables
bb bb bb bb bb




In order to achieve second normal form we need to split
bb bb bb bb bb bb bb bb bb bb




the first table into three separate tables so that all non-
bb bb bb bb bb bb bb bb bb bb bb

, key attributes are functionally
bb bb bb




dependent on the entire primary key.
bb bb bb bb bb bb




I took the attributes that are partially
bb bb bb bb bb bb bb




dependent on the primary key, and
bb bb bb bb bb bb




placed them into separate relations.
bb bb bb bb bb




Donut Name, Donut Description, and
bb bb bb bb bb




Unit Price depend only on Donut
bb bb bb bb bb bb




Order ID. Donut Quantity and Item
bb bb bb bb bb bb




Total depend on both Donut Order ID
bb bb bb bb bb bb bb




and Donut ID.
bb bb bb

Document information

Uploaded on
July 25, 2025
Number of pages
15
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
$13.49

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
PageTurners
3.0
(2)
Sold
13
Followers
0
Items
1608
Last sold
10 months ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions