Database System and Concepts

The most awaited and "the" most important subject for a year to go by. All concepts are simple and straight forward. They need to be remembered and thought about to get an idea how they would actually work. The are basically the foundation of many softwares like a foundation for a building. The second part includes learning of Relational Algebra, a method to understand how queries can be built up and from there moving to SQL or Structured Query Language. It is not a programming language, but a query language, categorized under declarative languages. (Procedural is C). Commands might appear a bit different in logic than relational algebra but the idea remains the same. Constant practice of it is VERY ESSENTIAL.


Syllabus :


Introduction- Purpose of Database Systems, Views of data, Data Models, Database language, Transaction Management, Storage Management, Database Administrator, Database Users, Overall System Structure, Different types of Database Systems
E-R Model: Basic Concepts, Design Issues, Mapping Constraints, Keys, E-R Diagram, Weak Entity set, Extended E-R features, Design Of an E-R Database Schema, Reduction of an E-R schema to Tables
Relational Model: Structure of Relational Database, The Relational Algebra, The tuple relational calculus, The Domain Relational Calculus, Views
SQL- Background, Basic Structure, SET operations, Aggregate functions, Null Values, Nested Sub queries, Derived Relations, Views, Modification of Database, Joined Relations, DDL, Other SQL features
Transaction- Transaction Concepts, State, Implementations of Atomicity and durability, Concurrent Executions, Serializability, Recoverability, Transaction Definition in SQL.
Concurrency Control- Lock based protocol, Timestamp based protocol, Validation based protocol, Multiple Granularity, Multi version Schemes, Deadlock Handing, Insert and Delete operations, Concurrency in index structure Query Optimization
Relational Database Design- Pitfalls in Relational-Database Design, Decomposition, Normalization Using Functional Dependencies, and Normalization Using Multi valued Dependencies, Normalization Using Join Dependencies, Domain-Key Normal Form
and Alternative Approaches to Database Design
Other Relevant Advance Topics and Applications- Object Oriented Database, Decision-Support Systems, Data Analysis, Data Mining, Data Warehousing, Spatial and Geographic Databases, Multimedia Databases, Mobility and Personal Databases, Information-Retrieval Systems, Distributed Information Systems, The World Wide Web
ORACLE 8.0 Database: SQL, PL/SQL, Developer 2000(Oracle Forms and Reports)


Reference:
Database Management Systems, 4th edition by "Korth, Sudharshan, Silberschatz",
Fundamentals of Database Management Systems, 4th edition by "Elmasri, Navathe"


Books :

DBMS by Silberschatz−Korth−Sudarshan

 DBMS