System Analysis and Design for Middle East College and Sydney Dentist Centre

Running head: SYSTEM ANALYSIS AND DESIGN
System Analysis and Design
Name of the Student:
Name of the University:
Author Note

1
SYSTEM ANALYSIS AND DESIGN
Question one: Middle East College Case Study
List of the Possible entities and the attribute for each of the entities:
The list of the entities for the case study are:
 Students
 Department
 Courses
 Registration
 Fee Statement
 Employees
 Payments
The list of attributes under the particular entities are:
Students: StudentID (pk), StudentName, StudentAddress, StudentContact, DOB, Student
Type
Department: DepartmentID (pk), DepartmentName, DepartmentStrength
Courses: CourseID (pk), DepartmentID (fk), CourseDuration, SemesterCharge
Registration: RegistrationID (pk), StudentID (fk), CourseID (fk), EmployeeID (fk)
Fee Statement: FeeID (pk), RegistrationID (fk), StudentID (fk), CourseID (fk), TotalCost
Employees: EmployeeID (pk), EmployeeType EmployeeName, EmployeeAddress,
EmployeeContact
Payments: PaymentID (pk), FeeID, PaymentMenthod, PayerName
List of the possible use case and the actors:
The list of possible actors is provided below:

2
SYSTEM ANALYSIS AND DESIGN
 Students
 Staffs
 Lecturer
 Instructor
 Tutor
 Service Director
The list of use cases for the actors described above are provided below:
 Check Time Table
 Registration
 Fees payment
 Receive Fees Statement
 Access Payment System
 Prepare course time table
 Check Student Details
 View the number of students