Main Menu
Lecture 1
Lecture 2
Lecture 3
Lecture 5
Lecture 6
Lecture 7
 

 

 

Part 1 : Introduction To Database Design

Example : Design of a Class Management System

Step 1. site architecture - navigation and links

Step 2. page layout

Step 3. Web application state ( What goes where )

Application data structures

Hit count, number of logins

How many classes is it designed to support? Which is the best way to support multiple classes - seperate application instances or separate session instances - the latter needs an additional user entry to select class

Session data structures

User class (name, uid, number, password)
Student class extends User ( lab class, links to assignments,image reference)
Admin class extends User ( list of tutorials they own, link to personal page etc )

Step 4 Database - ??