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

  • Vijaya Bank Recruitment Exam Date
    Vijaya Bank Recruitment 2010 Exam Date Vijaya Bank has the higher number of stems in its home state Karnataka. Vijaya Bank is one amongst the some banks in the country to take up primary organization of VISA International and MasterCard International. This Bank provides excellence services to the...
  • Dena Bank Po Recruitment
    Dena Bank Po Recruitment Dena Bank was established in 1938. Dena Bank is the most common bank that handles the Probationary Officer Exam for recruiting applicants for the post of PO. Dena Bank invites all the eligible candidates to be recruited for the post of Bank PO. Recruitment for the post of P...
  • TIFAC Core DST
    Introduction Technology Information, Forecasting and Assessment Council (TIFAC) is a recorded club under sector of Science & Technology. The main goals of TIFAC consider people of engineering estimating/Technology cost/ Techno Market Survey paperses, the main subjective of these Courses in TIFA...
  • NID Entrance Exam
    Introduction NID is internationally applauded as one of the best multi-disciplinary institutions in the area of design education and research. The institute functions as an independent body under the Ministry of Commerce & Industry, Government of India. All candidates are needed to attend th...
  • AP Transco Jobs
    AP Transco Jobs Transmission Corporation of Andhra Pradesh Limited is called as AP Transco. AP Transco came into being in 1999 as a consequence of restructuring of the formerly AP State Electricity Board (APSEB) to look after Trans-mission of Electricity in Andhra Pradesh. Jobs For more inform...
  • Manipal Institute of Technology Results
    Manipal Institute of Technology Results Manipal University has appeared as the leading higher education provider in India. The University has produced a system of teaching and research excellence making it a universally accepted destination by students. MIT provides technical & management based pro...
  • MANIT Bhopal Recruitment
    Maulana Azad National Institute of Technology (MANIT) Bhopal was founded in the1960. MANIT has been proposed with the condition of institute of National emphasis. This institute provides technological based program. MANIT provides excellence faculty with good knowledge. The institute develops good s...
  • RRB Bhubaneswar
    RRB Bhubaneswar 2010 Railway Service Commission, Bhubaneswar was launched in the your 1983 and commenced it’s functioning from IRC Village, Nayapalli Bhubaneswar. In January, 1985 Railway Service Commission was called as Railway Recruitment Board (RRB). Its territory was Khurda Road Division, Chakr...
  • DOMS Pencils
    DOMS Pencils DOMS enterprise is having in depth knowledge of through production activity for manufacturing Pencils and relavent product.To launch its foothold in the manufacturing sector of Pencils, a state of art Manufacturing facility has been establish in the Place at Umargam, Gujarat State in I...
  • BECIL website
    BECIL website BECIL is providing world class practice of giving expert advice within a particular field services in the Developed or designed for a special activity or function fields of Broadcast Engineering and Information Technology. BECIL is also providing significant contribution to sound and...
  • Christ University MBA
    Christ University MBA Christ University was launched of the educational sight of Blessed Kuriakose Elias Chavara, the beginner of CMI congregation. The main direction of this institution is the minority Christian students who lag behind in educational opportunities. Christ University was formerly...
  • Periyar University UG Results
    Periyar University UG Results The Periyar University was founded by the Act 45 of Government of Tamilnadu in 1997. The University is located on the Bangalore National Highways. It has been assigned with National Accreditation Council (NAAC) certification. PU offers collection of courses at differ...
  • PIMR Indore
    PIMR Indore Prestige Institute of Management & Research (PIMR) came into existence in the year 1994, as an independent institute. It is settled in Indore, Madhya Pradesh, and is flourishing towards becoming one of the contributing self refinanced education and training centres in the country. I...
  • Nagpur University MBA Results Winter
    Introduction The Nagpur University also known as Rashtrasant Tukadoji Maharaj Nagpur University was founded on August 4, 1923 in the city of Nagpur in the Maharashtra state of central India. The results have announced by the Controller of Examinations, Nagpur University is available on the notice b...
  • ITI Ltd Raebareli
    ITI Ltd Raebareli Information technology infrastructure Ltd was established in 1948. ITI joined the league of world class vendors of Global System for Mobile. Facilities Plastic Injection Technology PCB manufacturing facilities Fabrication of Towers and Shelters for GSM Mechanical Fabrica...