Skip to content

DBMS Syllabus

Database Management Systems Syllabus of Mahatma Gandhi University given below
Module I: Introduction
1.1 DBMS an overview
1.2 Advantages of DBMS
1.3 Network, Hierarchical and Relational Model
1.4 Levels of abstraction
1.5 Data Independence
1.6 Data Models
1.7 Instances and schemes
1.8 Data independence
1.9 Structures of a DBMS
1.10 Application Programmers & Data Base administrators – their function
1.11 Transaction Management
Module II: Entity Relationship Model
2.1 Entities
2.2 Attributes and Entity Sets
2.3 Relation and Relationships sets
2.4 Features of E-R Model
Module III: Relational Model
3.1 Introduction
3.2 Integrity constraints over relations
3.3 Enforcing Data Integrity
3.4 Integrity Constraints
3.5 Relational Data
3.6 Logical Data Base Design
3.7 E-R to relational
3.8 Introduction to views
3.9 Querying
Module IV: Relational Algebra and Relational Calculus
4.1 Operations on Relational Algebra
4.2 Operations on Relational Calculus
4.3 Tuple Relational Calculus
4.4 Domain Relational Calculus
Module V: Database Design
5.1 Introduction to Schema Refinement
5.2 Functional Dependencies
5.3 Normal Forms-First , Second, Third, Boyce code, Fourth and Fifth Normal forms
5.4 Multivalued Dependencies
Module VI: Structured Query Language
6.1 Basic SQL Queries
6.2 Union, Intersect and Except
6.3 Nested Queries
6.4 Aggregate operator
6.5 Null Values
6.6 Embedded SQL
6.7 Cursors
6.8 Dynamic SQL
6.9 ODBC and JDBC-Architecture and example
6.10 Triggers and Active Data Bases
6.11 Updates in QBE
Module VII: QBE
7.1 Introduction-Basic QBE queries
7.2 Queries over multiple relations
7.3 Negation in the Relations
7.4 Name Column-Aggregates-The Condition for updates
7.5 Division & Relational Completeness
Module VIII: Concurrency control
8.1 Concurrency Control -Overview
8.2 Concurrency control problems
8.3 Locks
8.4 Deadlocks
8.5 Serializability
8.6 Recovery

Leave a Reply

Some Related Questions & Articles

  • Last Date of Admission in Delhi University Correspondence Course
    The Correspondence courses in Delhi are supported by the Universities of Delhi and other Delhi Distance Learning Institutes. These Correspondence Courses in Delhi are extremely required as they allow the students to nurture other concern along with their studies. Thus, Delhi Correspondence courses I...
  • Netaji Subhas National Institute of Sports Patiala
    Introduction Netaji Subhash National Institute of Sports, Patiala, was based by the authorities of India on May 7, 1961 with the accusative of helping sports growth in a technological fashion and aiming of coaches in a ten thousand of sports fields. Netaji Subhas nation Institute of Sports (Sports ...
  • KRIBHCO Shyam Fertilizers
    KRIBHCO Shyam Fertilizers The Company was incorporated in 2005 consistent to a fix project agreement between KRIBHCO and Shyam Group to develop the urea creating facilities at Shahjahanpur from Oswal Chemicals & Fertilizers Ltd. The management operates of the Company perches with KRIBHCO, an as...
  • Shivaji University Distance Education
    Shivaji University was founded in 1962. Objective of Shivaji University Distance Education is to provide educational opportunities & to the female class of the society who has remained deprived because of domestic responsibilities and social restrictions. Centre for Distance Education of the Shi...
  • IIT Guwahati JEE
    Indian Institute of Technology Guwahati, the sixth member of the IIT club, was founded in 1994.Indian Institute of Technology Guwahati is the perform institute of engineering, science and technology. This institute provides excellence faculty with good science knowledge. Joint Entrance Examination...
  • Thiruvalluvar University UG Results Vellore
    Question: I want to get my UG result of Thiruvalluvar University Vellore give me my result. Answer: You are looking for the result of Thiruvalluvar University for that you have to go on official website of Thiruvalluvar University on the home page of this website you have to go on examination...
  • National Institute Of Pharmaceutical Education and Research Hyderabad
    Introduction NIPER, Hyderabad is a premier Research and Educational Institute founded under the Aegis of Ministry of Chemicals and Fertilizers, Govt of India, Mentor Institute IICT (Indian Institute of Chemical Technology) wants to receive Research Associate / Assistants to work at NIPER - Hyderaba...
  • SBI Po Salary
    SBI Po Salary State Bank of India is the best and the largest bank of India. Most of the people in India like to be a Government employee. The Government of India announced recruitment of probationary officers (PO) in associate bank of State Bank of India for 1717 jobs for different categories. SBI...
  • LOYOLA Institute of Business Administration Review
    LOYOLA Institute of Business Administration Review LOYOLA Institute of Business Administration was established in the year 1979. The institute, connected to the Anna University of Madras. This institute also known as LIBA. LOYOLA Institute of Business Administration is providing business knowledge...
  • OBC Clerk Recruitment Result
    OBC Clerk Recruitment Result Oriental Bank of Commerce was established in 1943 at Lahore. Oriental Bank of Commerce is one of the public sector banks in India. OBC organized an entrance exam for selection OBC clerk. Oriental Bank of Commerce invites all eligible candidates for this test. The sele...
  • CEPT University Admission
    CEPT University Admission 2010 Centre for Environmental Planning and Technology is a guiding institution offering undergraduate and postgraduate programmes in the areas of Natural and Built Environment and linked subjects. CEPT University plans not only to train competent technocrats but also to al...
  • Railway Recruitment Board Chennai
    Introduction Recruitment Board, Thiruvananthapuram, was established in March 1983 under the name of Railway Service Commission, Thiruvananthapuram. The Board Offered application for selection in various Post. It provides to the recruitment demands of all Group’s’ and ‘D’ vacancies of Thiruvanantha...
  • WBUT Question Papers
    Introduction The Govt. of WBUT launches an expert committee on Dec 31, 1998. The WBUT commonly mentioned to as WBUT. The WBUT has been allowed the affiliating University status with its jurisdiction broad the entire state of WBUT. The UTech is set to become a "Center of Excellence" in multidiscipli...
  • RBI recruitment
    RBI recruitment in 2010 The biggest Reserve Bank of India (RBI) was Start and new organization on April 1, 1935 with the provisions of the Reserve Bank of India Act, 1934. Reserve Bank is fully owned by the Government of India. The RBI Bank branches should also display as much information as possib...
  • Teas Nursing Study Guide
    Teas Nursing Study Guide Introduction The Nursing test is called the Test of Essential Academic Skills (TEAS). This test contains 4 sections: Reading, English, Math, and Science. Scholars are necessitated to prepay and pre-register for the TEAS test. The $40.00 is cost. Payment is acquired using...