Given that we will have a database for students and lecturers to record the courses in which they are engaged, a registration number, name, age, gender, and phone number are all part of the student's information. These students enrolled in up to three courses at the same time. The students are from the different level of their studies which is whether from the graduate and undergraduate level. If they are from graduate level, there will be in an option within the program for research or mix mode. Lecturers may teach more than one course per semester, but no more than three. Each lecturer has their name, position, unique identification number, and course that they teach. These courses are taught by a specific faculty member who is the lecturer. The information about course are the name, code and any other related information that needed. Faculty have their unique name and number of lecturers. Sketch a complete Enhanced - ERD (refer to Chen’s model) to visualize how you would track this data based on the scenario above. Show entity names, primary keys, properties, relationships, and cardinality. You shall add any other appropriate attributes on your own
Given that we will have a
they are engaged, a registration number, name, age, gender, and phone number are all part of
the student's information. These students enrolled in up to three courses at the same time. The
students are from the different level of their studies which is whether from the graduate and
undergraduate level. If they are from graduate level, there will be in an option within the
program for research or mix mode.
Lecturers may teach more than one course per semester, but no more than three. Each lecturer
has their name, position, unique identification number, and course that they teach. These
courses are taught by a specific faculty member who is the lecturer. The information about
course are the name, code and any other related information that needed. Faculty have their
unique name and number of lecturers.
Sketch a complete Enhanced - ERD (refer to Chen’s model) to visualize how you would track
this data based on the scenario above. Show entity names, primary keys, properties,
relationships, and cardinality. You shall add any other appropriate attributes on your own
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
