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
Suppose R is a relation with attributes A1, A2,..., An. As a function of n, tell how many superkeys R has, if: 1.1 The only key is A1. 1.2 The only key is A1 and A2. 1.3 The o

With the help of an example display how records can be deleted and updated in QBE. (i) Increase Pay_Rate of employees along with the skill of ‘cook' by 10%. (ii) Delete employee

write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.

The Form input elements are:             Reporter name                                                text type input             Password

Define Timestamp ordering Ans In timestamp-based method, a serial order is made among the concurrent transaction by assigning to every transaction a unique nondecreasing number

folding method and mid square method using visual basic

What is the most significant feature that does not directly map into programming language structures? Why? Association, since there are complex types of association, like as qu

If the deletion violates referential integrity constraint, then three alternatives are available: Default option: - refuse the deletion. It is the job of the DBMS to describ

A database is to be constructed to remain track of the teams and games of a sport league. A team has a number of players, not all of whom participate in every game. It is desired

The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced