Database overview & example links

Database overview

Information in a db

The transformation of raw data into organized
tables of information … indexed by unique
keys … supporting rapid updates and
boolean queries

Key terms

Primary key

Secondary key

Foreign key

Attributes

Normalization

Typical operations
–

select, join

normalization

1NF

-


eliminate duplicate columns




establish primary key

2NF
-


remove sub
-
grouped data




establish foreign key

3NF
-


remove data not fully dependent





on primary key

4NF
-


remove multi
-
valued dependencies

… working examples


•
Set up database examples

•
Set up JSP/Servlet sample code

–
Download Tomcat and MySQL

–
Set up web site to demo the code

–
Set up mysql server to access through WAN


•
Download and Installation notes
>>


•
http://www.coreservlets.com/Apache
-
Tomcat
-
Tutorial/

•
http://dev.mysql.com/doc/



•
Database Schema

–
Non
-
Chargeable Calling Card
>>

–
Rechargeable Calling Card
>>

–
The difference: active_card (patronID,
rechargeDate)

•
JSP/Servlet Sample Application
>>

•
Based on the current E
-
Z Pass model

•
ER Diagram
>>

•
Notes

–
Tag is not necessary tied to one vehicle

–
Need additional tables for Agency, Plaza, and
Lane information.