Assessment 2 (10%) In-Class Practical Test (1 hour) Assessment 2: using Software to draw an ERD It is required to follow the Crows Foot Notation. Recommended Software to draw ERD: Microsoft Visio or Online Software as follows: https://go.gliffy.com/ https://www.lucidchart.com/ Students will be given 10 minutes reading time. Marking schemas will follow Crows Foot Notation as follows: Entities (2 marks): An entity is represented by a rectangle, with its name on the top (CAPITALISED). The name is singular (entity) rather than plural (entities). Please note, you should use UPPERCASE to name your entities. Attributes (5 marks): Primary key attribute is underlined; and foreign key presented in italic font. Please note, use camelCase to name attributes, e.g. FirstName Relationships (3 marks): Relationships have two indicators, maximum number and minimum number, which are shown on both side of the line. Regarding Cardinality Relationships, you are required to document all assumptions, things that are accepted as true or as certain to happen, without proof.

A university registrars office maintains data about the following entities:

instructor, including staff identification number, name, and department; class, including class number, class time, semester, and year; course, including course number, and title; room, including room number and location; student, including student ID, student name, and email;

Business rules (i.e., relationships)

an Instructor teaches zero, or many classes and a class is taught by one Instructor. a course may generate zero, or many classes and a class comes from one course. a class is held in one room but a room has many classes. a class may enroll zero or many students, and a student may enroll in zero or many classes in each semester.

Construct an E-R diagram for the registrars office. Document all assumptions that you make about the mapping constraints.