functional dependencies and normalization for relational dat, Database Management System

Consider the 1ollowin8 relation:
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/3/2012 1:38:18 PM | Location : United States







Related Discussions:- functional dependencies and normalization for relational dat, Assignment Help, Ask Question on functional dependencies and normalization for relational dat, Get Answer, Expert's Help, functional dependencies and normalization for relational dat Discussions

Write discussion on functional dependencies and normalization for relational dat
Your posts are moderated
Related Questions
What are the two statements regarding transaction? The two statements regarding transaction of the form are:- A)     Begin transaction B)      End transaction

Explain five duties of Database Administrator? 1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an defin

What is DML (Data Manipulation Language)? This language that enable user to access or manipulate data as organised by appropriate data model. Procedural DML or Low level: DM

Illustrate the view of software architecture A model is a semantically closed abstraction of system composes of elements. It can be visualized using any of the following five v

Determine the benefits of Object oriented design OOD also gives reusability, which saves time, costs and productivity gains through direct mapping to properties of Object-Orie

Where does view definition stored? A view definition is permanently stored as part of the database.

Define the concept of Object Diagram An object diagram shows a set of the objects and their relationships with each other at a point of time. In a static view, object diagram

Define Fifth Normal form is concerned with Ans : Fifth Normal form is concerned with Join dependency.

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

What is Conceptual Schema? Conceptual Schema - Conceptual schema elaborates the structure of the overall database for a community of users. It hides the details of physical sto