CSC 455 Database Management Systems
Chapter 1 slides
DDL/DML Examples
Chapter 2 slides
- The relational model and relational algebra
Banking Example
Chapter 3 slides
- Intro to SQL
Dilbert and SQL
Basic instructions for using MySql on the CSC server
Creating/populating/querying the mail order database
Create mail order
Insert mail order
Query list
,
solution
MySql specific stuff
Some MySql
examples
, using
Date
data-types,
transaction
processing
Subquery examples
,
subquery errors in SQL
MySql tutorial
MySql manual
Compare various database implementations
MySql Language reference
Web interface to MySql on csc450
Chapter 4 slides
- Advanced SQL
Blob writing example
Foreign Keys
Foreign Key example
Foreign Key constraints
The trouble with foreign keys
Stored Procedures
Stored Procedures in mySql.
one example
a second example
Embedded SQL
Embedded SQL (in C program) example
Same code after compilation
Embedded SQL Example using cursors
Dynamic SQL Example
SQLJ - Embedding SQL in Java programs
,
more on this
Java + MySql
DatabaseApp.java
JDBC driver
(unzip before using), as a jar
file
javabook package
(unzip before using)
jdbc primer
Chapter 6 slides
- Database design and E-R modeling
Chapter 7 slides
- Database design and normalization
Chapter 8 slides
- Application design
Using GET versus POST
JSP tutorial
Server side scripting in PHP
welcome.php
,working script is
here
login.php
databaseApp.php
connectDatabase.php
showMenu.php
processMenuItem.php
printCatalog.php
Triggers
Chapter 9 slides
- Object Based Databases
A typical Java description of a Vehicle
,
Typical application
Limitations of relational databases
An example of an Object Oriented Database Management System
Chapter 10 slides
- XML
XML support in MySql
An
XML
file, an
XSL
file,
combined effect
OFX: Open Financial Exchange
Bio-Sequence Markup Language
