Draw a dependency diagram

Assignment Help Database Management System

Reference no: EM131616929

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.

Attachment:- Assignment File.rar

Reference no: EM131616929

Questions Cloud

Describe and define internal and external analysis : Describe and define internal and external analysis. Describe and define the responsibilities and duties of the Strategic Manager.

Resources suppliers and resources buyers : How do long term contracts between resources suppliers and resources buyers affect the length of the time it takes for the economy to move from b to c in figure

Discuss approaches to handling crime in society : discuss the benefits and problems associated with each of these approaches to handling crime in society

Economics-statistics administration : According to the Economics & Statistics Administration from the United States Department of Commerce, one of the reasons that exports

Draw a dependency diagram : Draw a dependency diagram to show the functional dependencies in the relation. Create an ERD that represents your 3NF relations

Discuss an effective media relations capability : What steps you would take to establish an effective media relations capability. Describe them in detail

Discuss how much time you think you will need to spend : Discuss how much time you think you will need to spend each week for this accounting class. Do you have any concerns in completing the homework?

Discuss separate from cyber crimes : , what are some other ways criminals are becoming more sophisticated in their devious ways

How you would decide which design to use for an evaluation : Discuss how you would decide which design to use for an evaluation. Identify potential weakness of each of design and provide examples to support your findings.

Reviews

len1616929

8/28/2017 8:25:48 AM

Australian student, need it as per the guidelines, I have attached my assessment need, can you please tell me how much it will cost me. Thank You. Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema or the ERD is NOT acceptable. Rationale - This assessment aligns with the following subject outcomes: be able to critically analyse a database design and apply normalisation theory and techniques;

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