1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
elena-14-01-66 [18.8K]
2 years ago
6

CAR_SALE (Car_no, Date_sold, Agent_no, Commission_pct, Discount_amt)

Computers and Technology
1 answer:
serg [7]2 years ago
8 0

1NF

In 1NF the relation should follow atomicity that means no repeating groups

In the relation there is no repeating groups

So

the relation is in 1NF

2NF

In 2NF, the relation should be in 1NF and each non prime

attribute must depend on primary key and No Partial dependency

Commission% is functional dependent on Salesperson# which is only part of the primary key.

So

relation is not in 2NF

3NF

In 3NF, the relation should be in 2NF and any NON prime attribute should not describe any non prime attribute.

Already we know relation is not in 2NF

there is a non prime attribute date_sold that describe another non prime attribute Discount_amt,

the relation is not in 3NF

Finally we come to. Know

the relation satisfies only 1NF

NORMALIZATION

The relation is not in 2NF

Decompose the relation CAR_SALE

CAR_SALES (Car#, Date_sold, Salesperson#, Discount_amt)

SALESCOMM (Salesperson#, Commission%)

CAR_SALES and SALESCOMM are in 2NF

In 3NF, the relation should be in 2NF and any NON prime

attribute should not describe any other non prime attribute

SALESCOMM relation is in 3NF

but CAR_SALES is not in 3NF the reason is that there is a

non prime attribute Date_sold that describes another non prime attribute Discount_amt.

So, decomposing the relation

CARSALEDATE (car#, salesperson#, Date_sold)

DATEDISS(Date_sold, discount_amt)

The relations CARSALEDATE

SALESCOMM

DATEDIS are in 3NF

You might be interested in
Assume that a 5 element array of type string named boroughs has been declared and initialized. Write the code necessary to switc
hammer [34]

Answer:

Explanation:

Let's do this in python. First we can set a placeholder variable to hold the first element of the array, then we can set that first element to the last element (5th) of that array. Then we set the last element of that array to the placeholder, which has value of the original first element of the array

placeholder = boroughs[0] # in python, 0 is the first element or arra

boroughs[0] = boroughs[-1] # -1 means the last element of the array

boroughs[-1] = placeholder

6 0
3 years ago
I dont know how to put the negative sigh on my computer
valina [46]
You put the dash on the right side up top ape
8 0
2 years ago
Read 2 more answers
Next, determine if the given number is a prime number. A prime number is a number that has no positive divisors other than 1 and
Darya [45]

Answer:

Explanation:

whats the number?

6 0
3 years ago
A ________ -tier design includes a middle layer between the client and server that processes the client requests and translates
Vanyuwa [196]

Answer:

Three.

Explanation:

5 0
3 years ago
What is the answer for 2.8.10 word games? This is what I have so far, but I can’t seem to be able to figure out the bananaSplit
Feliz [49]

Answer:

 public String bananaSplit(int insertIdx, String insertText) {

     return word.substring(0, insertIdx) + insertText + word.substring(insertIdx);

 }

Explanation:

Do you have the other parts of the WordGames class?

8 0
2 years ago
Other questions:
  • When was unicode invented?
    13·1 answer
  • Ansel Adams education and special training
    14·1 answer
  • Tamara has $500 she is looking to save for a class trip. She wants to earn the most possible interest and will not need access t
    7·1 answer
  • Nikolas has a idea that he could use the compressed carbon dioxide in a fire extinguisher to propel him on his skateboard. Nikol
    13·2 answers
  • Write a Unix (Linux) find-like command (myFind) in Python3 where the function will return the full paths of all the files contai
    9·1 answer
  • Abby wants to simply share a snapshot of her calendar with another user. Which option should she choose to achieve
    15·1 answer
  • Because all the IEEE WLAN features are isolated in the PHY and ____________ layers, practically any LAN application will run on
    11·1 answer
  • How to mark a discussion as read on canvas dashboard.
    10·1 answer
  • IM a bit confused on what this is asking for exactly.
    14·1 answer
  • Who designed the apple i computer in 1976?
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!