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
How can we search person in brainly for sending request of friend
pshichka [43]

Answer:

The method what I used thast the person what you would like to add make them make a question then find the question by searching it up or looking in the 'answer questions' category. After that answer the question or just write anny thing in the question. Let your friend comment or interact with the answer them click on there profile and add. If you what them to add you back they will have to go on there profile and then go to there followers and click add back.

(Hope I helped)

3 0
1 year ago
Which part of a formal email is optional
EleoNora [17]
Contact information will be optional.
6 0
3 years ago
Read 2 more answers
Which of the following is NOT a useful strategy when making an informed purchase ?
Jlenok [28]

Answer:

3 Reasons to Use Cash and 3 Reasons to Choose Credit

Credit and debit cards have become so ubiquitous, you'd be forgiven for thinking physical cash is just a couple years away from being declared obsolete and worthless by the government.

Well, as it turns out, the death of dead presidents is greatly exaggerated, as over $1.25 trillion still circulates around the United States alone.

Way too many people use cash for it to ever go away completely, regardless of how much plastic gets wiped every day.

Easier to Watch and Control Your Spending

Actually seeing the cash you owe, as opposed to simply staring at a generic card with no monetary value of its own, can remind you to spend less overall, since all of a sudden the money is real, and real valuable at that.

Financial guru Ramit Sethi, for example, lost his credit card, and spent nothing but cash until a replacement came. He reported spending 18% less when forced to watch his green wad dwindle in real-time.

Some Places Still Don't Take Plastic (or Require a Minimum Purchase Amount)

Amazingly, over half of all small businesses won't take cards, likely because they can't afford the fees.

It's always good to keep at least some cash on you in case you need to make a purchase from one of these places.

Explanation:

3 Reasons To Use Cash (and 3 Reasons To Choose Credit)

Credit and debit cards have become so ubiquitous, you'd be forgiven for thinking physical cash is just a couple years away from being declared obsolete and worthless by the government.

Well, as it turns out, the death of dead presidents is greatly exaggerated, as over $1.25 trillion still circulates around the United States alone.

Way too many people use cash for it to ever go away completely, regardless of how much plastic gets wiped every day.

So why in the world would anydiv still pay with Georges and Bens? Here are a few good reasons why:

Less Chance of Identity Theft

Few things are scarier than hearing that the store you regularly swipe your card at just had a security breach, and that some anonymous criminal may have your identity at their disposal.

Paying cash eliminates that issue -- chunks of metal and pieces of paper stacked in a register tells fraudsters absolutely nothing, while the information sent to vulnerable computers via your bank card can reveal everything.

Easier to Watch and Control Your Spending

Actually seeing the cash you owe, as opposed to simply staring at a generic card with no monetary value of its own, can remind you to spend less overall, since all of a sudden the money is real, and real valuable at that.

Financial guru Ramit Sethi, for example, lost his credit card, and spent nothing but cash until a replacement came. He reported spending 18% less when forced to watch his green wad dwindle in real-time.

Some Places Still Don't Take Plastic (or Require a Minimum Purchase Amount)

Amazingly, over half of all small businesses won't take cards, likely because they can't afford the fees.

It's always good to keep at least some cash on you in case you need to make a purchase from one of these places.

Even if they accept cards, some of these businesses might only do so if you spend X amount, in order to override the fee.

If you entered the store to spend more than the minimum amount, then swipe away. But if you only want a loaf of bread, and they want you to spend $10 before they'll accept your card, just pay for your bread with bread.

That all being said though, there are several cases where plastic owns cash. Here are a few of those:

Online Purchases

Increasing amounts of items can now only be purchased online and with a credit card, or at the very least are extremely difficult to cover with cash.

Plane tickets, while still technically available at a travel agent's physical office, are usually much, much cheaper online, where you can't obviously use cash. The same thing goes for e-books, MP3s, subscriptions to streaming sites, and the like.

The more you shop online, the more reliant you will become on cards in your everyday life.

7 0
2 years ago
How many residues separate amino acids that are stabilized by hydrogen bonds in α helices?.
irina [24]

The numbers of residues separate amino acids that are stabilized by hydrogen bonds in α helices is  3.6 amino acid residues.

<h3>Why are amino acids called residues?</h3>

The  Amino acids are known to be compounds that are said to be called residues if there is  two or more amino acids that are known to be bond with each other.

Note that the amino group on one amino acid is one that tends to interacts with the carboxyl group and as such  form a peptide bond.

Therefore, The numbers of residues separate amino acids that are stabilized by hydrogen bonds in α helices is  3.6 amino acid residues.

Learn more about amino acids from

brainly.com/question/2526971

#SPJ1

5 0
1 year ago
If you want to stop a loop before it goes through all of its iterations, the break statement may be used. Group of answer choice
NeX [460]

Answer:

Answer is true

Explanation:

6 0
1 year ago
Other questions:
  • How is a network printer identified on the network?
    8·1 answer
  • Which security control is most helpful in protecting against eavesdropping on wireless LAN (WLAN) data transmissions that would
    6·1 answer
  • Implement a java program to find the smallest distance between two neighbouring numbers in an array.
    7·1 answer
  • In what year was the 1st zelda game released
    5·2 answers
  • Lucy wants to develop a web page to display her profile. She wants to just start with a basic page that lists her accomplishment
    13·1 answer
  • What is information technology
    11·1 answer
  • An administrator is helping a user connect a smartphone to a tablet via Bluetooth. What should the administrator do first?
    6·1 answer
  • Which statement describes how to insert the IF, COUNTIF, or SUM function into a cell?
    11·1 answer
  • Have some points part 6<br>anyone know how to change my username?​
    11·2 answers
  • Display the Approval Form worksheet and create an IF statement in cell B13 to determine if the applicant is eligible for a perso
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!