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

  • DU Mca Entrance
    Introduction Delhi University MCA Entrance Test, 2010 that take place in India. As far as we are pertained, the data about the D.U. MCA admission Test 2010 allowed for here are genuine and adjust, but we would still assert you to assert them with the pertained authorities. The college of Delhi is...
  • BDL India
    BDL stands for Bharat Dynamics Limited. BDL was founded in 1970. Mission of BDL is to launch itself as a leading producer in the aerospace & under-water instruments industry and issue as a world-class denoted state-of-the-art enterprise, providing total solutions to the security needs of the Nat...
  • Gulbarga University Library
    Gulbarga University Library The Gulbarga University Library, a knowledge Center for accessibility originated on modern lines as a high Learning Resource Center on spreading Campus, ideally situated. The Library has been one of the active members of INFLIBNET Center, Ahmedabad. This university aim ...
  • AYUSH Bangalore
    Introduction Ayush Ayurvedic is a unique health center, especially planned for distributing genuine Kerala ayurvedic kneads and discussions in a clean, hostile mad advantageous manner. Our technical cooperation with Arya Vaidya Pharmacy, the old ayurvedic introduction, in celestial body since 1943 ...
  • Nirma University Library
    Nirma University Library The Institute of Technology Library is one of the most beneficial engineering libraries in the State. The collection is primarily fresh in engineering and technology; still good information sources on humanities and social sciences are also available. The Library has a coll...
  • Delhi Police Recruitment for Sub Inspector
    Delhi Police Recruitment for Sub Inspector Delhi has a long history of policing by the known institution of the Kotwal. Malikul Umara Faqruddin is said to be the first Kotwal of Delhi. Delhi Police invites all eligible candidates who want to develop their carrier in field of police. Candidate selec...
  • Jaypee University of Information Technology Noida
    Introduction Jaypee Institute of Information Technology (JIIT) is located near the Electronic City at Noida at a distance of 3 Kms. from New Delhi-U.P. Border in the area intended for educational Institutions as supplied for by the Noida Authority. The Jaypee Institute of Information Technology pro...
  • JNTU Result 4-1
    JNTU Result 4-1 Jawaharlal Nehru Technological University is located in the heart of the city at Kukatpally JNTU offered management & computer application based program. JNTU premier institution with educator and research. Jawaharlal Nehru Technological University is a teaching cum research ada...
  • PMT Forms Last Date
    PMT 2010 Forms Last Date PMT is an entrance test for admission to bachelor medical and dental courses MBBS/BDS/BAMS in the medical and dental institutes. The examination paper is not very tough, but is capable enough of testing the knowledge of the candidates in almost every sector. The entrance te...
  • SIDBI Lucknow
    SIDBI Lucknow SIDBI Lucknow Was Launched In April 2, 1990. The Small Industries Development Bank of India (SIDBI) Act, 1989 envisaged SIDBI to be "the principal financial institution for the promotion, financing and growth of industry in the small scale sector and to co-ordinate the functions of th...
  • University Of Madras Chennai
    Introduction The University of Madras is one of the 3 most former universities in India (along with the University of Calcutta and the University of Mumbai). The Universit of Madras, coordinated on the example of the University of London, was contained on 5 September 1857 by an Act of the Legisla...
  • Modi Instutute
    Modi Instutute Dr.Kedar Nath Modi Institute of Engineering & Technology launched in the year 1995.Its first self financed institute of giving technical education in the state of UP it was set up with the aim of lending high quality techn-ical education to the meritorious students. The emphasis ...
  • Industrial Investment Bank of India IIBI
    The Industrial Investment Bank of India Ltd , is India’s only all-India public financial institution central office in Kolkata. They develop and,or trade in changed financial instruments from term loans, equity or debentures and bonds, structured products besides rendering various services like defe...
  • Bharat Earth Movers Limited KGF
    Introduction Bharat Earth Movers Limited (BEML) is an Indian populace Sector attempting, with central office in Bangalore. It industries a form of role instrumentality, such as that used for earth acting, carry and minelaying. Earth impressing part (EMD) at Kolar Gold Fields (KGF) is settled about ...
  • HIHT University Results
    HIHT University Results 2010 The Himalayan Institute Hospital Trust (HIHT) the supporting society for HIHT University was launched by H.H. Dr. Swami Rama. HIHT University offers both undergraduate and post graduate courses. The mission of the Institute is to develop incorporated and cost-effective ...