Question: BACK TO IMS Word document doc Based on the scenario given below, draw an ER diagram and specity the multiplicity constraints for each relationship IHA

 BACK TO IMS Word document doc Based on the scenario given

BACK TO IMS Word document doc Based on the scenario given below, draw an ER diagram and specity the multiplicity constraints for each relationship IHA University consists of several departments.cach department runs a number of courses. The university provides a set of modules used in different courses. Each course uses a number of modules but not every module is used a course is assigned a unique course code and a module is identified by a unique module code. A module con be used in one course only, but can be studied by many students. In addition to the module code each module unique title, stort date and end date are also stored. The dotoboze should also store coch course unique title and duration A student con enrol in one course at a time Once enrolled o student is assigned a unique matriculation number. Additional data stored on each student includes student name and address, Each department is managed by a member of acadernic statt. Each cepartment has a name, phone number and looption. Each department employs many members of coudemic stott A member of academic statt works to one department only. All members of academic staff tech modules Every member of academic staff teaches one or more modules and a module may be taught by more than one member of academic stutt Each member of academic stuff is identified by a unique statt number. Additional data stored on each member of academic stort includes name and phone extension number (20 marks) (CLOZPO2.04) E T E 3 IN B III Im Link Maximum file size: 50MB, maximum number of tiles

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!