Question

Questions of this part analyze the students’ understanding in analyzing the given scenario and practical skills to build Class diagrams studied in chapters 8, 10 and 12of IT242. The “SES” administration would desire to have a database system to keep track of students, instructors, courses, assessments, and grades. Read the following paragraph to answer the given questions. The system maintains courses’ information. For each course, the system keeps a unique course code, name and credit hours. Each course offered in one to ten sections (CRNs). A section has a section ID, year, semester (i.e., semester 1, semester 2 or summer), time, room and seating capacity. One to three instructors teach each section, and an instructor can teach zero to five sections. The instructor details to be stored are instructor ID, name, password, email, contact number and address. The system also stores students’ information. Each student has a student ID, name, password, email, major, contact number and address. Students have to enroll to one to seven sections each semester. In each section, three to six assessments administrated to students including a mid-semester and a final exam. Assessments are the same for the sections of the same course. An assessment has an assessment ID, due date and maximum grade. For each assessment, a student is given a grade. Each grade has a grade ID and value. Each grade provided by one instructor only and belongs to one student only.

3.1 Identify the classes and their attributes from the given paragraph.

class	Attributes

3.2 Draw a Class diagram for the given database. The picture must show all classes, relationships between classes, and multiplicities.

pleaase don't copypast, don't hand write, please i want a good answer

Answer 1

3.1 After reading the above paragraph the Class and Attributes are:

Student	Student_id, name, password, email, major, contact_no, address
Instructors	Instructor_id, name, password, email, contact_number, address
Courses	Course_code, c_name, credit_hours
Assessments	Assessment_id, due_date, maximum_grade
Grades	Grade_id, value
Section	Section_id, year, semester, time, room, seating_capacity

This is the main database table of the system. The entity and attributes are mentioned in the table. Now the class diagram of the given database is drawn below:

3.2 Class DIagram-