Case Study: Design a database for Tristan College. Tristan College offers various programs and currently has many studen
Posted: Tue Jul 12, 2022 8:21 am
Case Study:
Design a database for Tristan College.Tristan College offers various programs and currently has manystudents. The college wants to organize its data. You are requiredto design the database. Many students seek admission in thecollege. The college has a number of departments and students canbe enrolled to these departments. The department also offers anumber of courses to the students, each with a different durationfrom the other. Each department has its H.O.D and many teachersunder him. The syllabus of each course is also defined. Teachersare recruited by the college for teaching the said courses to thestudents. The teachers may have different qualifications andexperience. They may also teach different subjects if required.Each student in the college has a unique ID. We need to store thenames of the students studying in the college, their residentialaddress, date of birth. We also need to store information about thecollege like the name, address, contact number, reference ID,departments of the college, name of the H.O.D, number of teachersand students in the department. Also, the courses offered by thedepartments, the syllabus, the duration and the course ID. We canalso store information about the teachers like their qualification,experience, name and subjects taught.
Question:
Draw a Conceptual Diagram based on thecase study
Design a database for Tristan College.Tristan College offers various programs and currently has manystudents. The college wants to organize its data. You are requiredto design the database. Many students seek admission in thecollege. The college has a number of departments and students canbe enrolled to these departments. The department also offers anumber of courses to the students, each with a different durationfrom the other. Each department has its H.O.D and many teachersunder him. The syllabus of each course is also defined. Teachersare recruited by the college for teaching the said courses to thestudents. The teachers may have different qualifications andexperience. They may also teach different subjects if required.Each student in the college has a unique ID. We need to store thenames of the students studying in the college, their residentialaddress, date of birth. We also need to store information about thecollege like the name, address, contact number, reference ID,departments of the college, name of the H.O.D, number of teachersand students in the department. Also, the courses offered by thedepartments, the syllabus, the duration and the course ID. We canalso store information about the teachers like their qualification,experience, name and subjects taught.
Question:
Draw a Conceptual Diagram based on thecase study