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

  • Dr BR Ambedkar University Agra Result
    Dr BR Ambedkar University Agra Result 2008 Dr. B. R. Ambedkar University, Agra is located in the city of Taj Mahal. It was launched on 1st July 1927 as Agra University. In 1996 the University was renamed as Dr. B. R. Ambedkar University. Original jurisdiction of University extended over United Prov...
  • CUSAT Entrance Application Form
    Introduction CUSAT 2010 Chalan form (in triplicate) transferred from the internet site http://www.cusat.nic.in after CUSAT 2010 online enrollment can be used to remit the CUSAT CAT 2010 application program fee at the bank. The fee can be postponed at any branch of State Bank of India OR State ban...
  • NTSE Exam
    NTSE Exam National Talent Search Scheme is a thing activity of the NCERT began in 1963. The intention of the scheme was to identify talented students and nurture their talent. Talent pertains to the possibility that appears itself in a high level of performance in one or more specialized areas. NCE...
  • Bank of Baroda Po Papers
    Bank of Baroda Po Papers Bank of Baroda is a bank of national repute. The bank was started in 1908. The bank aims to become a top ranking National Bank meeting all the international standards. The bank is invested to provide full pertain, ability and care to its stake holders. The bank recruits ca...
  • Kuvempu Open University Results
    Kuvempu Open University Results Kuvempu Open University extending higher education by Distance Mode is other important step taken by Kuvempu University so as to help student community in their zeal for engaging Post - Graduate studies. The University conceives that Distance Education is an as good...
  • Guru Jambheshwar University Directorate of Distance Education
    The Directorate of Distance Education of this University was founded in 1997 by acquainting four dissimilar programmes namely MBA, PGDCA, BBA, CIC. after then a lot of head-way has been made in terms of number of programmes, number of students entered, number of study centres, production of caliber ...
  • AP Board Website
    AP Board Website The Andhra Pradesh Board is established in 1900. The College Board is HAS non profitable membership organization whose mission is to link students to college success and opportunity. The College Board is constituted of more than 5,700 schools, colleges, universities and other educa...
  • UPCPMT application forms
    UPCPMT 2010 application forms The UPCPMT (Uttar Pradesh Combined Pre Medical Test) is Direct the course of; manage or control for entry into various government sponsored and non-government sponsored colleges. It is Direct the course of; manage or control for medical and dental courses. Applicatio...
  • Nuim Library Catalogue
    Nuim Library Catalogue The National University of Ireland Maynooth Library was launched in 1795 & is now housed in the John Paul II Library and the Russell Library. The Library has formulated a superior collection of books & journals. Nuim Library mission is to help introduction of new knowledge by...
  • Awadhesh Pratap Singh University Website
    Introduction Awdhesh Pratap Singh University is an independent introduction situated in Rewa city, often called ‘the land of albumen tigers', settled in the state of Madhya Pradesh in India. The college has been named after chieftain Awadhesh Pratap Singh, an high exemption fighter. APS college is ...
  • Memorandum of GSBA, Greater Noida
    Memorandum of GSBA, Greater Noida Graduate School of Business & Administration Greater Noida is one of the top 50 Business Schools in the country that has been extending PGDBA Program with a quality. The Institute gives the most recent Audio-Video instructing apparatuses for speeches and has for...
  • Bharat Heavy Electricals Limited Recruitment
    Bharat Heavy Electricals Limited Recruitment 2011 Introduction Bharat Heavy Electricals Limited is one of the directing ‘Navratna’ Public Sector Undertakings of Indian Government. As a prime Engineering association, Bharat Heavy Electricals Limited offers world best products and facilities to t...
  • AMUPMDC Entrance Exam
    Introduction AMUPMDC Entrance Exam 2010 was be acquitted by the affiliation for access code to Health Science Courses in Private Unaided Medical, Dental, Ayurvedic, Physiotherapy, occupant medical aid and Nursing Colleges. Association of direction of unassisted buck private medical and Dental Colle...
  • SIMC Registration
    SIMC Registration SIMC affords a unique blend of experiences inside and outside the classroom to equip its trainees with an overall exposure to the media and communication industry. These events enable an interactive exchange and facilitate dialogue for the participants, media and the industry at l...
  • Aligarh Muslim University Admission Form
    Introduction Aligarh Muslim University is one of the oldest Prime Minister Central college of India with a specific and rich attitude of its own. It owes its existence to the unselfish and untiring attempts of the great anticipant Sir Syed Ahmad Khan. Profoundly impressed by the socio-economic and...