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]
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 }
Determine keys using the Left, Middle, Right method discussed in There are multiple keys, you must find all of them. [5 marks]
Is relation R in 3NF? If not decompose it into relations in 3NF. [5 marks]
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]
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.
Determine keys using the Left, Middle, Right method discussed in There are multiple keys, you must find all of them. [5 marks]
Find the minimal basis for the given FD’s using method shown in class. [10 marks]
Use the 3NF synthesis algorithm to find a lossless-join, dependency-preserving decomposition of R into 3NF relations. [10 marks]
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]
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.
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]
Which relational model conversion method works best to answer the following questions and why?
[5 marks]
List First name and Last name of all customer who ordered a value
List all the orders without value
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
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
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
