Syllabus

Lab Manual

Introduction

Introduction to Database Development

Entity-Relationship Diagrams

ER Assistant zip file

Developing Data Models

Chapter 6 answers

Project (part 1)

The Relational Data Model

Converting ER Diagram to Relational Model

Normalization

Exam 1 (Fall 2006)   Exam 1 Answers (Fall 2006)

Exam 1 (Spring 2007)   Exam 1 Answers (Spring 2007)

Project part 2 and 3

SQL

Database for class examples

Database for Homework

Chapter 4 answers

Project part 4

Project part 5

Advanced SQL

Exam 2 database with April 10 examples

Exam 2 (Fall 2006)   Exam 2 Answers (Fall 2006)

Exam 2 (Spring 2007)   Exam 2 Answers (Spring 2007)   Exam 2 database (Spring 2007)

Application Development with Views

Project part 6

xml1.zip

xml2.zip

xml3.zip

apr24.zip

xml4.zip

may1.zip

Project part 7

Project part 8

XML Tutorials: http://www.xmlfiles.com/xml/ http://www.w3schools.com/xml/default.asp

XML DTD Tutorials: http://www.xmlfiles.com/dtd/ http://www.w3schools.com/dtd/

XML Schema Tutorial: http://www.w3schools.com/schema/default.asp

XSLT Tutorial: http://www.w3schools.com/xsl/

Exam 3 (Fall 2006)   Exam 3 Answers (Fall 2006)