CS 430-3
Database Systems
Catalog Description
The course concentrates on the relational model and includes several query languages. Topics covered include normalization, database design, catalogs, transaction support, concurrency control, integrity support, backup and recovery, and security. Projects involve the use of both personal and enterprise database systems.
Prerequisite:
220 with a grade of C or better; 330 with a grade of C or better recommended.
Objectives
1.To master the principles and the core technologies of modern DBMS (Database Management Systems).
2.After completion, students are expected to get a solid understanding on all the major aspects of a DBMS.
3.Students will be equipped with the necessary knowledge and skills for developing professional database applications.
Course Outline
| Lectures | ||
| 1. | Introduction and Review
Background, basic database concepts, examples. Relational model. Network and hierarchical models. |
3 |
| 2. | Microsoft Access Review
Creating tables, entering data, updates, queries, reports, forms. |
2 |
| 3. | Database Design Methodology
Goals, user views, methodology, examples, entity-relationship model. |
5 |
| 4. | SQL
Data definition (DLL), simple queries, functions, joins, nesting, grouping, updates, views, privileges, indexes, modifying table structure, catalog. |
5 |
| 5. | Relational Algebra
Conventional set operations, select, project, join, divide. |
4 |
| 6. | Relational Calculus
Tuple relational calculus and domain relational calculus |
4 |
| 7. | Oracle
Creating and filling tables, queries, SQL, reports, forms and SQL Plus. |
2 |
| 8. | Application development
Embedded database access and API-based approach (ODBC and JDBC) |
5 |
| 9. | Schema Refinement and Normalization
Functional dependence analysis, anomalies, 1st, 2nd, 3rd, and BCNF. |
5 |
| 10. | Components of a DBMS
Data storage and retrieval, catalog, transactions, concurrency control, recovery, security, communications, integrity. |
5 |
| 11. | Selected Additional Topics
XML data model and XQuery, etc. |
|
| Total | 40 | |