At the end of the course, learner will be able to
| Course Status : | Ongoing |
| Course Type : | Core |
| Duration : | 8 weeks |
| Start Date : | 21 Feb 2022 |
| End Date : | 18 Jun 2022 |
| Exam Date : | 25 Jun 2022 |
| Category : | |
| Level : | Undergraduate |
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
Dr.
Shaveta Bhatia has been awarded her Ph.D degree in Computer Applications. She
has completed her Master in Computer Applications (MCA) from Kurukshetra
University. She is having 18 years of academic and research experience. She is
a member of various professional bodies like ACM, IAENG and CSI. She has
participated in various National and International Conferences and actively involved
in various projects. There are more than 40 publications to her credit in
reputed National and International Journals and Conferences. She is also member
of Editorial board of various highly index journals. Her specialized domains
include Mobile Computing, Web Applications, Data Mining and Software
Engineering and guiding research scholars in these areas.
FOLLOW US