CTC The SQL Code Creating a Course Scheduling System Programming Exercise

1. The inserting of courses to be taught during the next semester. Look at Banner to determine what fields you need to include. There should be multiple tables because remember that a course can be offered multiple times (so you need a course table), an instructor can teach multiple courses (so you need an instructor table), and a student can take multiple courses (so you need a student table). (Phase 1)

2. A different PHP insert page will allow the student to register for courses. How are you going to make sure only xx number of students register for a course? You must also have an insert PHP page for the administrators to add courses (we will ignore delete and update). (Phase 2).

3. The administrator should be able to generate reports to determine the number of students in a class, and what classes an instructor is teaching. They should also be able to search on course number or instructor). (Phase 3).

Good luck. Use the discussion board to ask questions!

In Phase one of the project (due 11/15) you are to design your database. The database MUST be designed in WorkBench. The database must be in Third Normal Form.

What to turn in for Phase 1 (11/15):

1. The SQL code (by extracting it from WorkBench), compress it using zip.

2. Screen shots showing the design of the database and the relationships between the tables.

What to turn in for Phase 2: (due 11/22)

1. PHP code for screens that will allow the user to enter information into the database via a website. The code MUST include validation. Include code which restricts what kind of data can be entered into the textboxes. Such as string, or numeric. Also make sure that no SQL Injection (SQL strings) can be entered. Look on the Internet for examples of how to restrict this. The web page MUST be clean and professional looking.

2. Screen shots showing errors you display if they enter bad data. Screen shots showing the data entered and the data now appearing in the database itself.

3. The SQL code (by extracting it from WorkBench), compress it using zip. The code should now also include insert statements generated by WorkBench to enter the data.

What to turn in for Phase 3 (final phase): (due 12/6)

1. PHP code for screens which allow the user to display the data. The user MUST have the ability to select different types of data to display. Such as one table of data, or multiple tables of data that are related. The code should also allow the user to search for some data (such as the course number, instructor).

2. Screen shots showing any errors you display if they enter bad information (such as search for something that is not there). Screen shots showing all current data in the database. Screen shots showing the results of requesting to display one table. Screen shots showing the request to display multiple tables. Screen shots showing the request to search for data,

3. The SQL code (by extracting from WorkBench) compredd using zip. The code should indicate the same data as shown in your screen shots.