FREE
AKTU Basics of Data Base Management System (BOE067) Syllabus PDF – B.Tech 3rd Year
Basics of Data Base Management System BOE067
All syllabus, notes, question bank & PYQ for this subject
Free
Download now
- English
- Semester 6
- 0 downloads
- 0 views
Official AKTU syllabus of Basics of Data Base Management System (BOE067) for B.Tech 3rd Year – 3 credits, L-T-P 3-0-0. Read the unit-wise course content, course outcomes, evaluation pattern and recommended books online, or download the PDF.
Syllabus — Basics of Data Base Management System
Download PDFBOE067 · 3 credits · L-T-P 3-0-0
Course Outcomes
At the end of course , the student will be able to:
| CO 1 | Describe the features of a database system and its application and compare various types of data models. | K 2 |
| CO 2 | Construct an ER Model for a given problem and transform it into a relation database schema. | K , K 5 6 |
| CO 3 | Formulate solution to a query problem using SQL Commands, relational algebra, tuple calculus and domain calculus. | K , K 5 6 |
| CO 4 | Explain the need of normalization and normalize a given relation to the desired normal form. | K , K 2 3 |
| CO 5 | Explain different approaches of transaction processing and concurrency control. | K 2 |
Course Content
L-T-P: 3-0-0
| Unit | Topic | Proposed Lecture |
|---|---|---|
| I | Introduction: An overview of database management system, database system vs filesystem, 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, database users and administrator. 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. | 08 |
| II | 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 projection, set-theoretic operations, join operations. 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 | 08 |
| III | Structured Query Language (SQL): Basics of SQL, DDL, DML, DCL, advantage of SQL, SQL data type and literals, types of SQL commands, SQL operators and theirprocedure, tables – 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 | 08 |
Computer Science and Information Technology, IT (V & VI semester) PL/SQL Cursors, stored procedures, stored function, database triggers, indices
| IV | 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, deadlock handling. 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. | 08 |
| V | 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, Distributed Databases, Object-Oriented Database, Spatial & Temporal Databases, Decision Support 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 | 08 |
Text Books
- Elmasri, Navathe, “Fundamentals of Database System”, Addision Wesley.
- Korth, Silbertz, Sudarshan, “Database Concepts”, McGraw Hill.
- Bipin C. Desai, “An Introduction to Database System”, Galgotia Publication.
- Majumdar & Bhattacharya, “ Database Management System”, McGraw Hill.
- Date C.J., “An Introduction to Database System”, Addision Wesley.
- Ramakrishnan, Gehrke, “Database Management System”, Mc Graw Hill.
- Atul Kahate, “Introduction to Database Management Systems”, Pearson Education.
- Paul Beynon Davies, “Database System”, Palgrave Macmillan.
- Bharti P.K., “ An Introduction to Database Systems”, JPNP.
- Rajesh Narang, “Database Management System”, PHI.
- Singh, S.K., “Database System Concepts – design & application”, Pearson Education.
- Leon & Leon, “Database Management Systems”, Vikas Publishing House.
- O’Neil, “Databases”, Elsevier Pub.
- Ivan Bayross, “SQL, PL/SQL – The Programming Language of Oracle”, BPB Publications.
- P.S. Deshpande, “SQL and PL/SQL for Oracle 10g, Black Book”, Dreamtech Press.
- George Koch, Kevin Loney, “Oracle: The Complete Reference”, McGraw Hill.
- Coronel, Morris and Rob, “Database Principles: Fundamentals of Design, Implementation and Management”, Cengage Learning.
- Gillenson, Paulraj Ponniah, “Introduction to Database Management”, Wiley.
- G. K. Gupta, “Database Management Systems”, McGraw Hill.
- Shraman Shah, “Oracle for Professional”, SPD. Computer Science and Information Technology, IT (V & VI semester)
Ratings & Reviews
No reviews yet — share your experience with this item.