1. Write the relational algebra statement(s) that specifies each of the following queries on the database shown below.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

need help

 

 

1. Write the relational algebra statement(s) that specifies each of the following queries on the database shown below.

 

 

 

 

 

 

a. Display the part name, supplier, and cost of all parts sold by the supplier named “Acme” that cost more than 5.00.

 

 

 

 

 

 

b. Display the name of all suppliers that sell a part named “widget” and the cost of the part for that supplier.

 

 

 

 

 

 

 

2. Draw the table that results from each of the following operations.

 

 

 

 

 

 

 

3. The following ER diagram represents a hotel reservation system.  Map the ER diagram to a relational schema.

 

 

 

 

4. Decompose each set of functional dependencies into BCNF. Show a diagram of the resulting dependencies. Hint: Draw the overall diagram and then decompose it.

 

a. A  C

A  D

AB  F

F  E

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

b. A  BC

B  C

BC  D

C  E

E  F

 

 

 

 

5. Eliminate redundant FDs from each of the relations below.  For credit you must show the table used in class to eliminate redundancies. Show the resulting diagram without redundancies. If no redundancies exist, state that fact.

a.

 

 

 

 

 

 

 

 

 

 

b.

 

 

 

 

 

 

 

 

 

 

c.

 

 

 

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of