Question

1)

Create a Conceptual Diagram (electronically) for the following scenario – this time DO NOT LEAVE the Many to Many relationships (break them out). Also, like the last scenario, make sure you identify the major attributes. Save the readable image and embed it back into this document.

This scenario describes the activities of the Science and Technology faculty in a university in Utah. Students take courses in the university. The courses are run by departments. It is possible for a course to be run by more than one department. Each course consists of a number of units. Lecturers teach the units, and in some circumstances more than one lecturer will teach a unit. Lecturers of course teach on more than one unit. Since the introduction of 'modular' courses, it is possible for one unit to be included on more than one course. A lecturer may be a course leader for a particular course.

Answer 1

Conceptual Diagram Studen +student name: strng student id integer student ads string date join: date coUrse:string University deprtment name: strng cOUrses string lecture name: strng students id integer Deprtment deprtment name: strng lecture name: string coUrses string +lecture name: strng deprtment: string coUrses string course name: string lecture name: strng students id: integer course unt string course name: string +lecture name: strng Modular Courses +module idstring course leader: string course name: string students id: integer