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

  • Biju Patnaik University of Technology Bhubaneswar
    Introduction Biju Patnaik University of Technology (BPUT), Rousseau has been based by an Act of the assemblage, authorities of Orissa in June 2002. All technology, pharmaceutics, computer architecture and most of the colleges offering MCA and MBA degree plans are either component or associated coll...
  • 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, ...
  • University Of Punjab Results
    The University of the Punjab was founded in 1882 at Lahore, is the biggest and the most previous center of higher learning in Pakistan. It was the first to be founded in the sub-continent in Muslim majority area. The concept that two Nobel laureates are from this University speaks volumes for its ac...
  • TCIL interview questions
    Introduction TCIL, a superior engineering and training company, is a entirely possessed Government of India Public Sector organization under the administrative command of the Department of Telecommunications (DOT), Ministry of Communications and Information Technology, Government of India. TCIL was...
  • Calcutta University BEd
    Calcutta University BEd The University of Calcutta is a public university Situated in a particular spot or position in the city of Kolkata (previously Calcutta), India, Start and new organization or institution on 24 January 1857. It is a public university. Applications from graduate (preferably...
  • ESIC Mumbai
    ESIC Mumbai The Employees' State Insurance Act, 1948 "An Act to provide for certain benefits to employees in case of sickness, relationship and employment accident and to make provide for certain other matters in relation to that." Benefits of ESIC is Medical Benefit Maternity Benefit (MB) Sickn...
  • Universities in India Providing PhD in Life Science
    Life science Ph.D. program is open to students having either a scientific or a philosophical degree as well as to medical doctors. PhD in Life Science intentions to make internationally realized scholars in the facilities of the foundations of the Life Sciences, ethical analysis and the relationship...
  • Sriram Business School Noida
    Sriram Business School Noida Introduction Sriram Business School, Noida is established in the year 2001. This school is based on the trait of faith, courage, pride and hard work for its success. This school is apparent by structure and amenities brought in among the best infrastructure. The sch...
  • BPUT ac
    BPUT ac www.bput.ac.in is an official website of Biju Patnaik University of Technology (BPUT). This website contains all information about this university and also provides all detail related to BPUT. This website also available BPUT‘s course, department, administration and camps requirement and ...
  • OSCB Training
    OSCB Training Oxford shire Safeguarding Children Board is responsible for assuring that there are suitable policies and processes in place and monitors the performance of administrations with protecting responsibilities. OSCB Training goals are to provide access to qualitative training and useful i...
  • UPCL UDUPI
    UPCL UDUPI Despite strong opposition by locals, the first phase of the Udupi Power Company Ltd (UPCL), erstwhile Nagarjuna Power Company Limited, Situated in a particular spot or position at Nandikoor near Padubidre in Udupi district has almost completed its coal based thermal plant. The company,...
  • Indian Institute of Information Technology Kolkata
    Indian Institute of Information Technology Kolkata Indian Institute of Management (IIM) - Kolkata The Indian Institute of Management, Calcutta was established in 1961 - India's first national institute of management for post-graduate studies and research in management. This is an autonomous institu...
  • Guntur Medical College, Guntur
    Guntur Medical College has so soon celebrated its 50 years of Fruitful accomplishments. The construction of this college was began on 22-6-1946. On 6th July 1954 Clinical Courses are began.  The Medical College was started with 50 Undergraduate students later this number was enhanced to 150 students...
  • VTU 4th SEM Exam Time Table
    VTU 4th SEM Exam Time Table Visvesvaraya Technological University is also meant as Visveswaraiah Technological University, (VTU), is one of the top rated technological universities in Karnataka, India. VTU is settled on a beautiful campus in Belgaum, VTU is one of the biggest Technological Univers...
  • Orissa Public Service Commission Jobs
    Introduction Orissa Public Service Commission is responsible for recruitment of Gazetted Officers in the State. It imparts yearly examinations for the employing of Civil Servants, Police Officers in the DSP rank and several other allied services. Generally exams are carried on every year for the co...