Basics of Data Base Management System (B.Tech)

Science-based open elective on data models, SQL, relational design and database basics.

6 महीनेअवधि 5Chapters27टॉपिक

अभी पूछताछ करें

सिलेबस · पाठ्यक्रम

Download PDF

01Unit 1: Introduction and ER Model 6 टॉपिक

Database system vs file system
Data models, schema and instance
Three-schema architecture and data independence
DBA and database users
ER model: entities, attributes, relationships and keys
ER diagrams and their conversion to tables

02Unit 2: Relational Model and Relational Algebra 5 टॉपिक

Relations, tuples and attributes
Keys: super, candidate, primary and foreign
Integrity constraints
Relational algebra: select, project, union, difference, Cartesian product, join
Introduction to relational calculus

03Unit 3: SQL 6 टॉपिक

DDL commands: CREATE, ALTER, DROP
DML commands: INSERT, UPDATE, DELETE, SELECT
Constraints
Aggregate functions, GROUP BY and HAVING
Joins and subqueries
Views

04Unit 4: Functional Dependencies and Normalisation 5 टॉपिक

Functional dependencies and closure
Anomalies in un-normalised tables
First, second and third normal forms
Boyce-Codd normal form
Lossless decomposition

05Unit 5: Transactions and Concurrency Control 5 टॉपिक

Transaction concept and ACID properties
Schedules and serializability
Lock-based protocols and two-phase locking
Deadlock basics
Recovery: log-based recovery, COMMIT and ROLLBACK

परिचय

आप यह कर पाएँगे

Explain database concepts, architecture and data independence
Draw ER diagrams and convert them into relational tables with keys
Write relational algebra expressions and SQL queries including joins and aggregates
Normalise relations up to BCNF using functional dependencies
Explain transactions, ACID properties, concurrency control and recovery basics

यह किसके लिए है

B.Tech second-year students (Semester 4) of Electrical and Electronics & Communication Engineering taking this science-based open elective under AKTU
Non-CS students who want database and SQL basics for jobs and projects

आपको क्या चाहिए

Basic computer knowledge
Access to MySQL / SQLite / any SQL tool for practice (recommended)

सवाल

Which syllabus is followed?

The current AKTU (Dr. A.P.J. Abdul Kalam Technical University, Lucknow) B.Tech syllabus of Basics of Data Base Management System (Semester 4 open elective). If your university or college follows a different syllabus, the centre teaches from your own university syllabus.

Is SQL practised on a computer?

Yes. SQL queries are practised on MySQL or SQLite along with theory preparation.

Is it difficult for electrical / electronics students?

No. It starts from basic concepts with simple examples such as student and employee tables.