GTU Study
KHUDKIBOOK
RELATIONAL DATABASE MANAGEMENT
FREE PDF
DI03000031
Code: DI03000031
Credits: 4
Semester 3
Chem. Green
Relational Database Management System
Get the full GTU study material, English & Gujarati textbook PDFs, syllabus curriculum, and solved previous year question papers.
×
English Book & Chapters
English Book Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for Updates
×
GTU Previous Year Papers
Papers Coming Soon
We are working hard to add this material. Stay tuned for updates!
Follow on Instagram for UpdatesRelational Database Management System Syllabus — Unit-wise Content
The official GTU curriculum for Relational Database Management System (subject code DI03000031) as prescribed for Chem. Green · Semester 3 divides the course into 5 units, covering 44 listed topics. The unit-wise breakdown below is read from the GTU syllabus document for this subject code, so you can check what the course actually covers before deciding which papers to attempt.
Download the official syllabus PDF (DI03000031)Unit 1 Introduction to Database System and SQL commands
- Concepts and Definitions Data and Information: Definition
- differences between data and information Data Elements: Data items (fields)
- files, and metadata Data Dictionary: Definition
- components, and significance Database Concepts: Definition
- characteristics, and importance of databases Database Systems and Environment: Components
- architecture, and functions Schemas and Instances: Concepts of schemas
- sub- schemas, and instances in a database system Data Types Overview of SQL data types: Numeric
- Date/Time SQL Commands: DDL (Data Definition Language): Create Database
- Create Table
- Alter Table
- Drop Table
- Truncate Table Program Name: Diploma Engineering Level: Diploma Branch: Computer Engineering / Computer Science & Engineering / Cyber System & Information Security Subject Code : DI03000031 Subject Name : Relational Database Management System DML (Data Manipulation Language): Insert
- Delete DQL (Data Query Language): SELECT statement with WHERE clause
- SELECT DISTINCT statement DCL (Data Control Language): Creating Users & Roles
- REVOKE commands TCL (Transaction Control Language): Introduction to Transactions
- ACID properties
- Savepoint Problem Solving practice on the above concepts
Unit 2 SQL In-Built Functions and Joins Operators
- Logical Special Operators: IN, ANY, ALL, BETWEEN
- LIKE Use of System table/DUAL table SQL Functions: Single Row Functions: Numeric Functions: ABS, POWER, MOD, ROUND
- SQRT Character Functions: INITCAP
- INSTR Date Functions: ADD_MONTHS
- TRUNC Conversion Functions: TO_CHAR
- TO_NUMBER Aggregate Functions: SUM, AVG, COUNT, MAX, MIN SQL Clauses: GROUP BY, HAVING, and ORDER BY Joins: INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- Program Name: Diploma Engineering Level: Diploma Branch: Computer Engineering / Computer Science & Engineering / Cyber System & Information Security Subject Code : DI03000031 Subject Name : Relational Database Management System CROSS JOIN
- SELF JOIN Subquery: Nested Queries
- Correlated Subqueries Set Operators: MINUS
- UNION ALL Problem Solving practice on the above concepts
Unit 3 Normalization
- Basics of Normalization Definition and Importance Normal Forms First Normal Form (1NF) Second Normal Form (2NF) Third Normal Form (3NF) Advantages and disadvantages of Normalization Problem Solving practice on the above concepts
Unit 4 Database Integrity Constraints & Objects
- Integrity Constraints Domain Integrity Constraints: NOT NULL
- CHECK Entity Integrity Constraints: UNIQUE
- PRIMARY KEY Referential Integrity Constraints: FOREIGN KEY, REFERENCES
- ON DELETE CASCADE Database Objects Views: CREATE VIEW
- ALTER VIEW
- DROP VIEW Synonyms: CREATE SYNONYM
- DROP SYNONYM Sequences: CREATE SEQUENCE
- ALTER SEQUENCE
- DROP SEQUENCE Indexes: CREATE INDEX (UNIQUE
- DROP INDEX Problem Solving practice on the above concepts
Unit 5 PL/SQL and Triggers
- Fundamentals of PL/SQL Basics of PL/SQL Data Types: %TYPE and %ROWTYPE Program Name: Diploma Engineering Level: Diploma Branch: Computer Engineering / Computer Science & Engineering / Cyber System & Information Security Subject Code : DI03000031 Subject Name : Relational Database Management System Advantages of PL/SQL over SQL Control Structures Conditional
- Iterative, and Sequential Statements Cursors Static Cursors: Implicit & Explicit Procedures and Functions Creating and Executing Stored Procedures and Functions Triggers Fundamentals of Triggers Types of Triggers: BEFORE
- FOR EACH ROW, FOR EACH STATEMENT Problem Solving practice on the above concepts
Study on Android App:
