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

  • NSIT Patna
    NSIT Patna Netaji Subhas Institute of Technology is begun in Amhara. Patna is the state capital and major business center of the country. A Degree Engineering College provides "An effective origin of Technocrats to the nation". The Main Aim of The Netaji Subhas Institute of Technology is to Supply ...
  • BARC Entrance Exam
    BARC Entrance Exam Bhabha Atomic Research Centre (BARC) is a prime Institution for Research & growth in Nuclear Science & Technology, in special Biological, Chemical Engineering & Physical Sciences. BARC carries on an entrance exam. This test called as BARC Entrance Exam or GATE for the admission...
  • IITM Library
    IITM Library IITM Library or popular as Central Library is situated in a separate building and caters to the information needs of the institute faculty, students, staff, research institutions & industries. It has around 2 million books covering all disciplines of science, engineering, technology, h...
  • Rajiv Gandhi Technical University Syllabus
    Rajiv Gandhi Technical University Syllabus The Rajiv Gandhi Proudyogiki Vishwavidyalaya is commonly called as Rajiv Gandhi Technical University. RGTU has been establishing by the Government of Madhya Pradesh with a clear goal of consolidating and renewing the technical education system in the regio...
  • Distance Learning K-12
    Distance Learning K-12 Though distance learning in K-12 education is not as prevalent as it is in the adult world, there are many forms of distance learning that are becoming growingly ordinary in schools throughout the world. In fact, "Online learning - for students and for teachers - is one of th...
  • Mp board supplimentry result
    Madhya Pradesh Board of Secondary Education (MPBSE) has declared the MP Board 10th Result of supplementary exam results. students can see their result on its official site. Mp Board directed 10th standard main examinations in March; students who scored less than 33% mark in any one or two subjects w...
  • Garhwal Mandal Vikas Nigam Limited GMVNL
    Introduction GMVN is an organization of the Government of Uttarakhand. It was established on 31st March 1976. Currently, GMVN has more than 90guest houses and tourist cottages spread out all over Garhwal even out in the most removed surface area. GMVN has a very productive tourism range spread all ...
  • Indian Academy of Sciences Summer Research Fellowship
    Introduction Indian Academy of Sciences was based and filed as a company in 1934 with the aim to encourage the build up and continue the case of skill, both in pure and employed arms. In August 2006 the Indian National Science Academy (INSA) and the Indian Academy of Sciences jointly prepared and s...
  • State bank of Patiala head office
    State bank of Patiala head office A Make a logical or causal connection Bank of the State Bank of India, State Bank of Patiala (SBP) was brought about or set up or accepted; especially long established in 1917 by Late His Highness Bhupinder Singh, the Maharaja of erstwhile Patiala state. SBP starte...
  • Karunya University Bio-Technology Syllabus
    Karunya University once Karunya Institute of Technology and Sciences is a fully residential Christian private university settled in Coimbatore. Karunya University university was founded in 1986. Karunya University is a Private university. This university is a best university which provides excellenc...
  • QLTT International
    QLTT International The Qualified Lawyers' Test (QLTT) International is a short, open-book test. It is, the exclusive administrator of the QLTT in the US, will offers you with everything you requirement to easily pass the exam. Once you qualify by it then you will enjoy the same right to practice as...
  • ECIL Trainee Engineers Jobs
    ECIL Trainee Engineers Jobs ECIL was setup below the Department of Atomic Energy in 1967 with an opinion to give a strong indigenous capability in the field of professional grade electronics. The initial accent was on total self-reliance and ECIL was enlisted in the Design, Development, Manufacture...
  • MCAT India
    MCAT India Medical College Admission Test, MCAT is an evaluated, computer-based examination, the score of which needs to be submitted in most of the medical colleges in India as part of the admission process. MCAT helps to evaluate vital thinking, problem solving, writing skills and written investi...
  • 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...
  • Port Health Organization Mumbai
    Introduction The stress in the National Health Policy, which was followed by the Parliament in 1983, is on the provision of device, getting and reconstructive health services to the people. The chief target is to place the health of the people in the hands of the people through the Primary Health C...