Question: . Examine the following semantics rules ( relation Student - Lesson - Prof. or SLP ) . for the courses : a . for each

. Examine the following semantics rules (relation Student-Lesson-Prof. or SLP).for the courses :
a. for each subject , each student of that subject is taught by only one teacher
b. each teacher teaches only one course
c. each subject is taught by several teachers
Please give :
(1) the tabulation SLP
(2).what are the functional dependencies in the relation?
(3) is 1NF,2NF,3NF, BCNF?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!