Skip to content
Padhora
Sign in
BrowsePlans

4G curriculum (older)

For students clearing pending subjects of the 4G scheme (7-digit subject codes, e.g. 4341602). Students admitted under the current scheme study the 5G curriculum.

1333204 · Semester 3 · 4G scheme

Database Management System

Notes and solutions following the Gujarat Technological University (GTU) syllabus for 1333204. Independent material — not issued by the university.

Information & Communication Technology

Materials

Syllabus

The official syllabus this material follows.

  • Syllabus

    9 pages

    FreeRead

Complete Book

The whole syllabus, unit by unit, written for the exam.

Problem Solver

Step-by-step solutions to typical problems.

PYQ Solutions

Past university papers, fully solved.

  • Solved past papers — detailed answers

    226 pages · English + ગુજરાતી

    Premium Preview · 29 pages

  • Solved past papers — short answers

    111 pages · English + ગુજરાતી

    Premium Preview · 4 pages

Syllabus units

Unit 1: Unit 1
  • Introduction
  • Purpose of Database System
  • File oriented System versus database system
  • Application of DBMS
  • Database Administrator
  • Schema, Sub-Schema, Instances
  • Data Abstraction
  • Data Independence
  • Database Architecture
Unit 2: Unit 2
  • Basic concepts of E-R
  • Mapping Cardinality
  • Key
  • ER Diagrams
  • Weak Entity Sets
  • Enhanced ER Model
  • Converting ER Diagrams to database
Unit 3: Unit 3
  • SQL Data types
  • Data Definition Language Commands: create, alter, truncate, drop
  • Data Manipulation Language Commands: insert, select, update, delete
  • Privilege command: grant, revoke
  • SQL views
  • Single row function
  • Date functions
  • Numeric &Character function
  • Conversion function
  • Miscellaneous function
  • Group function
  • Operators
  • Arithmetic
  • Comparison
  • Logical Group by
  • Having and order by clause
  • Set operators: Union, union all, intersect, minus
  • Joins: simple join, equi join, non equi join, self-join, outer join
  • Need of Constraints
  • Domain Integrity constraints: Not null, Check
  • Entity Integrity constraints
  • Referential integrity Constraints
Unit 4: Unit 4
  • Importance of Normalization
  • Functional Dependencies
  • Normal Forms
Unit 5: Unit 5
  • Transaction concepts, properties of transactions.
  • Serializability of transactions

About this course

The aim of this course is to get understanding of the basic concepts of database management system used for business, scientific and engineering application which stored centralized. The students will develop the skills to design and develop database using different database models manage & retrieve data from different perspective using Structured Query Language (SQL) in ORACLE (centralized storage) so there is no need of storing data in files and paper. This helps students to design ER-models to represent simple databases and convert them into relational tables, populate relational databases and formulate SQL queries on data. Students will improve database design through normalization. Students will understand how database systems must provide for the safety of the stored information, despite system crashes or attempts at unauthorized access.