Create an ERD that represents your 3NF relations

Assignment Help Database Management System

Reference no: EM131625746

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: EM131625746

Questions Cloud

Levels of the public health pyramid : A health program planning committee wants to address various health problems by developing programs for each health problem at all four levels of the public.

Discuss about the george dukas case : George Dukas is a delivery man for Poquito Banana Company. He is also a big jokester. One day, while delivering bananas to the Shoppers Food Mart in Hialeah.

Developmental differences between first graders : Given the developmental differences between first graders and fifth graders, how would 'self-management' be behaviorally observed at each age level?

Management department of a major retailer : Assume you have been hired by me to work in the management department of a major retailer, such as Wal-Mart. We are having trouble with some colleagues.

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

Research the merits of patent protection in lilys situation : Conclude with a determination on whether a patent would benefit Lily Dance Fitness, and provide a rationale for your answer.

Governs workers compensation for the state : The state workers' compensation board that governs workers' compensation for the state that your company resides andperforms all of its business in

Critical vulnerabilities on the public facing website : Issue in this scenario is why are there critical vulnerabilities on the public facing website to begin with?

Test data transactions in a payroll processing program : Use the computer-based electronic audit documentation on the textbook website to perform a test of the computerized payroll processing program.

Reviews

len1625746

9/4/2017 1:46:21 AM

Australian student, need it asap and as per the guidelines. I NEED MY ASSIGNMENT ON PDF FORMAT AND REFERENCES IN ASSIGNMENT TOO. Student name and ID will be available with start working email. NOTE - 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.

len1625746

9/4/2017 1:46:14 AM

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. 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.

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