Question

Assignment 9 Based on your previous assignment of use case analysis, perform data modeling using ERD Ensure all data storeS are made into entitieS Identify all attributes and relations Prepare the CRUD matrix Due TBA

The main idea is website connect teachers calendar with students and the student's can take an appointment's with their teachers.

Please, Do an ERD(entity-relationship diagram) from the three use cases: 1-Administrators 2-Faculty members 3-Students

Answer 1

The teacher student appoinment through a calendar is as follows:

Explaination:

The ER diagram consists of the teacher and student section along with the administration section.THe student asks the teacher for the calendar and checks for the availability of the teacher, if available he gets the appoinment with the teacher.

Teacher Stucent Appoinment Teacher Teacher 从 teaches 从 「ー·lass | |student Takes Class StudentSection 0 in TimeSlot Administration Adminstration TimeSlot

Hope this helps.... Please rate the answer if it helped you.....