Consider the following relation: CAR_SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discounted price). This relation refers to options installed in cars (e.g., cruise control) that were sold at a dealership, and the list and discounted prices of the options. If Carl D → Sale_date and Option_type → Option_listprice and {CarlD, Option_type}→→ Option_discounted price, a) Argue using the generalized definition of the 3NF that this relation is not in 3NF. b) Argue from your knowledge of 2NF, why it is not even in 2NF.

Consider the following relation: CAR_SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discounted price). This relation refers to options installed in cars (e.g., cruise control) that were sold at a dealership, and the list and discounted prices of the options. If Carl D → Sale_date and Option_type → Option_listprice and {CarlD, Option_type}→→ Option_discounted price, a) Argue using the generalized definition of the 3NF that this relation is not in 3NF. b) Argue from your knowledge of 2NF, why it is not even in 2NF.

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

HouseSale (houseID, agentID, dateSold, commissionRate, interestRate) Where: dateSold interestRate agentID → commission Rate houseID →dateSold What is the highest normal form that the above relation satisfies? Decomposition into BCNF:
Exercise 4: R1 = {(a, b) E R² | a > b}, the “greater than" relation, R2 = {(a, b) E R² | a > b}, the “greater than or equal to" relation, R3 = {(a, b) E R² | a < b}, the "less than" relation, R4 = {(a, b) E R² | a
1. Create an entity named Doctor and Patient and create a one-to-many mapping using JPA. Doctor_id Patient_id Qualifica Contact_ Salary Age no tion n Doctor treats Patient Name P_Name Address Write a main program to assign values to the Doctor and Patient entity using entity manager instance.
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.
This is an object oriented programming question Draw the class diagram only The diagram should be well defined Describe every relation that they are one to many or not. Mr.Fayyaz is a milkman who is supplying milk to many customer. Each customer has its name CNIC Home_Address and phone number. Mr Fayyaz wants to keep the track of daily milk supply quantity and price. He also wants to monthly record of each customer. Customer could also login and use the milkman application to view its bill. Mr Fayyaz could see the total sales of each customer. The milk has two types buffalo milk and cow milk. Mr Fayyaz also want to maintain the record of workers in the application. Define the classes (attributes, behaviors or function) Make getter or setter and constructor Define Generatebill() function in milkman class. Define viewbill() function in customer class.
The following functional dependencies describe a relation that is in 3NF.Book_ID -> Genre_ID, Genre_TypeGenre_ID -> Genre_Type True or False? Thanks.
Convert the following Relation into INF, 2NF, and 3NF and show the functional dependencies. StudentID StudentName Major CourselD CourseTitle InstructorName InstructorLocation Grade D-Building A-Building C-Building C-Building A-Building D-Building A-Building 111 Kevin CS CS201 Bob Computer Marketing Accounting Accounting Jeff 111 Kevin CS МАЗ3 Jeff 111 Kevin CS АCC234 Sarah 222 Alex BA АСC234 Sarah B. 333 МАЗ33 Marketing Computer Marketing Noor MA 444 CS201 Bob Luay Adam BA A 555 AC МАЗ33 Jeff
Suppose you are given a relation grade_points(grade, points) that provides a conversion from letter grades in the takes relation to numeric scores; for example, an “A” grade could be specified to correspond to 4 points, an “A−” to 3.7 points, a “B+” to 3.3 points, a “B” to 3 points, and so on. The grade points earned by a student for a course offering (section) is defined as the number of credits for the course multiplied by the numeric points for the grade that the student received.Given the preceding relation, and our university schema, write each of thefollowing queries in SQL. You may assume for simplicity that no takes tuple has the null value for grade. Find the ID and the grade-point average of each student.
Please written by computer source The following relation is an extract from a restaurant point-of-sale (POS) system. The system assigns a globally unique id (GUID) to every transaction processed. CheckID comes from the pre-printed check number on the ticket used by the server for the order; these pre-printed tickets are guaranteed to be unique within the restaurant. RegisterID is which register was used for checkout and the date and time of the checkout – to the minute – are recorded in CheckoutDT; assume no two checkouts can occur at the same register in the same minute. PayType and PayTotal are, respectively, how the check was paid and what the total payment was; assume there is no splitting of a check among multiple payments. When answering the questions below use the format [attribute, attribute, …, attribute] to identify keys. 1. How many keys in general (including the empty or null key) are there in this relation? 2. Identity two multi-keys for this relation. 3. Identify two…
Task Description: consider the following relations for a university: Student (sid: integer, sname: string, GPA: real, dateOfBirth: date) Department (did: integer, dname: string, capacity: integer) Course (cid: integer, cname: string, credit: integer) Enroll (studentID: integer, courselD: integer, departmentID: Integer, enrollmentDate: date) studentlD, courselD, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively.
4. Write the relation matrix for the relation R on the set (a,b.c.d.e.f) which is defined as follows: R={a,a), (a,b), (a,c), (b,a). (b,c). (c,a), (c,b), (d,d), (f.f).
1. Create an entity named Employee and Dependent and create a one-to-many mapping using JPA. EMPLOYEE has DEPENDENT (0,N (1,1) EMP NUM EMP LNAME EMP FNAME EMP_INITIAL EMP DOB EMP_HIREDATE EMP NUM DEP NUM DEP FNAME DEP DOB Write a main program to assign values to the Employee and Dependent entity using entity manager instance.