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.
Enter the password to open this PDF file:
File name:
-
File size:
-
Title:
-
Author:
-
Subject:
-
Keywords:
-
Creation Date:
-
Modification Date:
-
Creator:
-
PDF Producer:
-
PDF Version:
-
Page Count:
-
Preparing document for printing…
0%
Comments 0
Log in to post a comment