Exam (elaborations)
WGU C170 VHT1-0514 IT-MANAGEMENT OF DATA APPLICATION
- Course
- Institution
WGU C170 VHT1-0514 IT-MANAGEMENT OF DATA APPLICATION
[Show more]
Seller
Follow
LeCrae
Reviews received
Content preview
C170, VHT1-0514 IT-MANAGEMENT OF DATA APPLICATION 1WGU C170, VHT1-0514 IT-MANAGEMENT OF DATA APPLICATION
C170, VHT1-0514 IT-Management of Data Application
XXXXXXXXX
Western Governors University
WGU Student ID
, C170, VHT1-0514 IT-MANAGEMENT OF DATA APPLICATION 2
A.1.a 1st Normal form
Primary Key for the table is DonutInvoiceID.
I chose to create a 1st Normal Form table by selecting a primary key of the
DonutInvoiceID. Every field in the 1st form table can be tied to the DonutInvoiceID column.
During the 1st form normalization step I insured that each column possessed atomic single values
and there was no repeating data in each row. 1st form normalization however has left much of
the data redundant throughout the entire table. All non-calculated data from the Invoice Slip has
figured into a column within the 1st form normalization table above.
A.1.b 2nd Normal form
Primary Key is DonutInvoiceID
, C170, VHT1-0514 IT-MANAGEMENT OF DATA APPLICATION 3
Primary Key is a composite of DonutInvoiceID and DonutID
Primary Key is DonutID
During the 2nd normilization step I elected to create three tables. Table one is the Invoice
table. Every column in it is functionaly depenant upon the DonutInvoiceID column. The second
table is the InvoiceLine table. It has a composite key of DonutInvoiceID and DonutID and
contains the intersection data bewtween the Invoice table and the Donut table as quanity. The
third table created is the Donut table and it primary key is DonutID. All columns are functionaly
dependant upon the DonutID.
A.1.c 3rd Normal form
Primary Key is DonutInvoice ID
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 LeCrae. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
76669 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now