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

  • Occupational English Test Online
    Occupational English Test is also known as OET. The OET was designed to assess the English language proficiency of examinees wishing to enter training programs or take examinations in health professions in Australia. The OET tests English knowledge in the medical/ health professions of candidates. T...
  • Rajiv Gandhi Proudyogiki Vishwavidyalaya Results
    Rajiv Gandhi Proudyogiki Vishwavidyalaya Results 2011 Introduction Rajiv Gandhi Proudyogiki Vishwavidyalaya conducts various exams in every year. Candidates want to see the Rajiv Gandhi Proudyogiki Vishwavidyalaya Results please visit on official website. The students will get their results by p...
  • GOA board papers
    GOA board papers The Goa Board of Secondary and Higher Secondary Education is a corporate Relating to or created by statutes Body based by an Act of the Government of Goa. The objective of The Goa Board of Secondary and Higher Secondary Education is a apart from allowing The state or quality of b...
  • Nalanda Institute of Technology Orissa
    Nalanda Institute of Technology Orissa Nalanda Institute of Technology Bhubaneswar was founded in 2007 by the major contribution of Balaji Educational Trust with a mission to alter value and quality based education to the students. The institute is connected to the BPUT University and recognized b...
  • PhD in Kakatiya University
    PhD in Kakatiya University Mission of Kakatiya University is to strive constantly to achieve high standards in teaching and research & to carve out a niche for the University imparting higher quality teaching with a holistic approach. The University originally founded as a post-graduate college in...
  • Graduation Walk
    Graduation Walk Graduation is the action of obtaining or conferring an academic degree or the ceremony that is sometimes affiliated, where students become Graduates. Before the graduation, candidates are referred to as Graduands. The date of graduation is often called degree day. Many websites...
  • FMGE
    Introduction Family Welfare, Government of India FMGE is a testing Test carried for those Indian citizens having a basic medical eligibility granted by any medical introduction outside India. It is for the purpose of getting registered for Medical meeting of India or any State medical examination m...
  • NISER Application Form
    NISER Application Form 2010 NISER is performing the 5 year -Integratated M.Sc. programme in Biology, Chemistry, Mathematics and Physics. NISER coordinates a unique nationwide entrance test National Entrance Screening Test (NEST) in association with UM-DAE CBS, another Institution establish by DAE i...
  • SOA University IBCS
    SOA University IBCS Siksha O Ansusandhan University IBCS aim is to launch an effective, effective and transparent system of examination and evaluation & to achieve transformation of knowledge. This university provides 100% good placement. SOA University metamorphoses from a very moderate beginning....
  • CSIR INDIA
    Introduction Council of Scientific and Industrial Research (CSIR) demonstrated in 1942 is an free body and India's biggest Research and growth (R&D) association, with 39 research lab and 50 field stations or dance centers spread across the nation, with a enterprise staff of over 17,000. Although...
  • CMPDI Bilaspur
    CMPDI Bilaspur Central Mine Planning & Design Institute Limited was founded in 1975 as an assistant of Coal India Limited for giving total consultancy helps to Coal India Limited and its seven assistants which promote about 90% of the total coal presentation of the country. CMPDI have seven region...
  • Vikram University Ujjain Timetable
    Introduction Vikram University was demonstrated in 1957 in Ujjain, Madhya Pradesh. With nearly 20 sections and over 80 colleges, the university has an more and more importance role in the socio-cultural growth of the region. You can also get data on the becharm test schedule. You can also get down...
  • Bengal Engineering College Wiki
    Bengal Engineering College Wiki The Bengal Engineering College was instituted in 1856 at Shibpur, Howrah. This is affiliated by The Bengal Engineering and Science University (BESU). BEC is one of the oldest and prime engineering colleges in India. The college is known for its heritage as well as ex...
  • Bharati Vidyapeeth University Entrance Exam
    Bharati Vidyapeeth University Entrance Exam The Bharati Vidhyapeeth University was founded in 1956 at pune. BVU carries on various entrance tests for admission in various programs of Bharati Vidyapeeth University. These tests are not very tough. By these tests this university checks the ability o...
  • NEHU mba
    NEHU mba North Eastern Hill University is a public university was established in 1973 year. Department of Management - Tura Campus of the North Eastern Hill University A colloquial expression for invitation applications for MBA ADMISSION (2010-11). Candidates who have appeared in September or Decem...