B.Tech Civil Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Civil Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Mechanical Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Mechanical Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Computer Science & Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Computer Science & Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Information Technology · Sem 3 (Open Elective, code BOE307) · B.Tech Information Technology · Sem 4 (Open Elective, code BOE407) · B.Tech Artificial Intelligence & Machine Learning · Sem 3 (Open Elective, code BOE307) · B.Tech Artificial Intelligence & Machine Learning · Sem 4 (Open Elective, code BOE407) · B.Tech Artificial Intelligence & Data Science · Sem 3 (Open Elective, code BOE307) · B.Tech Artificial Intelligence & Data Science · Sem 4 (Open Elective, code BOE407) · B.Tech CSE (Artificial Intelligence) · Sem 3 (Open Elective, code BOE307) · B.Tech CSE (Artificial Intelligence) · Sem 4 (Open Elective, code BOE407) · B.Tech CSE (AI & ML) · Sem 3 (Open Elective, code BOE307) · B.Tech CSE (AI & ML) · Sem 4 (Open Elective, code BOE407) · B.Tech CSE (Data Science) · Sem 3 (Open Elective, code BOE307) · B.Tech CSE (Data Science) · Sem 4 (Open Elective, code BOE407) · B.Tech CSE (Cyber Security) · Sem 3 (Open Elective, code BOE307) · B.Tech CSE (Cyber Security) · Sem 4 (Open Elective, code BOE407) · B.Tech CSE (Internet of Things) · Sem 3 (Open Elective, code BOE307) · B.Tech CSE (Internet of Things) · Sem 4 (Open Elective, code BOE407) · B.Tech Computer Science & Design · Sem 3 (Open Elective, code BOE307) · B.Tech Computer Science & Design · Sem 4 (Open Elective, code BOE407) · B.Tech Computer Science (Hindi) · Sem 3 (Open Elective, code BOE307) · B.Tech Computer Science (Hindi) · Sem 4 (Open Elective, code BOE407) · B.Tech Computer Science & Business Systems · Sem 3 (Open Elective, code BOE307) · B.Tech Computer Science & Business Systems · Sem 4 (Open Elective, code BOE407) · B.Tech Cyber Security · Sem 3 (Open Elective, code BOE307) · B.Tech Cyber Security · Sem 4 (Open Elective, code BOE407) · B.Tech Data Science · Sem 3 (Open Elective, code BOE307) · B.Tech Data Science · Sem 4 (Open Elective, code BOE407) · B.Tech Electrical Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Electrical Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Electrical & Electronics Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Electrical & Electronics Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Electrical & Computer Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Electrical & Computer Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Electronics & Communication Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Electronics & Communication Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Electronics & Instrumentation / Instrumentation & Control · Sem 3 (Open Elective, code BOE307) · B.Tech Electronics & Instrumentation / Instrumentation & Control · Sem 4 (Open Elective, code BOE407) · B.Tech Electronics & Computer Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Electronics & Computer Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech ECE (Advanced Communication Technology) · Sem 3 (Open Elective, code BOE307) · B.Tech ECE (Advanced Communication Technology) · Sem 4 (Open Elective, code BOE407) · B.Tech Electronics Engineering (VLSI Design & Technology) · Sem 3 (Open Elective, code BOE307) · B.Tech Electronics Engineering (VLSI Design & Technology) · Sem 4 (Open Elective, code BOE407) · B.Tech Automobile Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Automobile Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Aeronautical Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Aeronautical Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Mechanical & Industrial Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Mechanical & Industrial Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Production & Industrial Production Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Production & Industrial Production Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Manufacturing Technology · Sem 3 (Open Elective, code BOE307) · B.Tech Manufacturing Technology · Sem 4 (Open Elective, code BOE407) · B.Tech Mining Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Mining Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Chemical Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Chemical Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Plastic Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Plastic Engineering · Sem 4 (Open Elective, code BOE407) · B.Tech Food Technology · Sem 3 (Open Elective, code BOE307) · B.Tech Food Technology · Sem 4 (Open Elective, code BOE407) · B.Tech Textile Technology · Sem 3 (Open Elective, code BOE307) · B.Tech Textile Technology · Sem 4 (Open Elective, code BOE407) · B.Tech Handloom & Textile Technology · Sem 3 (Open Elective, code BOE307) · B.Tech Handloom & Textile Technology · Sem 4 (Open Elective, code BOE407) · B.Tech Carpet & Textile Technology · Sem 3 (Open Elective, code BOE307) · B.Tech Carpet & Textile Technology · Sem 4 (Open Elective, code BOE407) · B.Tech Biotechnology · Sem 3 (Open Elective, code BOE307) · B.Tech Biotechnology · Sem 4 (Open Elective, code BOE407) · B.Tech Bioinformatics · Sem 3 (Open Elective, code BOE307) · B.Tech Bioinformatics · Sem 4 (Open Elective, code BOE407) · B.Tech Agricultural Engineering · Sem 3 (Open Elective, code BOE307) · B.Tech Agricultural Engineering · Sem 4 (Open Elective, code BOE407)
Database System vs File System, Database System Concept and Architecture, Data Model Schema and Instances, Data Independence and its Types, Overall Database Structure. Entity Relationship Model: ER Model Concepts, Notation for ER Diagram, Mapping Constraints, Key attribute, Generalization, Aggregation, Reduction of an ER Diagrams to Tables.
Relational Data Model Concepts, type of keys, Integrity Constraints Entity integrity and referential integrity, Keys Constraints, Domain Constraints, Relational Algebra-Unary Relational Operations- SELECT and PROJECT, Binary Relational Operations- CROSS, JOIN and DIVISION, Queries in Relational Algebra.
Introduction to SQL, Characteristics of SQL, SQL Data Types, Basic Queries in SQL- create, select Insert, Delete and Update Statements, concepts of group by and having, order by, Sub Queries, Aggregate Functions, Joins, Unions, Intersection, Minus, Views.
Functional Dependencies, Inference rules, Closure of attributes, FD equivalence and Minimal cover. Normalization: Normal forms, first, second, third normal forms, and BCNF. Lossless join decompositions, Dependency Preservation, Multi-valued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form.
Transaction and its States, ACID property, Transaction Scheduling, Serializability of scheduling, Conflict, and View Serializability Concurrency Control Techniques: Concurrency Control, Locking Techniques for Concurrency Control, Two-phase locking techniques for concurrency control, Time Stamping Protocols for Concurrency Control
After completion of the course student will be able to:
This subject is on page 10 of the original AKTU PDF.
