Determine the minimal set of functional dependencies, Database Management System

Determine the minimal set of functional dependencies for the following data.

This table is part of the OHSU database of extracurricular activities and tracks the DMICE band's concerts for charities.  The DMICE band performs many concerts each year (they're in high demand!).  For each concert, a faculty, staff, or student member of the department volunteers to direct the organization of the concert, and a different member of the department volunteers to be the featured performer (thus lessening the burden of practicing time and effort on the other members of the band).  Concerts are held both in Portland and its suburbs, and concerts may be given names.There is never more than one concert a day."   Sometimes the concert names are used more than once, but always for concerts held in the same city/suburb (i.e. the "Beaverton Bash" held in Beaverton in 2012 and the "Beaverton Bash" held in Beaverton in 2013). Each concert benefits a charity, and the concert director coordinates with a contact person from that charity.  Charities may be benefitted more than once, and the contact person for a charity may vary with each benefit, but there will be only one for each performance.

Data:

concertName: the name of the concert
concertDate: the date of the concert
concertCity:the Portland suburb where the concert is held  
charityName: the name of the charity benefitted by the concert
charityContact: the name of the contact for the charity for the specific performance
charityPhone: the phone number of the charity contact person
concertDirector: the name of the person organizing the concert 
musicianName: the name of a participating musician 
primaryInstrument: a musician's primary instrument  
secondaryInstrument: a musician's secondary instrument   
concertFeaturedMusician: the participant featured in the concert

Posted Date: 3/29/2013 2:13:57 AM | Location : United States







Related Discussions:- Determine the minimal set of functional dependencies, Assignment Help, Ask Question on Determine the minimal set of functional dependencies, Get Answer, Expert's Help, Determine the minimal set of functional dependencies Discussions

Write discussion on Determine the minimal set of functional dependencies
Your posts are moderated
Related Questions
Consider the E/R schema with weak entity sets shown below. Come up with the SQL CREATE TABLE statements (with appropriate primary key, unique and foreign key constraints). Include

What is Structured Query Langauge (SQL)? SQL is a powerful set-oriented language which was formed by IBM research for the databases that adhere to the relational model. It havi

Consider the two relations given below Given that A is the primary key of R, D is the primary key of S and there is a referential integrity among S.A and R.A, discuss all

Explain the term- Query. Queries are used to repossess and show specific records in a table. They can also be used to show specific fields of specific records, which meet the co

How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct

Describe the difference between a one-to-many and a many-to-many relationship. Which logical data structures comprise one-to-many and which comprise many-to-many relationship?

Hi there, Have an issue with my Database. I have: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit Whenever I add data into the Form, it will update the table as expect

What is the main goal of RAID technology? Describe the levels 1 through 5. RAID stands for Redundant Array of Inexpensive (or sometimes "Independent")Disks. RAID is a met

Question: (a) What do you meant by content management and briefly describe four major components of a Content Management System? (b) Explain key benefits of a Content Manage

In the ER diagram, one example of subclassing is depicted following the Services entity. The subclasses Item Based and Time Based are created. The entity Services gains the attribu