CIS321

Syllabus

Lab Manual

Introduction

Introduction to Database Development

The Relational Data Model

Homework 1 Homework 1 Solutions

SQL

Database for class examples

petstore2002.mdb

Database for Homework

Homework 2 Homework 2 Solutions

Homework 3 Homework 3 Solutions

Entity-Relationship Diagrams

ER Assistant zip file

first class ER diagram second class ER diagram

Homework 4 Homework 4 Solutions

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

Developing Data Models

Converting ER Diagram to Relational Model

Homework 5 Homework 5 Solutions

Normalization

Homework 6 Homework 6 Solutions

Homework 6 - question 22

Physical Database Design

Class ER Diagrams

Homework 7

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

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

Exam 1 (Fall 2007)   Exam 1 Answers (Fall 2007)   fall07exam1.zip

Advanced SQL

Homework 8 Homework 8 Solutions

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

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

Exam 2 (Fall 2007)   Exam 2 Answers (Fall 2007)   Exam 2 database (Fall 2007)

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

xml1.zip

april 10 example

xml2.zip

april 15 example

Homework 9

xml3.zip

april 17 example

april 22 example

Homework 10

xml4.zip

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)

Exam 3 (Spring 2007)   Exam 3 Answers (Spring 2007)

spr08exam3.zip