Entity Relation Problem A University must contain many Faculties. Faculties must belong to one University. The Faculties, in turn, must be divided into several Schools. The school must be divided by one Faculty. Each school must employ many lecturers. Lectures must employ to one school. Each School must offer numerous programs. And each program must be offered by one school. Each program must contain many courses. The course must have contained by one Program. Lecturers must teach many different courses and even the same course numerous times. Courses must also be taught by many lecturers. A student must be enrolled in only one program but a program must contain many students. Students must be enrolled in many courses at the same time and the courses must have many students enrolled. Show all entities, relationships, optionalities, connectivities, and cardinalities. Use new notation.
Create a entity relion diagram
Entity Relation Problem
A University must contain many Faculties. Faculties must belong to one University. The
Faculties, in turn, must be divided into several Schools. The school must be divided by one
Faculty. Each school must employ many lecturers. Lectures must employ to one school. Each
School must offer numerous programs. And each
Each program must contain many courses. The course must have contained by one Program.
Lecturers must teach many different courses and even the same course numerous times.
Courses must also be taught by many lecturers. A student must be enrolled in only one program
but a program must contain many students. Students must be enrolled in many courses at the
same time and the courses must have many students enrolled. Show all entities, relationships,
optionalities, connectivities, and cardinalities. Use new notation.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
