Scribd
Upload
992 views

DBMS - 3rd Year VI Semester - AICTE 2020-21 - 9 March 2021

This document outlines the course outcomes, syllabus, and textbooks for a database management systems course. The 5 course outcomes cover describing database features, constructing ER models, formulating SQL queries, explaining normalization, and transaction processing. The syllabus is divided into 5 units that will teach database concepts, ER modeling, relational databases, design and normalization, SQL, PL/SQL, transactions, concurrency control, and security. The course recommends 20 textbooks for reference.

Uploaded by

RAtna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
992 views

DBMS - 3rd Year VI Semester - AICTE 2020-21 - 9 March 2021

This document outlines the course outcomes, syllabus, and textbooks for a database management systems course. The 5 course outcomes cover describing database features, constructing ER models, formulating SQL queries, explaining normalization, and transaction processing. The syllabus is divided into 5 units that will teach database concepts, ER modeling, relational databases, design and normalization, SQL, PL/SQL, transactions, concurrency control, and security. The course recommends 20 textbooks for reference.

Uploaded by

RAtna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

KOE-067 BASICS OF DATA BASE MANAGEMENT SYSTEM

Course Outcome ( CO) Bloom’s Knowledge Level (KL)

At the end of course , the student will be able to:


Describe the features of a database system and its application and compare various
CO 1 K2
types of data models.
Construct an ER Model for a given problem and transform it into a relation
CO 2 K 5 , K6
database schema.
Formulate solution to a query problem using SQL Commands, relational algebra,
K 5 , K6
CO 3 tuple calculus and domain calculus.
CO 4 Explain the need of normalization and normalize a given relation to the desired K 2 , K3
normal form.
CO 5 Explain different approaches of transaction processing and concurrency control. K2

DETAILED SYLLABUS 3-0-0


Unit Lecture

Introduction: An overview of database management system, database system vs file system,


database system concepts and architecture, views of data – levels of abstraction, data models,
schema and instances, data independence, database languages and interfaces, data definition
languages, DML, overall database structure, transaction management, storage management,
I database users and administrator. 08
Data Modeling using the Entity Relationship Model: ER model concepts, notation for ER
diagram, mapping constraints, keys, concepts of super key, candidate key, primary key,
generalization, aggregation, reduction of an ER diagrams to tables, extended ER model,
relationships of higher degree.
Relational Database Concepts: Introduction to relational database, relational database structure,
relational model terminology – domains, attributes, tuples, relations & relational database schema,
integrity constraints, entity integrity, referential integrity, keys constraints, domain constraints,
Relational algebra - relational calculus, tuple and domain calculus, basic operations – selection and
II projection, set-theoretic operations, join operations. 08
Data Base Design & Normalization: Functional dependencies, normal forms, first, second, &
third normal forms, BCNF, inclusion dependence, loss less join decompositions, normalization
using FD, MVD, and JDs, alternative approaches to database design
Structured Query Language (SQL): Basics of SQL, DDL, DML, DCL, advantage of SQL, SQL
III data type and literals, types of SQL commands, SQL operators and their procedure, tables – 08
creation & alteration, defining constraints, views and indexes, queries and sub queries,
aggregate functions, built-in functions, insert, update and delete operations, joins, unions,
intersection, minus, transaction control commands.
PL/SQL: Introduction, features, syntax and constructs, SQL within Pl/SL, DML in PL/SQL
Cursors, stored procedures, stored function, database triggers, indices
Transaction Processing Concepts: Transaction concepts, properties of transaction, testing of
serializability, Serializability of schedules, conflict & view serializable schedule, recoverability,
recovery from transaction failures, two-phase commit protocol, log based recovery, checkpoints,
IV deadlock handling. 08
Concurrency Control Techniques: Concurrency control, locking techniques for concurrency
control, time stamping protocols for concurrency control, validation based protocol, multiple
granularity, multi-version schemes, recovery with concurrent transaction.

Open Elective I AICTE Model Curriculum K series (VI Semester) Syllabus 2020-21 Page 12
Database Security – Types of security, system failure, backup & recovery techniques,
authorization & authentication, system policies, levels of security – physical, OS, network &
DBMS, privileges – grant & revoke.
Recent Trends in Database Management Systems: Centralized and Client-Server Architectures,
V Distributed Databases, Object-Oriented Database, Spatial & Temporal Databases, Decision Support 08
Systems, Data Analysis, Data Mining & Warehousing, Data Visualization, Mobile Databases,
OODB & XML Databases, Multimedia & Web Databases, Spatial and Geographical Databases,
Web and Mobile Databases, Active Databases

Text books:

1. Elmasri, Navathe, “Fundamentals of Database System”, Addision Wesley.


2. Korth, Silbertz, Sudarshan, “Database Concepts”, Mc Graw Hill.
3. Bipin C. Desai, “An Introduction to Database System”, Galgotia Publication.
4. Majumdar & Bhattacharya, “Database Management System”, McGraw Hill.
5. Date C.J., “An Introduction to Database System”, Addision Wesley.
6. Ramakrishnan, Gehrke, “Database Management System”, McGraw Hill.
7. Atul Kahate, “Introduction to Database Management Systems”, Pearson Education.
8. Paul Beynon Davies, “Database System”, Palgrave Macmillan.
9. Bharti P.K., “ An Introduction to Database Systems”, JPNP.
10. Rajesh Narang, “Database Management System”, PHI.
11. Singh, S.K., “Database System Concepts – design & application”, Pearson Education.
12. Leon & Leon, “Database Management Systems”, Vikas Publishing House.
13. O’Neil, “Databases”, Elsevier Pub.
14. Ivan Bayross, “SQL, PL/SQL – The Programming Language of Oracle”, BPB Publications.
15. P.S. Deshpande, “SQL and PL/SQL for Oracle 10g, Black Book”, Dreamtech Press.
16. George Koch, Kevin Loney, “Oracle: The Complete Reference”, McGraw Hill.
17. Coronel, Morris and Rob, “Database Principles: Fundamentals of Design, Implementation
and Management”, Cengage Learning.
18. Gillenson, Paulraj Ponniah, “Introduction to Database Management”, Wiley.
19. G. K. Gupta, “Database Management Systems”, McGraw Hill.
20. Shraman Shah, “Oracle for Professional”, SPD.

Open Elective I AICTE Model Curriculum K series (VI Semester) Syllabus 2020-21 Page 13

You might also like