Database overview & example links

judgedrunkshipServers

Nov 17, 2013 (3 years and 9 months ago)

134 views

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.