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

  • National institute of epidemiology India
    Introduction The National Institute of Epidemiology (NIE) was launched on July 2, 1999 by merging the Central JALMA Institute Leprosy (CJIL), Field Unit, Avadi with the Institute for Research in Medical Statistics (IRMS), Chennai. This initiative mainly purposes to arise middle-level managers for p...
  • Maharashtra Board HSC Result
    Maharashtra Board HSC Result Maharashtra Board HSC stands for Maharashtra State Board of Secondary & Higher Secondary Education. This board provides best & high education. Candidate search their result by giving roll no & by giving name Maharashtra Board HSC Result is available at the official we...
  • Overseas Manpower Corporation in Chennai
    Introduction OMC is a determined company founded by Government of Tamil Nadu as early as 1978 with an official share capital of Rs. 50 lakhs. Its main object is to secure desirable overseas placements for the Indian professionals, adequate labors and others, who are wishful of fixing jobs abroad. T...
  • HP Board of School Education Result
    HP Board of School Education Result The Himachal Pradesh Board of School Education started in 1969. At present, the Board conducts examinations for the 8th, 10th, Plus One and Plus 2 classes. In addition, departmental examination like J.B.T., T.T.C and P.V.T.C are as well being conducted through th...
  • MCD Property Tax Calculation
    MCD Property Tax Calculation The MCD endures for Municipal Corporation of Delhi which is biggest municipal body in the world. MCD gives public services. It has the specific division for providing civic services to urban area as well as rural areas. Municipal Corporation of Delhi controls a nine ...
  • EMPI Institute of Advertising & Communication
    Introduction EMPI B-School, in cat valium pollutant free environs in South Delhi with its alone 24x7 attaining environs, conceived by scientist Pankaj (now bench vice chairman), was directed by EMPI Patron Chairman Ajit N. Haksar (Chairman Emeritus ITC Ltd.) in 1995. Beginning with its ship AICTE a...
  • Anna University Civil Engineering Code
    Anna University is a university in Tamil Nadu state India extending higher education in Engineering, Technology and Applied Sciences. Anna University was formed in 1978. This is a public university. Anna University is a best university which provides excellence faculty with good knowledge. The unive...
  • IESE Assessment Day
    Introduction Assessment Day is a unique feature of the school's MBA program selection process. 25 wishful MBA examinees from twelve assorted nations converged at IESE Barcelona campus on November 28 for Assessment Day. Assessment Day is a particular feature of the school’s MBA curriculum choice pro...
  • FCI Recruitment in Punjab
    Food Corporation of India was setup in 1965 below Food Corporation Act 1964. Object of FCI keeping satisfactory level of operational and modify stocks of food grains to ensure National Food Security. Punjab & Haryana Regions are the major extra States as far as production/procurement of food gra...
  • Madras Medical College Hospital
    Madras Medical College Hospital The Madras Medical College is situated in the city of Madras, presently known as Chennai in India. The college was founded in 1835. MMC provides high educated faculty with good Medical Science knowledge. The Madras Medical College offers a large number of courses at...
  • United India Insurance Company Mediclaim
    Introduction United India Insurance Company Limited was comprised as a Company on 18th February 1938. General Insurance Business in India was nationalized in 1972. 12 Indian Insurance parties, 4 Cooperative Insurance Societies and Indian procedures of 5 alien Insurers, besides General Insurance pro...
  • UK Universities for MBA
    UK Universities for MBA Many institutes are available in UK which provides MBA. Name of some Top Most universities are given below: London Business School – University of London Judge Business School – University of Cambridge Oxford Saïd Business School – University of Oxford Lancaster Univ...
  • Jawaharlal Nehru University Distance Education
    Introduction Jawaharlal Nehru University conducts every year different many programs. Some programs are Full Time Program and some program Distance Learning Programs. Distance Education is call as part time education. Because Distance Education is a short time program for education. JNU EduSat fac...
  • National Mineral Development Corporation Limited
    Introduction National Mineral Development Corporation Limited (incorporated 1958) is a public sector attempting of the authorities of India. It is fully had by the authorities of India and is below administer assure of the employment of Steel. verbal description: Mining: geographic expedition, deve...
  • BCA Coolege in Ranchi
    BCA Coolege in Ranchi Some colleges in Ranchi, provides BCA program. Birla Institute of Technology (BIT) Ranchi is one of the institutes which provides BCA program. BIT was established in 1955. This is a deemed University. BIT Ranchi ranks amongst the prime technical institutes of India and has va...