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

  • Army Welfare Education Society CSB
    Introduction Army benefit breeding Society (AWES) is now 25 year-old. This period of time has base huge growth, integration and atonement for the AWES union. 1000s of Army wards have came at from this first step of the Indian Army. From 28 regiment schools and four High Schools in 80’s, AWES has co...
  • GGU BA Result
    GGU BA Result Golden Gate University was university formed in 1901 and located in the South of Market district. This is a private, nonsectarian, coeducational university formed. Golden Gate University is mainly a post-graduate institution focused on professional training in law and business, with i...
  • Board of Apprenticeship Training Western Region
    Board of Apprenticeship Training Western Region The Board of Apprenticeship Training is an autonomous organization under Min. of Human Resource Development, Govt. of India launched with the exclusive objective of improving the capability of fresh Engineers through 1 year 'on the job training' in ac...
  • ITRC Warranty Check
    ITRC Warranty Check IDENTITY THEFT RESOURCE CENTER mission is to provide most skillful in class person activity at no charge to consumers throughout the United State and instruct users, firms, government jobs and other establishments on best practices for crime and identity theft discovery, reducti...
  • VBS Purvanchal University Exam Date
    VBS Purvanchal University Exam Date Veer Bahadur Singh Purvanchal University Jaunpur was founded in 1987 as a joining university below U.P. state university act 1973. Purvanchal University was called as Veer Bahadur Singh Purvanchal University in the award of late Shri Veer Bahadur Singh. This univ...
  • NYU Buildings Fetterman
    NYU Buildings Fetterman New York University (NYU) was founded in 1831, is a private, nonsectarian research university based in New York City. NYU's main campus is situated in the Greenwich Village section of Manhattan. Most of NYU's buildings are settled throughout an approximately 229 acre area b...
  • Orissa CHSE exam time table
    Introduction The Council of Higher Secondary Education, Orissa was demonstrated in conformity with the Orissa Higher Secondary Education Act 1982 having been acquiesced to by the Governor on the 23rd October 1982 to govern, Control and formulate Higher Secondary Education in the State of Orissa. Th...
  • Ohio University Graduation
    Ohio University Graduation (OU) Ohio University situated in Athens, OH, is one that prides itself on the success of their students. Ohio University is one of the better Public schools in the nation, and their students are some of the finest as well. Ohio University has two sets of graduation req...
  • Bharat Refractoriness Limited Tender
    Introduction Bharat Refractories (BRL) at Bokaro has added down its net loss by Rs 12 crore (US$2.470 million) in the 2001-2002 no financial Year by developing product and cutting men and other active costs. During the period, BRL produced 29,425 tones of furnace lining valued at Rs 46.41 crore (US...
  • Diploma in Aviation
    Nelson Marlborough Institute of Technology provided Diploma in Aviation Science integrates the practice of flying with the theory of management and is suitable for students wishing to have a future in the aviation industry. The programme is provided jointly through NMIT, associated aviation provider...
  • Central Agricultural University Aizawl
    Introduction Central Agricultural University at Aizawl (Mizoram) was launched by the Government of India. It functions under the governance of the Central Agriculture section and enjoys allows from it. Infrastructure of the University has been invariably upgraded and number of colleges under its af...
  • Rajasthan University Syllabus
    Rajasthan University Syllabus The University of Rajasthan is considered one of the oldest institutions of higher learning in Rajasthan. It was established on 8th January, 1947. University of Rajasthan’ is a multi-faculty University. The location of the University is overall urban and hip. Rajastha...
  • ISMU Dhanbad
    Introduction Indian School of Mines (ISM) is a fully occupant and co-informative university settled in the material-rich belt of India in the city of Dhanbad, Jharkhand. It was established in 1926 on the lines of Royal School of Mines, London. Today The section of direction of Indian School of Mine...
  • Metro railway in Delhi
    Metro railway in Delhi The Delhi Metro is a done or occurring in a brief period of time transit system serving Delhi, Gurgaon and Noida in the National Capital Region of India. The network (rail transport) a lineup or sequence of railroad carriages or cars, with or without a locomotive, that form...
  • Defense Research
    Defense Research The Defense Research and Development Organization were organized in 1958 by the merger of Technical Development organization and the Directorate of Technical Development and Production with the Defense Science Organization. The Defense Research and Development Organization (DRDO) ...