You have been employed by the Southern Tiny College to develop Student Registration System. To understand the functions of Registrar Office, you have spent some time talking to various personnel in the Registrar Office and also you've examined some of the forms used for student registration and class rolls. Your notes include the following observations:
- Students are not allowed to register in a course for which the student does not have pre-requisites.
- Students cannot enroll in more than 18 credit hours in a semester.
The office of the Registrar maintains data on
- Courses and pre-requisites
- Students
- Class schedules
- Student registration data
However, the system requires more data such as courses, professors, employees (of the college), departments.
You are going to develop Enrollment application so that students can register for classes. This application will allow
- students to do registration (that means add new records to the Enroll table).
- students to make changes in their registration (add/drop)
- registrar's office staff to add/edit records in Student table, Courses table, Professor table, Class Schedule table
- view data from any table
Following rules apply:
- Records in Student, Professor, Employee, Pre-requisite tables are added, edited and deleted by only Registrar office staff.
- Professors and registrar office staff can register (and add/drop) any student in one or more course.
- A student can add/drop class for himself/herself.
- When student registers for a class, the record is added to the Enroll table.
Given these brief notes, I have designed the database for you to use in your application development. The database has following tables:
Class (class schedule) - schedule of classes for students to choose when registering.
Course - course catalog with course pre-requisites
Student
Professor
Department (department in which a professor belongs))
Employee
Enroll (student registration data are saved in this table)
I have created MS Access database. The name of the database is CFProjectSP15.mdb. You will use this database to develop and test your application. Please, carefully review the database structure, each table's attributes and the ERD.
Table attributes:
STUDENT (STU_NUM, STU_LNAME, STU_FNAME, STU_INIT, STU_DOB, STU_HRS, STU_CLASS, STU_GPA, STU_TRANSFER, DEPT_CODE, STU_PHONE, PROF_NUM)
ENROLL (YEAR, SEMESTER, CRN, STU_NUM, CLASS_CODE, STU_GRADE)
COURSE (CRS_CODE, DEPT_CODE, CRS_DESCRIPTION, CRS_CREDIT, PREREQ_1, PREREQ_2)
EMPLOYEE (EMP_NUM, EMP_LNAME, EMP_FNAME, EMP_INIT, EMP_CLASS, DEPT_CODE)
CLASS (CRN, CRS_CODE, CLASS_SECTION, CLASS_TIME, ROOM_CODE, PROF_NUM)
PROFESSOR (EMP_NUM, DEPT_CODE, PROF_OFFICE, PROF_EXTENSION, PROF_HIGH_DEGREE)
DEPARTMENT (DEPT_CODE, DEPT_NAME, SCHOOL_CODE, EMP_NUM, DEPT_ADDRESS, DEPT_EXTENSION)
The ERD for the above entities is drawn below.
It is recommended that you develop the application locally on your computer. Also download ColdFusion 10 Developer Edition from Adobe website. It is free software.
You will create database connection (ODBC) and give the name of the Data Source Name (DSN) stcenroll. Use this DSN in your ColdFusion programs.
You MUST follow this requirement:
In order for me to run your application on my computer, it is necessary that your use stcenroll as the DSN.
Develop the application in ColdFusion 10 to insert, edit and maintain database. Your application will have following features:
1. Welcome and Login Page.
2. Login for student (User ID is student id and password is professor id)
3. Login for employee (User ID is employee number and password is department code)
4. Main menu displaying options (Add, Edit, Delete, Search) for the user (student or employee) to select
5. Add sub-menu to add records in tables.
6. Edit sub-menu to modify records in tables.
7. Delete sub-menu to delete records in tables.
8. Search sub-menu to search records in tables.
The user should be able to navigate from one page to other page with consistent menu displayed.