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.
| 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, 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.