Question: CMPSC 321 Relational Database Theory and Design Task 1: Normal forms Consider the following relational schem:a Lab 5: Normalization CAR SALE(Car#, Date-sold, Salesperson, Commission%, Discount

CMPSC 321 Relational Database Theory and Design Task 1: Normal forms

Consider the following relational schem:a Lab 5: Normalization CAR SALE(Car#, Date-sold, Salesperson,

Commission%, Discount amt) Assume that a car may be sold by multiple

salespeople, and hence(Car#, salesperson, is the primary key. Additional dependencies are Date_soldDiscount_amt

CMPSC 321 Relational Database Theory and Design Task 1: Normal forms Consider the following relational schem:a Lab 5: Normalization CAR SALE(Car#, Date-sold, Salesperson, Commission%, Discount amt) Assume that a car may be sold by multiple salespeople, and hence(Car#, salesperson, is the primary key. Additional dependencies are Date_soldDiscount_amt . Salesperson# Commission% Assume the relation is in 1NF. Is this relation in 2NF? Why or why not? Is this relation in 3NF? Why or why not? Write down the steps you would take to decompose this relation into a schema that is in a. b. c. 3NF. (You don't actually have to do it; just say what you would do.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Page. 1 210.02 Lab 210.02 Data Normalization Lab (Revised 2/11/04) Data Normalization Basics This exercise consists of two exercises that will demonstrate your ability to normalize data using the...

Help In Database: sakila-reduced.pdf: CMPSC 321 Relational Database Theory and Design Lab 3: Reverse Engineering Task 1: Relational schema 1. Consider a LIBRARY database which is used to keep track...

HELP IN DATABASE CMPSC CMPSC 321 Relational Database Theory and Design Lab 4: Inner joins and outer joins Task 1: Some fun with joins and aggregates 1. Use the HAFH database. I want to find the...

CMPSC 321 Relational Database Theory and Design Lab 2 - Part 1: Relational Schemas Task 1: Relational schema 1. Consider a MOVIE database in which data is recorded about the movie industry. The ER...

Help In Database Please!!! Functional dependencies, Normalization, and SQL 1. Consider the following database, MANA. It is printed here and is also available on csmaster.sxu.edu/phpminiadmin/. It has...

DATABASE INFORMATIOM : As a Fitness counselor, I would be responsible for helping clients achieve their fitness goals by providing them with personalized workout and nutrition plans, as well as...

CMIS 320 Project 1 A typical Relational Database Management System (RDBMS) project initiates with a well-written justification statement that supports the technology used for the given project. For...

please I need help with this question. Is the answer the same as the advantages of a relational database? Also I could not figure out the technical aspect of a database management system which am...

A typical Relational Database Management System (RDBMS) project initiates with a well-written justification statement that supports the technology used for the given project. For Project 1, write a...

Damping is negligible for a 0.150-kg object hanging from a light 6.30-N/m spring. A sinusoidal force with an amplitude of 1.70 N drives the system. At what frequency will the force make the object...

Instyle Interior Designs has been requested to prepare a bid to deco-rate 4 model homes for a new development. Winning the bid would be a big boost for sales representative Jim Doogan, who works...

The person upon whom an annuity's payout is based is known as the: A beneficiory B contract owner annuitant actuary

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...