1. 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.

1. 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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Digital Wallet: the access control rule for the class Transaction and boundary use case for the entity class Transaction
23 of 40 Let R(A, B, C, D, E, F) be a relation with FD's: {D → CE, C → BDE, E → AD, AF → E, B → DF}. Which of the following statements is correct? Select one: O Ris in BCNF but not in 3NF. O Ris in 3NF but not in BCNF. O Ris not in 3NF and not in BCNF. O R is in 3NF and in BCNF.
Consider the following typed relational schema describing books and borrowers in a library:Book(isbn:integer, title:string, publisher:string, year:integer)Author(isbn:integer, name:string, rank:integer)Borrower(bid:integer, name:string, address:string)Borrowings(isbn:integer, borrower:integer, whenTaken:date, whenReturned:date)Assume the following:• dates are represented as a count of the number of days since Jan 1 1990• there is a system function today that returns today's date• the relational operators < and > allow you test before and after on dates• all loans are for a period of 14 days• the whenReturned field is null until the book is returned• the rank field specifies whether the author is the first, second, third, ... author Implement solutions to the following: Write an SQL query to show which books (title only) have never been borrowed.
3. Consider a relation R from X={1,2,3,4} to Y={a,b,c,d). R= {(1,b), (2,c), (2,d), (3,c), (4,a) } Please draw the relational matrix of R.
Given the relations U and T below, use ordered pair notation to express the relation To U. ToU = {Ex: (a, b), (b, c) b U a b T
let R be a relation defined on the set z by aRb if a < b. What property/properties are violated? A. Symmetric & transitive B. Reflexive & Symmetric C. Reflexive & Transitive D. All three properties
the relation of Intellectual property and physical manifestation is defined as: Select one: a. Intellectual property # physical manifestation b. there is no relation between Intellectual property and physical manifestation c. Intellectual property = physical manifestation
‘Problem 2: Data Modeling The recrultment agency TEMPO proposes intemship. employees for enterprises for a period of time. An internship employee is a temporary employee that will be recruited for a period of time. You must develop a database application in order to salisfy these: specifications: - The enterprises (id, name, address and phone number) define the posts for which they nead one or many employees. A post is defined with a label, a daily remuneration, the start date, the end cate and the number of employees for this post. A post needs eventually diploma(s) and a list of many skills. - Anintemship employee s described by a ssn, first name, last name, an address, a phone number, histher diplomas (we store for each diploma the year when it is obtained) and his/her skills. - An empioyee could be recruited for one or many posts. This recruitment of an employee for a given post is validated by a chief (ssn, first name, last name, address) designated by the enterprise. This chief…
question one: defined the following relation on A={0,2,5,6} Answer each of the following questions by listing the index of the relation. For example, for Part 1), if R1 and R2 and are reflexive, simply enter 1, 2 as the answer.1) Which relations are reflexive? 2) R0={(0,6),(6,6),(6,2),(0,0),(0,2),(2,2),(5,5)} 3) R1={(6,6),(2,2),(5,5),(0,0),(0,6)} 4) R2={(0,6),(6,6),(0,0),(5,6),(6,5),(5,0),(5,5),(2,2),(0,5) 5) R3={(5,5),(0,0),(6,6),(2,2) 6) R4={(5,5),(6,2),(6,6),(0,0),(6,5),(2,6),(2,2)} 1) Which relations are reflexive? 2) Which relations are symmetric? 3) Which relations are anti-symmetric? 4) Which relations are transitive? 5) Which relations are equivalence relations? 6) Which relations are partial orders? question two :defined the following relation on A={0,1,5,6} Answer each of the following questions by listing the index of the relation. For example, for Part 1), if R1 and R2 and are reflexive, simply enter 1, 2 as the answer. R0={(5,5),(0,0),(6,6),(1,1)}…
What is a thread in the context of computer science?
3,
For the table BOOKAUTHOR below you are given the following functional dependencies. BOOKAUTHOR (ISBN, BookTitle, Author_Num, LastName, Publisher, Royalty, Edition) Functional dependencies: 1. ISBN BookTitle, Publisher, Edition 2. Author Num → LastName 3. BookTitle → Publisher 4. {ISBN, Author_Num} → BookTitle, LastName, Publisher, Royalty, Edition Write the types of functional dependencies shown in (1) to (4) above. Also, decompose the table to the third normal from (3NF).