To access the Database Design Module, go to: ign Module, go to: http:/ladbe.kenn

Question

To access the Database Design Module, go to: ign Module, go to: http:/ladbe.kennesaw.edu/ http://adbc.kennesaw.edu/ Functional Dependencies In this section go through the following sections/scenarios: Introduction Help (Read instruction on how to use this sub module) Hospital scenario University scenario Stocks scenario Normalization In this section go through the following sections/scenarios: Help (Read instructions on how to create tables and designate Primary Keys) Employee scenario Auto Theft Scenario Property scenario Customer scenario Medicine scenario

Explanation / Answer

Hi, Functional Dependecies means basically, the relations between attributes such that to find attributes that can be used to derive other attributes, i.e basically any key, primary or candidate.

1. STAFF_MEETING(EmployeeName,ProjectName,Date)

its given that, that a project meets atmost once per day, which means date is unique.
its also given that, only one employee represents any given project. which means project is unique.

so basically the dependencies will be,

ProjectName-> EmployeeName,Date // because project name can uniquely define one row in the table
Date ->ProjectName,EmployeeName

2. STUDENT(Number,Name,Dorm,RoomType,DormCost,Club,ClubCost,Sibling,Nickname)

Now, using the same concept as above.

given, students pay different dorm costs , depending on type of room,

RoomType->Dorm,DormCost

but all club members pay same cost, which means same club will have same roomtype ,

Club->RoomType also Club->Dorm,DormCost // combining.

given students have multiple nicknames, so its not a key. but nothing is specified about number or name.

if any of them is unique and not null, then we can add that to the dependency list.

Thumbs up if this was helpful, otherwise let me know in comments.

Good Day.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.