Task -, Ask an Expert

Programming

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

View complete question

DBMS, Programming

Category:- DBMS
Reference No.:- M92427961
Price:- $40

Guranteed 36 Hours Delivery, In Price:- $40

Have any Question?Write your Review or question?

Related Questions in DBMS

Suppose that you have designed a database for morgan

Suppose that you have designed a database for Morgan Importing that has the following tables: EMPLOYEE (EmployeeID, LastName, FirstName, Department, Phone, Fax, EmailAddress) STORE (StoreName, City, Country, Phone, Fax, ...

Question sql injection is in the top 10 owasp and common

Question : SQL Injection is in the top 10 OWASP and Common Weakness Enumeration. Using MySQL and PHP, show your own very short and simple application that is vulnerable to this attack. Provide another version that mitiga ...

A schools office of the registrar maintains data about the

A School's office of the registrar maintains data about the following entities: a) courses (including course number, title, credits, syllabus and prerequisites), b) course offerings (including course number, year, semest ...

Question we can sort a given set of n numbers by first

Question : We can sort a given set of n numbers by first building a binary search tree containing these numbers (using TREE-INSERT repeatedly to insert the numbers one by one) and then printing the numbers by an inorder ...

The system development team at the xyz company is working

The system development team at the XYZ Company is working on developing a new customer order entry system. In the process of designing the new system, the team has identified the following data entity attributes: Invento ...

Question create an erd for the following scenario once you

Question: Create an ERD for the following scenario. Once you submit you will get access to the correct way to create the ERD. Please watch the video and correct any errors in your submission and resubmit. A small company ...

Relational database exerciseyou have been assigned to a new

Relational Database Exercise: You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. ...

Data mining assignment -in this assignment you are asked to

Data Mining Assignment - In this assignment you are asked to explore the use of neural networks for classification and numeric prediction. You are also asked to carry out a data mining investigation on a real-world data ...

Your taskyou have been commissioned to develop a database

Your task You have been commissioned to develop a database system that is capable of keeping records for FU's table tennis matches from now on. The database needs to keep a record of: - All team information, including pl ...

Assignmenta restaurant is designing a database to keep

Assignment A restaurant is designing a database to keep track of customer services. A customer is defined as a customer ID, name, address and a telephone number. Customers are served by employees. Each employee is define ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask DBMS Expert