CIS321

exam3.zip

Syllabus

Lab Manual

Introduction

Introduction to Database Development

Red Box Data Requirements

The Relational Data Model

Homework 1

SQL

Database for class examples

petstore2002.mdb

Database for Homework

Homework 2 Homework 2 Solutions

page 192-3 page 194-5

Homework 3 Homework 3 Solutions

page 195-6 page 197-8

Entity-Relationship Diagrams

ER Assistant zip file

oct5.erd

oct7.erd

Homework 4 Homework 4 solution

page 249-250 page 251-252 page 253-254

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)

Developing Data Models

oct10.erd

oct15.erd

Homework 5 Homework 5 Solutions

page 305-306 page 307-308 page 309-310 page 311-312 page 313-314

page 315-316 page 317-318 page 319-320 page 321-322 page 323-324

page 325-326 page 327-328 page 329-330 page 331-332 page 333-334

Converting ER Diagram to Relational Model

Homework 6 Homework 6 solution

Normalization

Physical Database Design

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 7 Homework 7 Solutions

revised petstore2002.mdb with advanced queries page 517-518 page 519-520

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

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

xml1.zip

Homework 8

xml2.zip

petstore.zip

xml3.zip

Homework 9

xml4.zip

xml4.zip after December 5 class

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 (Fall 2006)   Exam 3 Answers (Fall 2006)

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

Exam 3 (Spring 2008)    spr08exam3.zip