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

Can you scan double-sided documents and remove blank pages, Can you scan do... Can you scan double-sided documents - and remove blank pages? Our software and imaging systems supports duplex scanning, at the same time scanning both sides of a page. Program

Explain the operation of the data warehouse, Using a labelled diagram expla... Using a labelled diagram explain the operation of the Data Warehouse, define the basic architectural components and outline the main functionalities. Briefly explain the role an op

Explain the need for the bcnf normal form, Surgeons identified by doctor ID... Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on

What is data mining?, Question 1 Define OLTP? Explain the Differences betw... Question 1 Define OLTP? Explain the Differences between OLTP and Data Warehouse Question 2 What is Architecture? Explain various components involved in it Question

E-R MODEL, WHAT IS MEANT BY E-R MODEL WHAT IS MEANT BY E-R MODEL

Create a er diagram to show customer accounts, Information about a bank is ... Information about a bank is about customers and their account. Customer has a name, address that consists of house number, area and city, and one or more phone numbers. Account ha

E r diagram, how to make an e r diagram? how to make an e r diagram?

relationship with the owner entity, A database for the Service and Mainten... A database for the Service and Maintenance (SM) section of a Computer sales and service Company has to be developed. SM gives after sales service to customers. SM branch has a numb

Explain the timestamps for read operations, Timestamps For Read operations:... Timestamps For Read operations: If TS (T) If TS (T) >= W-timestamp (Q), then the transaction T is trying to read a value of data item Q which has been written and committed

Database recovery and security, Database Recovery And Security Introdu... Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi