1. Engineering
  2. Computer Science
  3. 3 total marks 10 consider the following relation enrolled studid...

Question: 3 total marks 10 consider the following relation enrolled studid...

Question details

3. (total marks 10) Consider the following relation: Enrolled (Studid, Crsid, Ctitle, Score, Lettergrade) Assume that a student (Studid) may be enrolled in multiple courses (Crsid) and hence (Studid, Crsid) is the primary key. Thus, the following functional dependency exists Studid, Crsid) ->Ctitle, Score, Lettergrade) Additional dependencies are: Crsid -Ctitle Score->Lettergrade Based on the given primary key, i. Is this relation in 1NF, 2NF, or 3NF? Why or why not? ii. If not in 2NF at least, normalize it completely into 2NF and 3NF? Provide your answers using functional dependencies (FDs). Total for que 3 is 10 marks)

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution