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

  • UOHYD Library
    UOHYD Library The library has a publication of more than 3 lakhs books & back publications of journals. The University Library is a central service to agree the teaching and research processes of the University. The University of Hyderabad Library is a big library. The library purchases to about ...
  • Vellore Institute of Technology Campus
    The Vellore Institute of Technology or simply VIT is a private co-educational research university situated in Vellore Tamil Nadu, India. Mission of VIT is to educate students from all over India, including those from the local and rural areas, and from other countries, so they become enlightened ind...
  • GBU Vacancies
    GBU Vacancies Gautam Buddha University founded by the UP Act. The University is displayed in line with some of the best organizations of higher discovering around the world. This university provides excellence faculty with good knowledge. GBU provides technical, management & computer application ba...
  • JECA Form
    JECA 2010 Form JECA is a Joint Entrance Exam for admission to MCA education in several Government and Private colleges and Universities. JECA is carried on by the Joint Entrance Examinations Board. The examination provides admission to all the universities and colleges which are assorted to AICTE...
  • Directorate of forensic science Mumbai
    Directorate of forensic science Mumbai The Directorate of Forensic Science has been established at a position directly lower than the direct charge of MHA, Govt. of India. The Central Forensic Science Laboratories at Kolkata, Chandigarh and Hyderabad and Government Examiners of Questioned Docum...
  • KLE University dental
    KLE University dental Dental Science is an area that has Have the benefit of; obtain something desirable tremendous recognition in recent years. In the past, this important facet of Medical Science was neglected in the act of examining resemblances with mainstream medicine. The ratio of qualified...
  • National Law University Orissa Vacancies
    National Law University Orissa Vacancies The National Law University, Orissa (NLUO) predicts to be a stimulating new growth in the area of legal education. A very new institution, its launching Act of legislature was advised as lately as April 2009, entrance examinations were performed in May, and ...
  • CBSE Sample Papers
    Introduction Central Board of Secondary Education, CBSE Guess is the enlightening portal system of India for CBSE board students, we offer CBSE India Guess Papers, CBSE Sample Papers, CBSE Board 10 year Questions Bank etc. Beside these serves we also accost students and parents to search Indian and...
  • RRB Guwahati RPF
    RRB Guwahati RPF Railway Recruitment Board was Brought about or set up or accepted; especially long established in 1978.Recently RRB offering a vacancies post of RPF for appearing in the RPF inspector examination Direct the course of; manage or control by the central selection board, candidate ca...
  • University of Calcutta alipore campus
    University of Calcutta alipore campus University of Calcutta was set up in 1857 and it is one of the having lived for a relatively long time or attained a specific age and the greatest seats of Advanced in complexity or elaboration learning of India. It is a public university that provides UG and...
  • APSPDCL Guntur
    Introduction Andhra Pradesh Southern Power Distribution Company Limited AP Power Sector reclaims conceive of creation of dispersion parties as authorities projects for the first few years and denationalization later on. The Andhra Pradesh Gazette No.37 issued by the authorities of Andhra Pradesh on...
  • Combined Engineering Services Examination
    Combined Engineering Services Examination Combined Engineering Services Examination is carried on by the Union Public Service Commission (UPSC) of India. The UPSC carries on this test for recruitment of engineers to the four classes of Engineering Services: Civil Engineering, Mechanical Engineering...
  • Robbins Global Problems and the Culture of Capitalism Karl Marx’s Theory of Surplus Value
    Surplus-value is the social result which is over and above what is necessary for the producers to live. The carry of value is labor time, so surplus value is the collected product of the unpaid labor time of the makers. In capitalist society, surplus value is gained by the capitalist in the form of ...
  • VITEEE Question Paper
    Introduction Vellore Institute of engineering comes in under department 3 of the UGC act 1956. VIT is appointed by the National Board of certification (NBA) and complete India meeting for technological Education (AICTE), National judgment and document Council (NAAC) of the University Grants commiss...
  • Netaji subhas Open University Ph.D
    Netaji subhas Open University Ph.D Netaji Subhas Open University was Brought about or set up or accepted; especially long established in 1997. University is well known for Transmit (knowledge or skills) distance learning education. The university is recognized with Distance Education Council (DEC),...