csc4402_2011_sylla - Copy

csc4402_2011_sylla - Copy - manipulation, relational data...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
CSC4402 - Introduction to Database Systems Syllabus I. Course Outline and Objective: CSC4402 is an introductory course on database management systems. The course deals with the notion of database systems, from the user point of view. The objective o fthe course is to introduce the fundamental concepts of database systems, acquaint the students with the use of current relational database systems, and build a solid foundation for advanced studies in database area. II. The Organization of the Course: The course is divided into the following 6 parts: (1) Basic Concepts. Chapter 1. This part introduces basic terminology ,the notion of database systems, data indepen- dence, data abstraction, the advantage of database systems, data models (E-R model, the relational model, etc.), data storage and query processing, and database system architec- ture. (2). The Relational Data Model. Chapter 2 and Chapter 6.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: manipulation, relational data integrity, are discussed. We will cover relational algebra in this part. (3) The SQL language. Chapters 3, 4, and 5. (4) Database Design. Chapters 7 and 8, and my lecture notes on logical design of relational databases. We will discuss E-R modeling method for database design. The functional dependency based normalization approach to relational databases design is discussed in detail. This includes the notion of normal forms, the algorithms to perform decomposition to 3NF, to BCNF, etc. (5) Storage and Query Processing Chapters 11, 12, and 13. Indexing and hashing, query processing and query optimization. (6) Transaction Management Chapters 14 and 15, and if time permitting Chapter 16 as well. Transactions and concurrency control. The notion of transactions, ACID properties of transactions, concurrent schedules, serializability, locking protocols...
View Full Document

Ask a homework question - tutors are online