Students will learn how to model databases, develop database schemas that enforce data integrity, create, alter, and manipulate tables, indexes, and views using relational algebra and SQL.
CSE3421 3.0 A
Introduction to Database Systems – Fall 2008
Course Outline
The purpose of this course is to introduce the fundamental concepts of database management, including aspects of data models, database languages, and database design. At the end of this course, a student will be able to understand and apply the fundamental concepts required for the use and design of database management systems.
Specific topics to be covered include:
1. Relational Model
2. Relational Algebra
3. The SQL Query Language
4. Conceptual Design, the ER Model, normalization
5. Transaction Management, Concurrency Control, and Recovery
This corresponds to the following chapters in the required textbook: 1, 2, 3, 4.1, 4.2, 5, 6, 16, 17, 18, 19 and lecture notes. The exact subsections covered will be made available prior to the midterm and final exams, so that you can better focus your studying.
Objectives
|
|
Students will learn how to model databases, develop database schemas that enforce data integrity, create, alter, and manipulate tables, indexes, and views using relational algebra and SQL. |
Miscellaneous support material
Textbook: On-line support materials based on the textbook by Raghu Ramakrishnan. Includes:
|
|
Lecture notes (Some of the lecture notes will be used in class.) |
|
|
Answers to the odd-numbered exercises in the book. |
Lab: Prism
You will need a Prism computer account to do assignment 2 and beyond.
Click here to find out how to create your account, if you do not have one already.
IBM: SQL, Getting Started (For reference only. May be useful for assignments)
IBM: SQL Reference (For reference only. May be useful for assignments)
IBM DB2 Universal Database (For reference only. May be useful for assignments)