At the end of the course, learner will be able to
| Course Status : | Upcoming |
| Course Type : | Core |
| Duration : | |
| Start Date : | |
| End Date : | |
| Exam Date : | |
| Category : | |
| Level : | None |
PART A
UNIT
1: Introduction to Database
1.1 Database :Definition
1.2 Characteristics of database approach
1.3 Components of a DBMS
1.4 Advantages and disadvantages of a DBMS
1.5 Applications of DBMS
1.6 Database system Vs file system
1.7 Three level architecture of a DBMS
1.8 DBMS architecture
UNIT 2: Data Modeling using Entity Relationship Model
2.1 Data Independence: physical
independence; logical independence
2.2 Data Dictionary
2.3 Role of DBA
2.4 Data Models:Hierarchal,
Network, Relational Data Models
2.5Introduction: Entities; Entity
types; Entity set;Attributes
2.6E-R Diagram; Case Studies to
represent E-R Diagram
UNIT
3: Domains, Keys and SQL
3.1 Concept of Keys: Primary Key;
Candidate Key; Composite Key; Alternate Key; Secondary Key; Foreign Key
3.2 Constraints: Relational
Constraints, Domain Constraints, Key Constraints, Integrity Constraints
3.3 Relational Algebra: set
operations; basic operations
3.4Rrelational calculus
3.5Introduction to SQL:History of
SQL; Basic Structure
3.6DDL Commands, DML Commands
3.7 SQL functions: Character
functions, Aggregate Functions, Date functions
PART B
UNIT
4: Normalization
4.1 Anomalies in databases and its
solution
4.2 Functional dependencies: Full,
Partial, Transitive, Multi-valued
4.3 Introduction to normalization
4.4 Advantages of Normalization
4.5Normal Forms: 1NF, 2NF, 3NF,
BCNF for Relational Databases
4.6 Case study to implement
normalization on data
UNIT 5: Concurrency Control
5.1 Transaction Management:
Introduction; Transaction properties; Transaction states
5.2 Introduction to Concurrency
Control
5.3 Problems of concurrent
transaction
5.4Locks: Introduction; types of
locks
5.5 Algorithms of concurrency
control
UNIT
6: Advanced Concepts in Databases
6.1 Data base Security:
Introduction; security risks
6.2 Techniques to implement data
base security
6.3 Data base Recovery:
Introduction; causes of failure
6.4 Recovery Methods: log based recovery;
checkpoints; shadow paging
6.5Introduction to Distributed
Databases
1. R.Elmasri, S.B. Navathe, 2016,
Fundamentals of Database Systems , Pearson Education/Addison Wesley
2.
Parteek Bhatia, Gurvinder Singh, 2016, Simplified approach to DBMS,
Kalyani Publishers
3. Thomas Cannolly and Carolyn
Begg, 2014, Database Systems: A Practical Approach to Design, Implementation
and Management, Pearson Education
4. Henry F Korth, Abraham
Silberschatz, 2011, Database System Concepts
,McGraw Hill
FOLLOW US