subject

Consider the following relation:
BIKE_SALE(Bike_ID, Salesperson_ID, Date_Sold , Sale_Commission,
Discount_Percentage)
Assume that a motorbike may be sold by multiple Salesperson, and hence
{Bike_ID, Salesperson_ID} is the primary key. Additional dependencies are:
 Bike_ID -> Date_Sold
 Bike_ID -> Discount_Percentage
 Date_Sold -> Discount_Percentage
 Salesperson_ID -> Sale_Commission
Identify if this relation is in 1NF, 2NF, 3NF? Please specify your reasons and
normalize if you think it is needed.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 05:10
Suppose we have a byte addressable computer that has a 32-byte cache with 8 bytes per block. the memory address is 8 bits long. the system accesses memory addresses (in hex) in this exact order: 6e, b9, 17, e0, 4e, 4f, 50, 91, a8, ab, ad, 93, and 94. (a) assuming the cache is direct mapped, what memory addresses will be in cache block 2 after the last address has been accessed? (b) assuming the cache is direct mapped, what is the hit ratio for the entire memory reference sequence given, assuming the cache is initially empty? (c) assuming the cache is 2-way set associative with a lru replacement policy, what is the hit ratio?
Answers: 3
question
Computers and Technology, 23.06.2019 19:30
Amitha writes up a one-page summary of a novel during her summer internship at a publishing company. when she reads over the page, she realizes she used the word “foreshadow” seven times, and she would like to reduce the repetition. which tool would best amitha solve this problem?
Answers: 3
question
Computers and Technology, 24.06.2019 13:00
Refer to the figure and match the theorem that supports the statement.1.if chords are =, then arcs are =.if bc = de, then arc bc = arc de2.if arcs are =, then chords are =.if arc bc = arc de, then bc = de3.diameters perpen
Answers: 3
question
Computers and Technology, 24.06.2019 14:30
Ahousehold consists of a married couple and their twin five-year old daughters. the couples children had no income and lived with their parents all of last year. how many exemptions can the couple claim on last years tax return or they file with the “ married filing jointly “ status? a. 4 b. 5 c. 3 d. 2
Answers: 1
You know the right answer?
Consider the following relation:
BIKE_SALE(Bike_ID, Salesperson_ID, Date_Sold , Sale_Commissio...
Questions
question
English, 31.03.2020 00:05
question
Mathematics, 31.03.2020 00:05