3BCA3 -Database
Management Systems
DBMS CONCEPTS AND ARCHITECTURE
- Operational data
- Data Information and Knowledge
- Purpose of database system
- Data abstraction
- Data Independence
- Data Models: Relational, Networm, Hierarchical
- Instances & Schemes
- Types of Database languages
- DAta Definition Language (DDl)
- Data Manipulation Language (DML)
- Database Manager
- Database Users
- Database Administrator
- Overall System Structure
- Data Dictionary
DATABASE DESIGN
- 3-level Architecture: Conceptual Level, Logical Level,
Physical Level
- Entity Relationship Model as a tool of conceptual design:
Entities & Entity Set, Relationship &
Relationship Set, Attributes, Mapping Constraints, Keys
- Entity-Relationship Diagram (E-R) Diagram to tables.
RELATIONAL TATA MODEL
- Set theory Concepts and fundamentals: Relations, Domain
Attributes, Tuple
- Conecpt of Keys: Candidate Key , Primary Key, Alternate
Key, Super Key, Foreign Key
- Fundamental Integrity Rules: Entity Integrity,
Referential Integrity, Extension & Intension
- Relational Algbra : Select, Project, Cross Product,
Different, types of Joins i.e. theta join, equi, join
natural join, outer join, Set operation
- Standart Query Language (SQL)
- Codd's rules.
RELATIONAL TATABASE DESIGN
- Functional Dependencies, Good &Bad Decomposition
- Anomalies in a database : A consequences of bad design,
Universal Relation
- Normalisation : First, Second, Third & BCNF Normal
Forms
- Multivalues Dependency, Join Dependency & Forth and
Fifth Normal Form
INDEXING & HASHING
- Basic Concepts,
- Indexing:B+tree Index Files, B-tree Index Files
- Hashing : Static Hash Function, Dynamic Hash Functions
- Index Definition in SQL : Multiple Key Access
CRASH RECOVERY
- Failure Classification
- The Storage Hierarchy
- Transaction Model
- Log Based Recovery
- Buffer Management
- Shadwo Paging
TEXT & REFERENCE BOOKS:
- Database System Concepts by Henery F. Korth & Abraham
Silberschatz
- An Introduction to Database System by Bipin C.Desai
- An Introduction jto Database System by C.J.Date