Draw a relational schema for your 3NF relations

Assignment Help Database Management System

Reference no: EM131619251

Task - Normalisation

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;

Attachment:- Assignment File.rar

Reference no: EM131619251

Questions Cloud

How far did the motorcycle go before if broke down : A motorcycle breaks down and the rider has to walk the rest of the way towork. How far did the motorcycle go before if broke down?

Significant figures for expression : a. Please determine the number of significant figures for each expression

Discuss how regions of the universe change over time : Drawings A and B each represent a different way of thinking about how regions of the universe change over time

Discuss about the level of significance : A simulation model of a job shop was developed to investigate different scheduling rules. To validate the model, the scheduling rule currently used.

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

Prove de morgans law for arbitray unions and intersections : Prove De Morgan's law for arbitray unions and intersections. Show that set of all rational numbers is countable.

Discuss knowledge into electronic prescribing : Should information systems change to integrate this knowledge into electronic prescribing. Why or why not

Discuss components does not belong to the earth system : Which of the following components does not belong to the Earth system

Explaining the companys financial stress : Discuss the ethics and governance in explaining the company's financial stress. Was liabilities a major factor contributinng to the liquidation of the company?

Reviews

len1619251

8/30/2017 3:38:30 AM

As per the requirements, please do not send me ZIP, send me MS Word file instead. 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

Database Management System Questions & Answers

Describe the entities of the database

Based on your research and / or common knowledge of a college and the information tracked by a college, describe the entities of the database and the attributes of each entity

Measurement of two lengths in feet and inches

"create a form with textboxes to enter the measurement of two lengths in feet and inches as integer values and compute the total length in feet and inches. For example, the total length of 5 feet 8 inches and 4 feet 6 inches is 10 feet 2 inches; a..

Develop a system sequence diagram for each use case

Write out the steps of the dialog between the user and the system for the use case Place new order for nursing home employees.

Define the benefits of use-case modeling

Describe the biggest challenge to the successful use of use-case modeling and recommend how to overcome the challenge.

Create the tables and relationships from the database

Refer to the database design crested in Lab 2: Modifying a Database Design to complete this Lab. Create the tables and relationships from the database design discussed in Lab 2. Add at least five (5) records into each table (Note: You must determine ..

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