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

  • Staff Selection Commission Recruitment Tax Assistant
    Staff Selection Commission Recruitment 2010 Tax Assistant The Subordinate Services Commission was established under Government of India in the year 1975. It was renamed as Staff Selection Commission. The Staff Selection Commission had guided an open competitive examination for recruitment to the po...
  • APEEJAY Institute of Technology School of Management
    Introduction Apeejay Institute of Technology - School of direction behaviors an access appendage for access to its two year Post commencement in Diploma direction plans. Apeejay appoint of engineering is part of Apeejay breeding Society and was demonstrated in 1997. The establish has a large Apeeja...
  • APS University Rewa Mp
    Introduction Awadhesh Pratap Singh, a discerned son of the soil and a exemption person. The college was founded on the 20th July 1968 and got UGC credit in February 1972. It has relationship of the connection of Indian Universities (AIU) and All country connection of college (ACAU). The college ...
  • Ramakrishna Mission Vivekananda University Coimbatore
    Ramakrishna Mission Vivekananda University Coimbatore Ramakrishna Mission Vidyalaya, Coimbatore, is a field educational centre of the well-thought Ramakrishna Mission. Ramakrishna Mission Vivekananda University was established with Faculty of Disability Management and Special Education as one of it...
  • Delhi University Correspondence Courses
    Delhi University Correspondence Courses The University of Delhi is the prime university of the country and is experienced for its high values in teaching and research and pulls superior scholars to its faculty. The University of Delhi was founded in 1922 as a united, teaching and residential univer...
  • NIT Kurukshetra PhD
    NIT Kurukshetra PhD National Institute of Technology (NIT) Kurukshetra is a Government institute offering undergraduate, postgraduate and PhD courses in the field of engineering and technology. NIt Kurukshetra is one of the top engineering and technology colleges in India. This institute invites al...
  • Tumkur university Karnataka
    Tumkur university Karnataka Tumkur University is a public university was established in 2004 year and situated in Tumkur in Karnataka in India. The University blossomed in the era of Growth to a global or worldwide scale in which the economies of the world are being transformed from their origina...
  • Dr. Babasaheb Ambedkar movie
    Dr. Babasaheb Ambedkar movie Dr. Babasaheb Ambedkar was birth on 14th April 1891 to Bimabai and Ramji. It is a pure symbol of hard work, dedication, commitment, love and the quality of being humane. He is a pure example and inspiration of hard work, dedication, commitment, love and humanity. His ...
  • Bhel Engineer Trainee Online
    Bharat Heavy Electrical Limited (BHEL) ever committed to making a better world. Bharat Heavy Electrical Limited (BHEL) is one of the most biggest Engineering and Manufacturing Enterprises spread widely around the nation. Bharat Heavy Electrical Limited (BHEL) now provides excellent chances to young ...
  • Institute Of Life Sciences Hyderabad
    Introduction Institute of Life Sciences (ILS) is a Prime Minister explore establishment based by a public–buck private business initiative in the year 2004. Its explore services make up various abilities caparison 32 explore research lab, 10 defend research lab, presymptomatic biology, restaurant, ...
  • Atomic Minerals Directorate for Exploration and Research Bangalore
    Introduction Atomic Minerals Directorate for geographic expedition and Research, with headquarters at Hyderabad and seven territorial centers on, is the youngest unit of the section of nuclear Energy (India) (DAE), authorities of India. AMD started operating from New Delhi on August 10, 1948 as ‘Ra...
  • AMET University Seminar
    The AMET University, Chennai in support with National Maritime Foundation, New Delhi is organizing an International Seminar on Opportunities for Maritime Research in Academia and Industries. AMET provides UG, PG, Diploma & other courses. This university provides 100% good placement to their stud...
  • 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...
  • WBSCTE Diploma Result
    WBSCTE Diploma Result West Bengal State Council of Technical Education is provided technical diploma. It is develop good skills in their students. For more information about diploma courses, admission to state polytechnics, syllabus and examination results of technological institutes in WBSCTE to v...
  • Kalasalingam University Semester Results
    Introduction Kalasalingam University (formerly Arulmigu Kalasalingam College of Engineering (AKCE) is located in Srivilliputhur, Tamil Nadu. It is a well know university and it extends 9 UG and 17 PG courses in Engineering in increase to MBA, MCA & Msc courses. Recently, it has declared the exa...