(MIS) “database management system”

MIS 345 Database Management System

Lab 5

Given the list all business rules needed for that business Draw ERD, convert into relational tables & apply it in MS Access.

1) A university contains many facilities. The facilities in turn are divided into several schools. Each school offers numerous programs and each program contains many courses. Lecturers can teach many different courses and even the same course numerous times. Courses can also be taught by many lecturers. A student is enrolled in only one program, but a program can contain many students. Students can be enrolled in many courses at the same time and the courses have many students enrolled.

2) A dental clinic has many dentists who are assigned to one or more appointments in a day. Each appointment is assigned to only one doctor. Each patient can book only one appointment within a day. Each appointment is assigned to only one patient. Nurses can help one or more dentists during the session, but dentists may need the nurses help in some sessions. A dentist may use many rooms during the day but the room can be used by many dentists and sometimes it is not used by any one.