Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The purpose of this assignment is to create an interactive website by using Objectoriented PHP and MySQL Database. Aims In this assignment, you will need

image text in transcribed

image text in transcribed

The purpose of this assignment is to create an interactive website by using Objectoriented PHP and MySQL Database. Aims In this assignment, you will need to develop a dynamic website, "My Online Subject Enrolment System". The website offers online subject enrolment services to students. It has three types of users, i.e., Administrator, Educator and Student users. All types of users should have options to register or login into the system.| The Administrator user can: Insert subjects into the system, View the subjects, Search for a subject, Edit a subject and Remove a subject. The Administrator should be able to list all subjects, including the active, inactive, and removed subjects. The Educator user can: Teach/, View his/her teaching subjects, Search for an enrolled student. The Educator should be able to list his/her teaching subjects and students (both active and withdrawn students) of subjects. The Student user can: Search for a subject, Enrol in a subject, and Withdraw from a subject. The Student user can check the subject-related information, such as subject name, code, lecture date/time, lecturer name, and lecture venue. However, student users can't check other students' information. For Administrator, there should be information about Staff ID, Name, Phone, email and position. For Educator, there should be information about Staff ID, Name, Phone, email and teaching subjects. For Student, there should be information about Student ID, Name, Phone, email and enrolled subjects. For every subject, there should be information about: Subject Code, Name, Lecturer, Venue, and Student Number. When searching the subjects or the students, there should be options to search by an individual item, such as ID, Name, email and etc, or by a combination of multiple items. The entered information for the searching purpose needs to be validated in the PHP script. Requirements 1. Design Requirements The website should have interfaces for: - Register/Login the users; - Insert subjects; - Search subjects (by an individual/a combination of items); - List all subjects; - List all active/inactive/removed subjects; - Search students (by an individual/a combination of items); - Enrol in a subject; - Withdraw from a subject; - Teach a subject; - Not teach a subject. 2. Functionalities - All users should be able to register into the system; - All users should be able to login into the system; - All users should be able to logout; - The Administrator should be able to insert subjects into the system; - The Administrator should be able to list: all, active, inactive, and removed subjects; - The Administrator should be able to change the status (active, inactive, removed) of the subjects; - The Educator should be able to teachot teach a subject; - The Educator should be able to list: all available and withdraw students of a teaching subject; - The Student should be able to enrol in a subject; - The Student should be able to withdraw from a subject; - The Student should be able to list all enrolled subjects. 3. Other Expectations - The students should create classes and database with tables based on the requirements of the assignment; - The website should have good interfaces and navigation thru the given options

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Databases Concepts And Practice

Authors: Suzanne W Dietrich

1st Edition

1119827949, 9781119827948

More Books

Students also viewed these Databases questions

Question

6. Conduct a cost-benefit analysis for a training program.

Answered: 1 week ago