entity Attribute and primary key, also draw Entity diagram?
Perform given tasks on Case study
Q-Find entity Attribute and primary key, also draw Entity diagram?
Case study:
In a college we have students, department, teachers and courses. A student has name registration No and address. A teacher has name NIC and qualification. A department is known by its name e.g. CSIT, and have a HOD name , Num of students and Floor No. A course is identified by its Code. Course also has name and level of degree. A student must enroll (roll no and Semester as relationship attribute) in any one department. A department can have many students. The teacher is assigned class (time and day as attribute) in more than one department. A department has many teachers. A student can study up-to 5 courses by a teacher in given classroom number.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
