functional dependencies, Database Management System

CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice)
This relation refers to options installed in cars (e.g., cruise control) that were sold at a dealership, and the list and discounted prices of the options.

If CarlD Sale date and Option _typo Option_hstprica and CarlD, Option_type Option_discountedprice, argue using the generalized definition of the 3NF that this relation is not in 3Nf. Then argue from your knowledge of 2NF, why it is not even in 2NF.
Posted Date: 10/16/2012 2:15:46 PM | Location : United States







Related Discussions:- functional dependencies, Assignment Help, Ask Question on functional dependencies, Get Answer, Expert's Help, functional dependencies Discussions

Write discussion on functional dependencies
Your posts are moderated
Related Questions
How is Oracle used in PL/SQL? Define the features of process and how they are defined? PL/SQL - PL/SQL is Oracle's procedural language (PL) superset of the Structured


as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen

When It is better to use files than a DBMS? It is better to use files than a DBMS when Multiple users wish to access the data.

State the meaning of Object Representation  The term object representation means "to represent object with the help of objects model symbols". Implementing objects is too simp

What kind of advantages to copying records from one table to another? -) When an algorithm that modifies a table is used after that it's safer to work with the copy -) When

#question.ERD of any car

Determine the Other System Design Issue How to realise subsystems; through hardware or software? How is object model mapped on chosen hardware software? Mapping

Implementing software control To implement software control designer must redesign strategy of state event model which is present in dynamic model. There are three basic ap

Describe substring comparison in SQL. For the relation Person (name, address), write a SQL query that retrieves the names of people whose name starts along with ‘A' and address co