CIS503

Syllabus

Introduction

Data Modeling using ER Diagrams

Enhanced Entity-Relationship Model

Relational Data Model and Relational Database Constraints

Relational Algebra and Relational Calculus

Chapter 6 answers

Relational Database Design by Mapping from Er and ERR diagrams

Chapter 7 answers

Functional Dependencies and Normalization

Chapter 10 answers

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

SQL

mySQL Instructions

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/

Disk Storage

Fall 2006 Exam 2