ITSW 1407 - Introduction to Database

   Data Modeling

     Overview
     E-R Model
     Database Design
     Data Objects
     Basic Schema
     Refining the E-R
     Primary Keys
     Attributes
     Hierarchies
     Integrity Rules
     Bibliography

   Relational Model

     Overview
     Data Structure
     Notation
     Relational Table
     Relationships
     Data Integrity
     Relational Data
     Normalization
     Advanced


  Welcome

CSIT Department,  Del Mar College
Prof. Michael P. Harris, CCNA, CCAI

ITSW 1407. INTRODUCTION TO DATABASE (3-3-4) 11.0802

Introduction to database theory and the practical applications of a database. Topics include database terminology and concepts, methods and techniques to plan, design and generate a database and database tables, perform a query and produce a report.  Prerequisite: ITSC 1309.


  Syllabus


  Introduction


These webPages are an informal introduction to Data Modeling using the Entity-Relationship (ER) approach.  It is intended for someone who is familiar with relational databases but who has no experience in Data Modeling.

The basic techniques described are applicable to the development of microcomputer based relational database applications as well as those who use relational database servers such as MS SQL Server or Oracle.

This information is a practical guide to Data Modeling, not an academic paper on either Relational Database design or Data Modeling.  Students interested in a rigorous treatment of these topics should consult the bibliography.