SIT103/SIT772: Database Fundamentals4.1P: NormalisationOverviewIn this task, you will learn how to...

Question

SIT103/SIT772: Database Fundamentals4.1P: NormalisationOverviewIn this task, you will learn how to draw dependency diagram and normalize a given database.Tasks to do1. Using the INVOICE table structure shown in Table 1 (note that in this table rows are attributes and columnsare data records), draw its dependency diagram and identify all dependencies (including all partial andtransitive dependencies). You can see that an invoice has more than one product and a product is in morethan one invoice. From the business rules, we know that a product is supplied by one vendor only, but a vendor can supply many products.Note that you fist need to determine the Primary Key to identify partial and transitive dependencies. What do you think can be the Primary Key in this table? Note that it is a minimal candidate key that can uniquelyidentify every records.Submit one PDF/WORD file showing all step/process of normalization and answering all questions above

Dikchha · Accepted Answer

1.    
2.
3.
4. Explanation 
· Justification for 3NF-A relation is in third normal form if it holds atleast one of the following conditions for every non-trivial function dependency X → Y.
1. X is a super key.
2. Y is a prime attribute, i.e., each element of Y is part of some candidate key.

SIT10 3/SIT772 : Database Fundamentals 4 .1 P : Normalisation Overview In this task, you will learn how to draw dependency diagram and normalize a given database. Tasks to do 1. Using the INVOICE...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment