logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Milton BlahaEconomics
(5/5)

900 Answers

Hire Me
expert
Barry CresswelllTechnical writing
(5/5)

922 Answers

Hire Me
expert
Earl BarwinAccounting
(5/5)

972 Answers

Hire Me
expert
Rooma KalranMarketing
(5/5)

918 Answers

Hire Me
Database

Given a relation R= {A, B, C, D, E, F} and a set of functional dependencies FD’s: {AB→C, DC→AE, E→F} Determine keys using the Left, Middle, Right method discussed in class.

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS
  1. Given a relation R= {A, B, C, D, E, F} and a set of functional dependencies

FD’s: {AB→C, DC→AE, E→F}

Determine keys using the Left, Middle, Right method discussed in class. There are multiple keys, you must find all of them. [5 marks]

 

  1. Given a relation R= {A, B, C, D, E, G, H} and a set of functional dependencies

FD’s: { CD→A, EC→H, GHB→AB, C→D, EG→A, H→B, BE→CD, EC→B }

  1. Determine keys using the Left, Middle, Right method discussed in There are multiple keys, you must find all of them. [5 marks]

  2. Is relation R in 3NF? If not decompose it into relations in 3NF. [5 marks]

 

  1. Given a relation R= {A, B, C, D, E, F, G, H } and a set of functional dependencies

FD’s: { A→B, ABCD→E, EF→ G, EF→H and ACDF→EG}

Find the minimal basis for the given FD’s using method shown in class. [10 marks]

 

  1. Consider a relation Courses(C, T, H, R, S, G), whose attributes may be thought of informally as course, teacher, hour room, student, and

Let the set of FD’s for Courses be C → T, HR → C, HT → R, HS → R and CS → G.

Intuitively, the first says that a course has a unique teacher, and the second says that only one course can meet in a given room at a given hour. The third says that a teacher can be in only one room at a given hour, and the fourth says the same about students. The last says that student get only one grade in a course.

  1. Determine keys using the Left, Middle, Right method discussed in There are multiple keys, you must find all of them. [5 marks]

  2. Find the minimal basis for the given FD’s using method shown in class. [10 marks]

  3. Use the 3NF synthesis algorithm to find a lossless-join, dependency-preserving decomposition of R into 3NF relations. [10 marks]

  4. Use the chase test for lossless join to tell whether we can recreate the original courses relation with the same tuples using natural join of relations from 4(c). [20 marks]

 

  1. The fictional online service BitBarrow provides a repository for shared software It uses a database to track various aspects of the service, including the following.

  • Users, who are identified by their personal email address and each have a registered name and nickname.

  • Projects, identified by a unique project title.

  • Which users work on which projects. Each user can work on several different projects, and each project may have multiple

  • For each project, exactly one user who is the project

  • Different kinds of project. Projects may optionally be declared as mobile, desktop, or server. Mobile projects need an identified platform, and desktop projects a named operating

 

Draw an E/R diagram for this situation. Create attributes that are suitable for keys, and indicate weak entity sets if needed. Make sure to indicate relevant cardinality constraints. [10 marks]

 

6.

  1. Convert the ER diagram to a relational model using E/R method, Object Oriented method and nullsmethod. Write the schema for each relation in the model. [15 marks]

  2. Which relational model conversion method works best to answer the following questions and why?

[5 marks]

  1. List First name and Last name of all customer who ordered a value

  2. List all the orders without value

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. 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

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

300 Experts Online