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

  • Swami Vivekananda Yoga Research Foundation
    Introduction Vivekananda Yoga Anusandhana Samsthana or VYASA is an organization dedicates to the cause of development and popularizing of yoga in the modern society. Formerly it was known as Vivekananda Kendra Yoga Anusandhana Samsthana (VK YOGAS) Swami Vivekananda Yoga Anusandhana Samsthana-Resear...
  • Jawaharlal Nehru University Hyderabad
    Jawaharlal Nehru University Hyderabad The Jawaharlal Nehru Technological University is well experienced in complete India and founded to grow the education of the India society. The university is having all origins for the training and placements involves of the several companies. The institute i...
  • University Of Rajasthan Time Table
    Introduction University of Rajasthan is the most former institution of higher discovering in Rajasthan. It was demonstrated on 8th January, 1947, as the University of Rajputana with the main subjective of running cognition and catering to the needs of the pupils of Rajasthan. It had district over ...
  • Sample Papers of CBSE of Class 12
    Sample Papers of CBSE of Class 12 The Central Board of Secondary Education is a Board of Education for school level in India of Central Government. The board carries on final examinations every expose for All India Senior School Certificate Examination (AISSCE) for Class 12. For more information...
  • Central Board of Secondary Education Ajmer
    Central Board of Secondary Education Ajmer Central Board of Secondary Education Ajmer witnessed rapid development and expansion at the level of secondary education resulting in improved quality and standard of education in its institutions. CBSE is 1 of the widely recognized boards of school educat...
  • IFS Syllabus
    Introduction Indian forest service (FIS) Is the tree farmer serve Union Public Service committee has issued the much expected appraisal on 2 nd January, 2010. The number of posts expected to be filled up by this exam is about 965. The appraisal number No. 04/2010-CSP campaigners will be required to...
  • Fort Benning Graduation
    Fort Benning Graduation Fort Benning is situated in west central Georgia about twelve miles south of Columbus, Georgia. Graduation from the recruit’s US Army training is a stimulating feel for both the recruit and their travelers. The graduation occasions are carried on weekly all over the year fo...
  • Indira Gandhi Open University Ahmedabad
    Indira Gandhi Open University Ahmedabad Indira Gandhi National Open University was founded in 1985 to alter higher education. The IGNOU aim is to provide cost-effective, quality education to prominent departments of our population adding those living in device and distant areas. A pond fifteen year...
  • MLSU Time Table
    MLSU Time Table 2010 Mohan Lal Sukhadia, the designer of new Rajasthan, the University was called as Mohanlal Sukhadia University in 1984. This Agricultural University was changed into a multi-ability university in 1964 identified as University of Udaipur. This university provides high educated fac...
  • HP University Date Sheet
    Introduction Himachal Pradesh University took the bold step right in the origin and a board of agreement courses of action was set up after the institution of the college (1971). Not only this, the college issued as a pioneering creation in founding the engineers of length education at the gradu...
  • Cochin Shipyard Tenders
    Introduction Cochin Shipyard was comprised in the year 1972 as fully owned authorities of India party. In the last three mercenaries the party has issued as a antecedent in the Indian ship building & Ship repair diligence. This yard can build and repair the smallest vessels in India. It can bui...
  • IDBI Recruitment Assistant Manager
    Introduction IDBI Bank is a Board-managed organization. The obligation for the day-to-day direction of procedures of the Bank is vested with the Chairman & dealing Director and two Deputy dealing managers, IDBI is a banking company under the Companies Act 1956 having majority share holding by a...
  • IGNOU Assignments
    Introduction Indra Gandhi National Open University Students or educators. We allow for the character solutions to the Open Universi ties and CBSE Board PAPER and other Boards. We allow for quality Notes & figured out papers for CBSE & IGNOU Students; Delhi & Other college students.IGNOU...
  • Sri Sathya Sai University Vidyagiri Anantapur
    Sri Sathya Sai University Vidyagiri Anantapur The Sri Sathya Sai University was founded in 1981, by Bhagavan Sri Sathya Sai Baba. An independent body, it has been realized by the Ministry of Education, Government of India, and the University Grants Commission (UGC), as a Deemed University. This uni...
  • Madhya Pradesh Bhoj Open University Courses
    Madhya Pradesh Bhoj Open University Courses Madhya Pradesh Bhoj Open University (MPBOU) was founded in 1991 below an act by the State Legislature. The University named after the famous Raja Bhoj is the second biggest Open University in India. The main aim of MPBOU is to extend and encourage higher ...