Syllabus

Introduction

Introduction to Database Development

Data.zip for the Adamski book

Lab 1

The Relational Data Model

Redbox (version 1)

Redbox (version 2)

Homework 1

Homework 1 Solution

Lab 2

SQL

Database for class examples

Database for class examples after Feb 2

Database for class examples after Feb 4

Database for class examples after Feb 6

Database for class examples after Feb 9

Database for class examples after Feb 11

petstore.mdb

Homework 2

petstore.mdb (after hw2)

Homework 2 Solution

Lab 3

Entity-Relationship Diagrams

ER Assistant zip file

ER Diagram (after Feb 16)

Homework 3

Homework 3 answers

Exam 1 (Spring 2009)   Exam 1 Answers (Spring 2009)

Exam 1 (Fall 2008)   Exam 1 Answers (Fall 2008)

Exam 1 (Spring 2008)   Exam 1 Answers (Spring 2008)   Database for exam 1, spring 2008   Database for exam 1, spring 2008 (with answers)

Lab 4

Lab 5

Developing Data Models

ER Diagram (first March 2)

ER Diagram (second March 2)

ER Diagram (March 16)

Homework 4

Homework 4 Solution

Lab 6

Converting ER Diagram to Relational Model

Conversion Algorithm between ER Diagram and Tables

table from ER Diagram (first March 2) table from ER Diagram (second March 2)

table from ER Diagram (March 16 example)

Homework 5

Normalization

March 25 notes

March 27 notes

Homework 6

Homework 6 answers

Lab 7

Advanced SQL

Database for class examples after March 30

Homework 7

Homework 7 Answers

Lab 8

Exam 2 (Spring 2008)   Exam 2 Answers(Spring 2008)   q2 answer   q4 answer   q5 answer   q6 answer

Exam 2 (Fall 2008)   Exam 2 answers(Fall 2008)

Exam 2 (Spring 2009)   Exam 2 Answers(Spring 2009)

Lab 9

Introduction to XML

xml1.zip (Basics and DTD Validation)

apr2.zip (April 2 examples)

Homework 8

apr20.xml (Schema Validation)

apr20.xsd (Schema Validation)

xml2.zip (Schema Validation)

Homework 9

xml3.zip (XSLT)

apr24xml3.zip (XSLT)

Homework 10

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 (Spring 2008)    spr08exam3.zip

Exam 3 (Fall 2008)    exam3.zip fall08exam3answers.zip Exam 3 (Fall 08) answers

exam3package.zip Exam 3 Files (Spring 09)

exam3packagev2.zip Exam 3 Files (Spring 09)