IST366: Database Design and Report Writing

• Syllabus.
• IST366 online work area.
• Lectures:
  1. Relational database structure.
  2. Entity-Relationship model.
  3. Functional Dependencies.
  4. Normalization.
  5. MySQL data types.
  6. Altering table.
  7. Updating and Deleting records, Retrieving data.
  8. MySQL String, Date, and Time Functions.
  9. The MySQL access privilege system.
  10. Indexing, Optimization, Backup, and Restore.
  11. Apache server and PHP: Installation and configuration.
  12. Variables in PHP scripts and Passing data to PHP scripts.
  13. Flow control constructions in PHP.
  14. Arrays in PHP.
  15. Functions in PHP. Global and local variables.
  16. MySQL API Support in PHP.
  17. Regular expressions in PHP.
• Projects:
  1. Normalization
  2. Student-Classes Database. Step I: Design.
     

     Solution:	Beginning of the solution of the first part
     	Database structure

  3. 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.
  4. Student-Classes Database. Step IV: PHP interface (advanced)
     Examples are available here.
  5. Student-Classes Database. Step V. PHP interface (final)
     
• Quiz of the day
• Final Exam