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

Ask an Expert

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

Write your message here..

Related Questions

Explain data abstraction, Explain data abstraction? Data abstraction Da... Explain data abstraction? Data abstraction Data abstraction is a methodology in which enables us to isolate how a compound data object is utilized from the details of how it is

Managing databases, 10A.53 Code an Oracle Database trigger to enforce the... 10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the

ER diegrams, How to draw an ER diagram to a finance companz How to draw an ER diagram to a finance companz

Prepare an erd for the scenario, Question: (a) Prepare an ERD for the s... Question: (a) Prepare an ERD for the scenario given below. (b) Convert the ER diagram produced in (a) above into its physical design. You have to choose an appropriate Pri

Gui interfaces, Draw the database using the ER approach and then make the t... Draw the database using the ER approach and then make the tables accordingly. Populate the tables so that every table have at least 10 tuples. Then using Java and SQL, execute the

Differentiate between horizontal and mixed partitioning, Question: In r... Question: In relation to distributed database answer the following questions: (i) Give a brief definition of distributed database. Support your answer with an appropriate di

Briefly describe the different kinds of users of a dbms, Briefly describe t... Briefly describe the different kinds of users of a DBMS.  Ans: Different sorts of DBMS users are: (a)  Software Engineers: These are the people accountable for developing ap

Entity identifier key attributes, An entity type usually has an attribute w... An entity type usually has an attribute whose values are distinct for every individual entity in the collection. Such an attribute is known as a key attribute and its values can be

Relational operations, Let us now talk about the relational operations: ... Let us now talk about the relational operations: SELECT The select operation is used to select few specific record from the database based on different criteria, This is a un

Relational algebra, what is union compatable? what is union compatable?