FREE
AKTU Database Management System (BCS501H) Syllabus PDF – B.Tech 3rd Year
Database Management System BCS501H
All syllabus, notes, question bank & PYQ for this subject
Free
Download now
- English
- Semester 5
- 0 downloads
- 0 views
Official AKTU syllabus of Database Management System (BCS501H) for B.Tech 3rd Year – 4 credits, L-T-P 3-1-0. Read the unit-wise course content, course outcomes, evaluation pattern and recommended books online, or download the PDF.
Syllabus — Database Management System
Download PDFBCS501H · 4 credits · L-T-P 3-1-0
Course Outcomes
At the end of course, the student will be able to:
| CO 1 | Apply knowledge of database for real life applications. | K 3 |
| CO 2 | Apply query processing techniques to automate the real time problems of databases. | K , K 3 4 |
| CO 3 | Identify and solve the redundancy problem in database tables using normalization. | K , K 2 3 |
| CO 4 | Understand the concepts of transactions, their processing so they will familiar with broad range of database management issues including data integrity, security and recovery. | K , K 2 4 |
| CO 5 | Design, develop and implement a small database project using database tools. | K , K 3 6 |
Course Content
L-T-P: 3-1-0
| Unit | Topic | Proposed Lecture |
|---|---|---|
| I | Introduction: Overview, Database System vs File System, Database System Concept and Architecture, Data Model Schema and Instances, Data Independence and Database Language and Interfaces, Data Definitions Language, DML, Overall Database Structure. 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, Relationship of Higher Degree. | 08 |
| II | Relational data Model and Language: Relational Data Model Concepts, Integrity Constraints, Entity Integrity, Referential Integrity, Keys Constraints, Domain Constraints, Relational Algebra, Relational Calculus, Tuple and Domain Calculus. Introduction on SQL: Characteristics of SQL, Advantage of SQL. SQl Data Type and Literals. Types of SQL Commands. SQL Operators and Their Procedure. Tables, Views and Indexes. Queries and Sub Queries. Aggregate Functions. Insert, Update and Delete Operations, Joins, Unions, Intersection, Minus, Cursors, Triggers, Procedures in SQL/PL SQL | 08 |
| III | Data Base Design & Normalization: Functional dependencies, normal forms, first, second, 8 third normal forms, BCNF, inclusion dependence, loss less join decompositions, normalization using FD, MVD, and JDs, alternative approaches to database design | 08 |
| IV | Transaction Processing Concept: Transaction System, Testing of Serializability, Serializability of Schedules, Conflict & View Serializable Schedule, Recoverability, Recovery from Transaction Failures, Log Based Recovery, Checkpoints, Deadlock Handling. Distributed Database: Distributed Data Storage, Concurrency Control, Directory System. | 08 |
| V | 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, Case Study of Oracle. | 08 |
Text Books
- Korth, Silbertz, Sudarshan,” Database Concepts”, McGraw Hill
- Date C J, “An Introduction to Database Systems”, Addision Wesley
- Elmasri, Navathe, “ Fundamentals of Database Systems”, Addision Wesley
- O’Neil, Databases, Elsevier Pub.
- RAMAKRISHNAN"Database Management Systems",McGraw Hill
- Leon & Leon,”Database Management Systems”, Vikas Publishing House
- Bipin C. Desai, “ An Introduction to Database Systems”, Gagotia Publications
- Majumdar & Bhattacharya, “Database Management System”, TMH
Ratings & Reviews
No reviews yet — share your experience with this item.