Question: a) Given relation R(A, B, C, D, E, G) and functional dependencies F={ABDCE, BCD, CDE, DEG, AB}. Compute a minimal cover of F. Show the

a) Given relation R(A, B, C, D, E, G) and functional dependencies F={ABDCE, BCD, CDE, DEG, AB}. Compute a minimal cover of F. Show the intermediate steps of your derivation. (7 marks)

b) Consider the following relation:

TRIP (Trip_id, Start_date, Cities_visited, Cards_used)

This relation refers to business trips made by company salespeople. Suppose

the TRIP has a single Start_date but involves many Cities and salespeople

may use multiple credit cards on the trip.

i) Make up a mock-up population of the table.

ii) Discuss what FDs and/or MVDs exist in this relation. Justify the existence of the MVD identified.

iii) Show how you will go about normalizing the relation. (2+4+2 = 8 marks)

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!

Q4-A (6 marks) Consider the relation R (A, B, C, D, E, F, G) and the set of functional dependencies Fd = {A->B, BC->F, BD->EG, AD->C, D- >F, BEG->FA}. Determine if we can infer the following...

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

database management system = Consider a universal relation schema R(A, B, C, D, E, G, H, I, J, K) and F = {CD --> A, B --> EG, H --> IJ, K --> AC, EG --> IJ, JK --> AD) be a set of functional...

Given a relation schema R(A, B, C, D, E, G, H), with F={ABC, BC, CDG, DCG, HDEG, EDH} 1- Give a minimal cover of F 2- Determine all keys of R 3- Give a 3NF decomposition of R 4- Is your decomposition...

Given the universal relation R = {A. B. C. D, E. F. G. H. I, J} and set of functional dependencies: F = {AB C, BD EF, AD GH. A-> 1, H J), find the decomposition D of R into 3NF with dependency...

Hi, This is a relational database question. Struggling with this homework question, when I have more than one determinant attribute on the right hand side. Could you please explain your working with...

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

2 Marks Question 2 Consider the relation schema R A B C D E and the following set of Functional Dependencies (FDs): AB CD 2.1 What are the (candidate) keys of R? Justify your answer (i.e., show the...

Consider the relation schema R={A, B, C, D, E} and the following set of Functional Dependencies (FDs):AB AB CD BC D DE A a. What are the (candidate) keys of R? Justify your answer (i.e., show the...

Consider a relation R = (A, B, C, D), and functional dependency set F = {AB ? C, C ? D, D ? A}. a) Is F a minimal cover? Explain. b) Compute F+. c) List all the super keys of R. d) List all the...

Currently, a share of Alpha, Inc pays a dividend of $2 per year, payable at the end of each year (the year just started, so one year from today). It is expected to pay that $2 per year dividend...

Three dice are tossed, one red, one blue, and one green. What outcomes make up the event A that the sum of the three faces showing equals 5?

Because the Code doesn't define "tax shelter," the IRS must judge whether any given partnership is a tax shelter on a case - by - case basis. True False

Page of 12 AZ9. Birrer Corporation has provided the following contribution format income statement. Assume that the following information is within the relevant range. Sales (8,000 units) Variable...

3. Explain how you would conduct a job analysis in a company that has never had job descriptions. Utilize the O*Net as a resource for your information.

LO4 Identify a system for controlling absenteeism.

2. What is your opinion of Agile Working? Do you think there are any disadvantages associated with this flexible work arrangement?