Decompose the relation into a set of 3NF relations

Assignment Help Database Management System

Reference no: EM131626609

Assessment - 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: EM131626609

Questions Cloud

Manages your finances electronically : For an eBanking system that manages your finances electronically, how confident are you that the online services offered by your bank are robust.

Discuss relevant case law and legal principles : Martina, a young opera singer signed a 5-year contract with an agency called Stars & Extras(‘S & E'). The contract stated she would obtain all of her singing

What are the risks and benefits of the outsourcing approach : What are the risks and benefits of the outsourcing approach? What are the strategic advantages of outsourcing to vertically integrated firms?

Variables often confuse the novice programmer : Variables often confuse the novice programmer. What are variables? How do we define/declare them and why?

Decompose the relation into a set of 3NF relations : Draw a dependency diagram to show the functional dependencies in the relation and Decompose the relation into a set of 3NF relations

Industry certification is critical for it workers : Industry certification is critical for IT workers. It is important to have three main things when you graduate from college:

Evaluate role their inventory plays in companys performance : Evaluate the role their inventory plays in the company's performance, operational efficiency, and customer satisfaction.

Define what obligation do parties involved in business deals : Planned Pethood Plus, Inc., is a veterinarian-owned clinic. It borrowed $389.000 from keybank at an interest rate of 9.3 percent per year for ten years

Ptolemaic and copernican models of the solar system : Briefly describe the Ptolemaic and Copernican models of the solar system. What was the basic flaw of the Ptolemaic system? Is the Copernican model also flawed?

Reviews

len1626609

9/4/2017 8:09:20 AM

Australian student, need it as per the guidelines, no similarity or plag issue please, and I need assignment in pdf file and with some good references. NEED IT ON TIME. NOTE - For guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: https://www.voutube.cornAvatch?v=vkllyuLLcumvQ Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema or the ERD Is NOT acceptable.

len1626609

9/4/2017 8:09:15 AM

Analysis identifies al PKs and fundknal, partial and transitive dependencies. Accurately declares all 3NF relations, including PKs. relevant attributes and referential Integrity constraints. Creates an ERG that represents all 3NF relations and Includes all entities, PKs, atbibutes. relationships, associative entities Of pplical0), cerdinarniers and optionaitios. Requirements - 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: Tumilin. 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