Question: R=(A, B, E, G, H, I), F={A B, A E, BE A, GHI, IH} a) Find all candidate keys. b) Whether R is in BCNF

R=(A, B, E, G, H, I), F={A B, A E, BE A, GHI, IH} a) Find all candidate keys. b) Whether R is in BCNF or 3NF or neither? c) If it is not in BCNF,decompose R into a set of BCNF relations. d) Whether the decomposition of c) is dependency preserving or not? Why?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Consider the relational schema R(A, B, C, D, E, G, H, I, J) and a set of functional dependencies F = {AI BC, CGI, EIBG, I AHJ, B I, JHI). Note that A, B, C, D, E, G, H, I, J are attributes. 1. Find...

( 6 marks ) Consider the relational schema R ( A , B , C , D , E , G , H , I, J ) and a set of functional dependencies F = { A - > EH , BE - > G , DI - > AJ , GH - > CI , C - > BDI } . Note that A ,...

4. Consider the following relation R and set of functional dependencies F, R(A, B, C, D, E, G, H) and F=[AB CD, E D, ABCDE, EAB, D AG, ACD BE} a) Find out one candidate key for the given relation...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Which one is correct w . r . t . RDBMS ? primary key super key candidate key primary key candidate key super key super key candidate key primary key super key primary key candidate key The relation...

Remarks and instructions READ THIS FIRST! For all problems, you should indicate steps. For example : For finding candidate keys , a simple final answer is not sufficient. You should clearly indicate...

s1 educated (SSE) student for every three public school educated (PSE) students. Reasoning that students are not very dissimilar from threads, he suggests the following entry and exit routines be...

Consider the relation Courses(C, T, H, R, S, G) , whose attributes may be thought of informally as: course, teacher, hour, room, student, grade. Let the set of functional dependencies, F , for...

seventh pages Chapter 3 Curve Sketching How much metal would be required to make a 400-mL soup can? What is the least amount of cardboard needed to build a box that holds 3000 cm3 of cereal? The...

Suppose a relational schema R 2 ( A , B , C , D , E , F , G , H , I ) and set of functional dependee: { A , B C ( Suppose a relational schema R 2 ( A , B , C , D , E , F , G , H , I ) and set of...

The general ledger of Rafferty Insurance Agency includes controlling accounts for Office Equipment, No. 123, and Accumulated Depreciation, Office Equipment, No. 124. Raffertys accountant also records...

Which of the following is considered copyright infringement? A copyrighted poem used without the permission of the author O An image denoted as public domain O Work with expired copyright Facts

Collect some recent information on the current performance of the three new companies that were created in 2007. What corporate strategies does each pursue? How well are they currently performing?

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

(Appendices) PREPARATION OF MERCHANDISING FINANCIAL STATEMENTS. Jay Coat Company has prepared the following unadjusted trial balance as of December Ble Ox2: LO9 The following data are also available:...

(Appendices) EFFECTS OF DISCOUNTS ON SALES AND PURCHASES. Helmkamp Products sells golf clubs and accessories to pro shops. During 19x5, Helmkamp purchased merchandise with a list price of $628,500 on...

(Appendices) TERMS OF SHIPMENT AND ENDING INVENTORY. On December 31, Archive Products had two shipments of merchandise in transit from different suppliers. The first shipment, which arrived on...