Show the functional dependencies in the relation

Assignment Help Database Management System

Reference no: EM131635267

Assessment item - Normalisation

Task -

Prod_code	Prod_Name	Purchase_date	Qty_sold	Prod_price	Inv_No	Inv_Date	Vendor_ID	Vendor_Name
ES12345	Esky Soft Cooler	12/7/2016	60	19.50	B-5565	17/7/2016	112	Innisfail
MAK2347	Angle Grinder	15/9/2016	10	85	B-5570	18/9/2016	106	RC Tools
KAR62705	High Pressure Cleaner	13/10/2016	50	190	B-5572	18/9/2016	103	Ardonly
AEC25874	Circular Saw	15/9/2016	15	119	B-5570	18/9/2016	106	RC Tools
ES2396	Water filter	20/8/2016	45	26.50	B-5585	25/8/2016	112	Innisfail

Using above table

1. Draw a dependency diagram to show the functional dependencies in the relation.

2. Decompose the relation into a set of 3NF relations.

3. Draw a relational schema for your 3NF relations and show the referential integrity constraints.

4. Create an ERD that represents your 3NF relations.

Rationale -

This assessment aligns with the following subject outcomes: be able to critically analyse a database design and apply normalisation theory and techniques;

Reference no: EM131635267

Questions Cloud

Compound is present in its respective solution : What is the equation and show me a sketch showing the form in which the compound is present in its respective solution.

Identify one health policy that nurses : Identify one health policy that nurses have been actively involved in and discuss how the policy is being integrated into the Affordable Care Act

What is the molarity of a hcl solution : What is the molarity of a HCl solution if 5.00 ml is neutralized by 28.6 ml of a 0.145 M NaOH solution?

What agencies he relied on to provide relief : Beliefs that guided him in his attempt to solve it What he told Americans they had to do to overcome the Depression

Show the functional dependencies in the relation : Assessment item - Normalisation. Draw a dependency diagram to show the functional dependencies in the relation

Limiting reactant problem : A mixture of 1.50 mol of Al and 3.00 mol of Cl2 is allowed to react. How many moles of AlCl3 are formed according to the following balanced equation?

Pick an organic molecule : Pick an organic molecule that has a functional group such as, ethanol. PLEASE FIND A UNIQUE molecule that has not been discussed previously by a classmate.

Implications for american society : Imagine you are a newspaper reporter, magazine writer, or radio newsperson - Implications for American society in terms of economic, social, and cultural trends

Learned about the acid-base properties : Based on what you have learned about the acid/base properties of Al3+ in aqueous solution, what side product might be produced in this reaction if too much.

Reviews

len1635267

9/9/2017 7:19:49 AM

Australian student, need it as per the guidelines. For guidance on how to normalise database relations from a dependency diagram. Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema or the ERD is NOT acceptable. Analysis identifies all PKs and functional, partial and transitive dependencies. Accurately identifies all 3NF relations, including PKs, relevant attributes and referential integrity constraints. Creates an ERD that represents all 3NF relations and includes all entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities. Either save your diagrams in a PDF file or embed them in a Word document. Don't use any other file formats. Please include your student ID, name and subject code in your submission. Submission Method: Turnitin. Details will be provided by the lecturer during the session.

Write a Review

Required(*) Message

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages