Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Answer the following problems.

1. find out the closure (F+) for following set of the functional dependencies defined on R(a,b,c,d), where F – {c→a, ab→d, a→b, d→c}, i.e. what are all of the FDs implied by F.

2. Given the following set of functional dependencies {cf→bg, g→d, cdg→f, b→de, d→c} defined on R(b,c,d,e,f,g)

a. Is cf→e implied by FDs?

b. Is dg a superkey?

c. Is dg a candidate key?

d. Find a non-redundant cover.

e. Find a canonical cover.

f. What are the candidate keys?

3. Consider the following six relation schemes and their corresponding sets of functional dependencies. In each case identify

a. All the candidate keys

b. The highest normal form of the relation (2NF, 3NF, BCNF).

R1 (W, X, Y, Z) XY→Z, Y→ W

R2 (K,L,M,N) KL→N, K→M

R3 (P,Q,R,S) P→Q, Q→R, R→S

R4 (T,U,V) T→U, U→T, T→V

R5 (W,X,Y,Z) Z→W, YZ→W, WY→XZ

R6 (A,B,C,D) AB→D, AC→D

4. Determine a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. University relation satisfies following set of functional dependencies:

{Faculty → Dean, Dean → Faculty, Department → Chair, Professor →Rank Chair, Department → Faculty, Student → DepartmentFacultyDean, ProfessorRank → DepartmentFaculty}

Is the decomposition non-loss and dependency preserving?

5. Consider the following relational scheme: R (a,b,c,d,e,f) and its corresponding set of FDs {d→a, be→c, ac→e, b→f, f→d, a→c}.

a. Is the following decomposition i) non-loss, ii) dependency preserving, iii) free of interrelational join constraints?

R1 (a,f,d), R2 (b,a,f), R3 (a,c,e)

b. Apply the BCNF decomposition on R.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91766

Have any Question? 


Related Questions in DBMS

Dfd1 draw a context diagram for the fiat for football

DFD 1. Draw a Context Diagram for the FIAT for Football process. 2. Draw a top level Data Flow Diagram for the FIAT for Football method. 3. Blow up any one non-trivial process into a first level Data Flow Diagram.

Lab creating a database designthis assignment contains two

Lab: Creating a Database Design This assignment contains two Sections: Database Design Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Note: If you are us ...

Your team is a consulting company that specializes in rapid

Your team is a consulting company that specializes in rapid application development. A client company wishes to improve their customer data and interactions records. You create a simple customer relationship system for t ...

Assignment1write a query that retrieves studentlastname

Assignment 1. Write a query that retrieves student.last_name, student.first_name and total number of enrollments from the student and enrollment tables. Your query should also include students that do not have any enroll ...

Lab assignment working with additional database objectslab

Lab Assignment: Working with Additional Database Objects LAB OVERVIEW Scenario and Summary There is a lot more to a database than just tables and the data in them. A very important part of database security has to do wit ...

Consider a typical sales invoice that would include the

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to re ...

Select one of the four primary categories of terrorist

Select one of the four primary categories of terrorist hazards (Chemical, Biological, Radiological/Nuclear, Explosives). Provide a history of its use as a weapon of mass destruction (WMD); describe how it is made and dis ...

Benefits of data protection controlsbased on what you have

Benefits of Data Protection Controls Based on what you have learned about data protection in an online environment, prepare a 5-slide presentation to a department head or the CEO of a company to convince the audience tha ...

Option simulation preparation paperby the end of module 2

Option : Simulation Preparation Paper By the end of Module 2, you will have received the URL, team name (also known as logon ID), and password for the Littlefield Simulation site from your instructor. This week, you must ...

Data warehouses and data martswrite a one- to two-page

Data Warehouses and Data Marts Write a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts t ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro