Question: This exercise is a variation of Exercise 18. Consider the following functional dependencies prevailing over the relation schema CLASS (Student, Subject, Teacher): {Student, Subject}

This exercise is a variation of Exercise 18. Consider the following functional dependencies prevailing over the relation schema CLASS (Student, Subject, Teacher):
{Student, Subject} †’ Teacher
Teacher --/--> Subject
Subject --/--> Teacher
{Student, Teacher} --/-> Subject
a. What do these rules mean in words? Are all these rules necessary? If not, explain which are not needed.
b. Is the following sample data consistent with these rules? Why or why not?

c. Does this version of CLASS satisfy the requirements of BCNF? Is it free of modification anomalies triggered by undesirable functional dependencies? Is it free of modification anomalies altogether?

Student Smith Smith Jones Jones Subject Math Physics Math Physics Teache White White Green White

Step by Step Solution

★★★★★

3.26 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a fd1 A given student has only one teacher per subject that student may have the same teacher for an... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

887-CS-DB (2192).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Rewrite Exercise 20.17 using JSF, as shown in Figure 33.35. The program lets the user enter four card values and finds a solution upon clicking the Find a Solution button. This exercise is a...

Suppose F {fd1, fd2} consists of the following functional dependencies: fd1: Ssn {Ename, Bdate, Address, Dnumber} fd2: Dnumber {Dname, Dmgrssn} Which of Armstrong's axioms allows the following...

a. Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the SURGERY SCHEDULE Table. b. Show the result of normalizing...

18. Consider the relation schema CLASS with attributes Student, Subject, and Teacher. The meaning of this relation is that the specified student is taught the specified subject by the specified...

kindly reviewed this article The current issue and full text archive of this journal is available de Emerald Insight at www.emeraldinsight.com/2016-469x.htm Downloaded by Ghana Institute of...

3.2 Identifying FR level of importance using factor analysis The level of importance of the FRs is determined in this study by the application of factor analysis (principal component technique). The...

Read the information in all photos and answer the questions using what you read. 2.3 Students treated as customers Gruber et al. (2010), in their research paper, treated students as customers in the...

Please read the question Question: Choose one of the teaching strategies from the article that you read 1. What is the teacher is trying to accomplish by using this technique? (That is, what's the...

Please read the question Question: Choose another different one of the teaching strategies from the article that you read 1. What is the teacher is trying to accomplish by using this technique? (That...

1-Please provide 5 cross-examination questions for: Chris Moss Dr. Gerry Stein Sydney Payne Terry Preece Leslie Brown Alex Lloyd 2-Explain why/how/if you would use exhibits A, B, C, and D. 3-What...

As we have been discussing, its important to consider reliability as an essential concept to be handled to improve service quality. Chris Arlen in his 2008 article posted on the Service Performance...

Here is the Income statement with budgeted and actual data for Dollar, Inc., which sells kids clothing and supplies: The difference between the actual and budgeted amounts of revenue was created by...

Suppose that on March 1 , 2 0 1 4 Cardullo's purchased an order of German chocolate from a supplier for $ 2 5 0 , but didn't pay cash for the order until March 3 1 , 2 0 1 4 . How would you record...

An urn contains five white and six black balls. (a) Three balls are drawn from the urn one after another without replacement, and it is found that one of them is white and the other two are black....

List three main features of mobile computing over wireless networks that are distinct from traditional distributed systems.

List three factors that need to be considered in query optimization for mobile computing that are not considered in traditional query optimizers.

Define a model of repeatedly broadcast data in which the broadcastmedium is modeled as a virtual disk. Describe how access time and data-transfer rate for this virtual disk differ from the...

To calculate the number of years until maturity, assume that it is currently May 2010. Rate Maturity Mo/Yr Bid Asked Chg Ask Yld ?? May 20 106:18 106:22 +2 5.06 6.700 May 28 108:17 108:19 +4 ?? 5.400...

for the population as a whole, average healthcare spending us $1,190 per year. those with a family history of cancer (5 percent of the population) spend $20,000 on average, and those with no family...

Barenbaum Industries projects that cash outlay of $4.5 million will occur uninformly throughout the year. Barenbaum lans to meet its cash requirements by periodically selling marketable securities...