Question

Please reference the STUDENT TABLE & Business Rules to answer parts a, b & c of question 1:

1. Using the table description and business rules on the following page, answer the following:

1. Identify the Primary Key of the table as it is currently shown.
2. Identify all of the functional dependencies.
3. Draw the dependency diagram for the initial table showing all dependencies.

Business Rules:

• Only one class is taught for each Course ID.
• Students may take up to 4 Courses.
• Each Course may have a maximum of 25 Students.
• Each Course is taught by only one Instructor.
• Each Student may have only one major.

STUDENT TABLE

Student_ID	Student_Name	Student_Address	Student_Major	Course_ID	Course_Title	Instructor_ID	Instructor_Name	Instructor_Office	Stu_Crse_Grade
268300458	Williams	208 Brooks	CIS	CIS 350	Database	301	Codd	B104	A
268300458	Williams	208 Brooks	CIS	CIS 465	Systems Anal	451	Parsons	B317	B
543291073	Baker	104 Philips	Acct	CIS 350	Database	301	Codd	B104	C
543291073	Baker	104 Philips	Acct	Acc 201	Fund of Acctg.	255	Miller	H310	B
543291073	Baker	104 Philips	Acct	Mkt 300	Intro to Mktg	518	Bennett	B212	A
695381127	White	208 Brooks	Math	Mth 202	College Algebra	622	Hilbert	M301	B
695381127	White	208 Brooks	Math	Acc 201	Fund of Acctg	255	Miller	H310	A

Answer 1

A. Primary key for the given relation is {Student_ID, MajorCourse_ID} since the combination of (Student_ID, MajorCourse_ID) is unique.

B.

The Functional Dependency possible are

Student_ID -> Student_Name, Student_Address, Student_Major

Course_ID -> Course_Name

C. Dependency diagram is

If you have any questions comment down. Please don't simply downvote and leave. If you are satisfied with answer, please? upvote thanks