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

  • IIMC Entrance Exam
    IIMC stands for Indian Institute of Mass Communication. IIMC was found in 1965 as a department of the Ministry of data and Broadcasting, Government of India. It was filed below the Societies Registration Act 1966 as an independent organization. IIMC was founded with the intention of devising a metho...
  • Indira Gandhi National Tribal University MP
    Indira Gandhi National Tribal University MP Indira Gandhi National Tribal University, Amarkantak is settled in Madhya Pradesh which is a tribal central university founded by an act of parliament. The institute is one of the conceived and excellent institutes for providing degree education to the st...
  • National talent search examination results
    Introduction National Talent Search Scheme is a flagship activity of the NCERT started in the year 1963. The purpose of the scheme was to identify talented students and nurture their talent. For more information about National Talent Search Examination 2010 result please visit NTSE official websi...
  • IASE Rajasthan University
    IASE Rajasthan University 2011 The Institute of Advance Studies in Education is a deemed university situated at Sardarshahr, Rajasthan, India. The university is accredited as "B+" institute by the NAAC. The university was founded in 1950, on one of the most outside regional suburbs in the state o...
  • University Of Burdwan Result
    Introduction Burdwan is an anglicized version of the Sanskrit Vardhamana and the matching Bardhaman in Bengali. The origin of this name dates back to sixth century BC and is assigned to the twenty-fourth Jain Tirthankar, or Vardhamanswami, who spent some time in Astikagrama, according to the the Ja...
  • Kerala entrance online Question
    Www.Keralaentranceonline is a website it’s offered so many valuable information for student who preparation for various entrance exam. helps the students to prepare for the Entrance Exams by conducting Model Engineering/Medical entrance exam on every week end(Saturdays(Physi...
  • KMVN Munsiyari
    KMVN Munsiyari KMVN Munsiyari is the tourist rest house at Munsiyari. This Tourist Rest House is nominally priced so as to experience the needs of distinguishing travelers. The off season discount gave by the hotel is up to 20%. Kumaon Mandal Vikas Nigam has been serving the tourists with quality s...
  • International Institute of Population Science Mumbai
    International Institute for population Sciences (IIPS), Mumbai was launched in 1956 jointly by Sir Dorabji Tata Trust, United Nations, the Government of India. It was announced as a Deemed University on August15, 1985.The institute is an independent body under the administrative supervision of the M...
  • Kalyani University Distance Education
    Introduction The University of Kalyani was launched in the year 1960 and has developed onto a comprehensive institution with strong bases of administration and qualified faculty towards the mission of progress of learning and research. The University, with the help of Distance Education Council,...
  • Surat Municipal Corporation Book Fair
    The Surat Municipality came into existence in 1852. The Surat Municipality was replaced into Surat Municipal Corporation in 1966. Mission of Surat Municipal Corporation is to make Surat a dynamic, vibrant, beautiful, self-reliant and sustainable city with all basic amenities, to provide a better qua...
  • Post Graduate Institute of Medical Education and Research Chandigarh PGI
    Introduction The Postgraduate Institute of Medical Education and Research (PGIMER) Chandigarh was proposed in 1960 as a center of excellence which would effort to formulate rules of teaching in postgraduate medical education in as many branches as potential and undertake to develop medicos in vario...
  • MDSU Ajmer Exam Time Table
    MDSU Ajmer Exam Time Table Established in 1987, Maharshi Dayanand Saraswati University or MDSU Ajmer is one of the contributing universities in the state of Rajasthan. It is located near the Ghooghra village on the Pushkar Bypass, Jaipur Road (NH-8). The university has been recognized with B++ grad...
  • Veer Kunwar Singh University ARA Bihar
    Introduction Veer Kunwar Singh University named after the well known international hero and discerned independence fighter of 1857 was demonstrated on 22nd October 1992 October, 1992 with its Head Quarter at Ara, under the Bihar University Act 1976 as amendment Act 9 of 1992]. Its power covers four...
  • Winter Driving Tips
    Winter Driving Tips These are some winter driving tips: Make certain your tires are properly ballooned. Never mix radial tires with other tire types. Always look and steer where you want to go. Use your seat belt every time you get into your vehicle. Keep your gas tank at least half full to av...
  • University Of Jammu Directorate of Distance Education
    Introduction University of Jammu, appointed as 'A' grade University by National cost & accreditation Council of India came into being in 1969 vide Kashmir and Jammu Universities Act 1969 adopting big of the former University of Jammu and Kashmir. University of Jammu-Board of Distance Education,...