CIS503

Syllabus

Introduction

Data Modeling using ER Diagrams

Enhanced Entity-Relationship Model

Relational Data Model and Relational Database Constraints

Relational Algebra and Relational Calculus

Relational Database Design by Mapping from Er and ERR diagrams

Functional Dependencies and Normalization

Relational Database Design Algorithms and Further Dependencies

Fall 2006 Exam 1

Fall 2006 Exam 1 Answers

Fall 2007 Exam 1

Fall 2007 Exam 1 Answers

Summer 2008 Exam 1

Summer 2008 Exam 1 Answers

mySQL Instructions

SQL

Oracle Express Instructions

companyschema.sql

companydata.sql

XML

xml1.zip

xml2.zip

First XML Assignment

xml3.zip

xml4.zip

Second XML Assignment

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/

newschema.sql

newdata.sql

Disk Storage

Fall 2006 Exam 2

Fall 2007 Exam 2

Fall 2007 Exam 2 Answers