IST366: Database Design and Report Writing
Syllabus
.
IST366 online work area
.
Lectures:
Relational database structure
.
Entity-Relationship model
.
Functional Dependencies
.
Normalization
.
MySQL data types
.
Altering table
.
Updating and Deleting records, Retrieving data
.
MySQL String, Date, and Time Functions
.
The MySQL access privilege system
.
Indexing, Optimization, Backup, and Restore
.
Apache server and PHP: Installation and configuration
.
Variables in PHP scripts and Passing data to PHP scripts
.
Flow control constructions in PHP
.
Arrays in PHP
.
Functions in PHP. Global and local variables
.
MySQL API Support in PHP
.
Regular expressions in PHP
.
Projects:
Normalization
Student-Classes Database. Step I: Design.
Solution:
Beginning of the solution of the first part
Database structure
Student-Classes Database. Step III: PHP interface (beginning)
Here is an example of
student registration form
. It may have some things you would like to use in your assignment.
Student-Classes Database. Step IV: PHP interface (advanced)
Examples are available
here
.
Student-Classes Database. Step V. PHP interface (final)
Quiz of the day
Final Exam