8. Consider the following relation instance of the CAR relation schema: CAR Model #cylinders Origin Таx Fee Camry 4 Japan 15 30 Mustang 6. USA 0. 45 Fiat 4. Italy 18 30 Accord 4. Japan 15 30 Century USA 45 Mustang 4 Canada 30 Monte Carlo 6. Canada 45 Civie 4 Japan 15 30 Mustang 4 Mexico 15 30 Mustang 6. Mexico 15 45 Civie 4 Korea 15 30 What is the minimal cover of functional dependencies that exists in CAR? What is (are) the candidate key(s) of CAR? If there is more than one candidate key, select a primary key from among the candidate keys. d. Based on the primary key, what is the immediate Nomal Form violated in CAR? e. Develop a dependency-preserving solution that eliminates this Normal Form violation. Is vour solution a lossless-ioin decomposition? а. b. С.

8. Consider the following relation instance of the CAR relation schema: CAR Model #cylinders Origin Таx Fee Camry 4 Japan 15 30 Mustang 6. USA 0. 45 Fiat 4. Italy 18 30 Accord 4. Japan 15 30 Century USA 45 Mustang 4 Canada 30 Monte Carlo 6. Canada 45 Civie 4 Japan 15 30 Mustang 4 Mexico 15 30 Mustang 6. Mexico 15 45 Civie 4 Korea 15 30 What is the minimal cover of functional dependencies that exists in CAR? What is (are) the candidate key(s) of CAR? If there is more than one candidate key, select a primary key from among the candidate keys. d. Based on the primary key, what is the immediate Nomal Form violated in CAR? e. Develop a dependency-preserving solution that eliminates this Normal Form violation. Is vour solution a lossless-ioin decomposition? а. b. С.

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

Given the relation R(A, B, C, D, E, F), the following functional dependencies exist: B --> C, DD --> F a) What normal form is the relation R in? b) Normalize relation R to 3NF. You only need to show the final relation schemas
11 of 40 Consider the following Relation instance of Students: ID firstNamelastName GPA Address 123 Albertson Albertson 3.5 888 CDN 234 Mary Albertson 4.2 759 St. Catherine Est. 345 Smith Smith 2.9 105 Queen Mary 456 Theodore McDonald 3.7 208 Jean Talon West 567 Jean Mary 3.9 950 Des Laurentides 678 Junior Junior 4.1 326 St. Martin West How many records will be in the result of the following SQL Query? Select ID, firstName From Students S Where firstName = lastName and firstName NOT IN ( Select lastName From Students Where ID S.ID); Answer:
Question 2. Find a set of FDs for the relation schema R(w, X, y, z) with primary key "wx" under which R is in 2NF but not in 3NF.
Consider a relation schema R = {A, B, C, D, E} and its functional dependency set F = {A → B,CD → E,B →D,E → A}. Compute A+ and choose the answer.(a) A+ = AB(b) A+ = ABC(c) A+ = ABCD(d) A+= ABCDE(e) none of the above
Let R be a relation schema with set of attributes {A, B, C, D, E,G}, and F be the follow- ing set of five functional dependencies which hold on R: A → B A →C BD → E ЕС + А E → G Compute the closure of each of the following four sets of attributes with respect to F: C E, A D, BCD and ADE
Develop a program that takes as input: 1- A relation R with a set of attributes. The number of attributes should be variable. 2- A set of functional dependencies F that holds on R. The number of functional dependencies should be variable. And your program should do the following: 1- Find and print out the list of all possible candidate keys, (not the super keys), of R based on F.
This question concerns the logical design of a relation schema LOAN describing the borrowing of a book at a library. If a tuple is in this relation, it means that a specific copy with identifica- tion number catalogNo has been borrowed by a library member with identification number memberNo on dateOut (borrowing day) and has been returned on dateReturn (return day). If the book has not yet been returned dateReturn is null. LOAN (catalogNo, dateOut, memberNo, dateReturn) (a) What would the following functional dependency mean? { dateOut, memberNo} → dateReturn (b) Give all full functional dependencies for schema LOAN, assuming that a book can be borrowed just once per day, that members can borrow many books on any given day, and that members can borrow the same book several times.
Let W(A, B) and Q(C,D) be two relation schemas. Let r₁ and r2 be the corresponding relation instances. B is a foreign key that refers to C in r2. Assuming that all tuples in r₁ and r2 satisfy referential integrity constraints, which of the following is ALWAYS TRUE? (А) Пв (г1) - Пс (rz) =Ø (B) IIc (₂)-118 (1₁) = 0 (С) Пв (г1 ) = Пс (12) (D) Пв (r1 ) - Пс (12) +Ø OB OD OA O C
A database of application of wholesaler can be modelled by means of the relations price, in_stock and supplies. Price is a relation over products1…30, which models the association between prices and stock items. In_stock is a relation over productsN, which models the association between stock items and the current number in stock of product. Supplies is a relation over suppliersproducts which models the relation between a supplier and the product that is delivered by that supplier. If the current value of these relations are following:price = {(nut, 5), (bolt, 13), (screw, 3), (board, 25), (fastener, 23)}, in_stock = {(nut, 700), (bolt, 2200), (screw, 55), (board, 0), (fastener, 600)}, supplies = {(Thomas, nut), (Thomas, bolt), (Wilks, bolt), (Wilks, screw), (Wilks, board), (Wilks, fastener), (Rogers, board), (Rogers, fastener)}, then what is the value of the following expressions? i. {nut, bolt} priceii. dom(price 1…15).iii. rng(price 1…10).iv. dom(supplies; (in_stock {0})). v.…
List all nontrivial functional dependencies satisfied by the relation of Figure7.18.
Given relation R(u, y, c, d, e, f, w) where there are two keys: {y,c} and {w}. Given a set of functional dependencies F = {fd1: {y,c} -> {u,d,e,f,w}, fd2: u -> c, fd3: w -> {u,y,c,d,e,f}}. Is R in 3NF? Explain why.
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.