Welcome to DBS610 - Introduction to Database Systems

NOTE: This website is a work in progress and will be updated periodically to correct mistakes, add additional material and practice exercises.  Please do not hesitate to email the author if you find any mistakes that need to be corrected.  Please include the URL of the page where changes need to occur.

Weekly Outline

Week Major Topics

PREFACE and Preparation for the Course (Installation of required software)
1 Introduction
Databases, Database Systems, Data Anomalies, Development Life Cycle,
SQL Developer (Installation and Getting Started)
2 Relational Model
Relational Databases, Relationships, Referential Integrity, Table Types, Various Keys
3 Data Modelling and Entity Relationship Diagrams
Data Modelling, ERDs ( Entity Relationship Diagrams ), Cardinalities or Optionalities, ERD Formatting and Symbology
4 Normalization 1
DBDL, UNF and 1NF, Repeating Groups, Multi-Value Dependencies, Atomic Fields
5 Normalization 2
2NF and 3NF, Partial Dependencies, Transitive Dependencies
6 Normalization 3
Case Study
7 Review and Midterm
Review for midterm and midterm test
Study Week
8 SQL (Structured Query Language)
Single Table Queries, DML ( SELECT, source FROM, filtering WHERE, Sorting ORDER BY, Aliases, Wildcards, CRUD (INSERT, UPDATE, & DELETE) as well as fundamental concepts of case sensitivity, date formats, and internationalization.
9 More SQL
Multiple Table Queries, DML( ANSI-89 Joins, ANSI-92 Joins, Views )
10 DDL
Data Types, Constraints, SQL - DDL ( CREATE, CREATE OR REPLACE, ALTER )
11 Transactions
Transactions, Concurrency, Basic Database Security ( GRANT and REVOKE )
12 Database Applications
Application Architecture Development, Roll of Database, Design Methodologies, Database Access and Connections
13 Review and Project Submission
Final project submission and review of topics for final test.
14 Final Test
The final assessment for the course

Code Examples and Resources

Code Examples

Code examples, where they are appropriate, are provided within each weeks content. Your professor may choose to do other code examples with you as well in addition to those here.