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

  • JNU Entrance Exam for MCA
    JNU Entrance Exam 2010 for MCA Jawaharlal Nehru University (JNU) carries an entrance examination for admission to its MCA entrance. MCA course of Jawaharlal Nehru University is very popular amongst the candidates who want a career in IT industry. MCA course is available in School of Computer & ...
  • KSTDC MAYURA Valley View
    KSTDC MAYURA Valley View Mayura Valley View hotel in coorg enjoys the best and highest location in Madikeri, with a 360 degree panoramic view of the valley and closely encircling township. Mayura valley view is a KSTDC hotel, a government of Karnataka Any piece of work that is undertaken or attem...
  • Archives of Uni of Calcutta Accreditaiton Records
    Archives of Uni of Calcutta Accreditaiton Records The University of Calcutta is also accepted as Calcutta University. This is a public university situated in the city of Kolkata (previously Calcutta), India. The University of Calcutta was founded in 1857. This university is the most previous of ...
  • CDS Exam Question Papers
    CDS Exam Question Papers CDS Stands for Combined Defence Service. The Examination is the part of UPSC Services Examination executed in different centers extends all over the nation. Here, Latett offeres question papers of several subjects and other resources regarding Combined Defence Service. This...
  • IMSC Maths
    IMSC Maths The Institute of Mathematical Sciences founded by Alladi Ramakrishnan in 1962. This is a national institution for factor research in the mathematical and physical sciences. IMSc hosts a big number of scientists at the post-doctoral level and supports a vibrant Visiting Scientist Scheme. ...
  • National Institute of Mental Health NIMH
    National Institute of Mental Health NIMH The National Institute of Mental Health (NIMH) is object of the federal government of the United States and the biggest research organization in the world specializing in mental illness. NIMH is specially known for learns of genetics, neuroscience, and clini...
  • Banasthali School
    The beginning of Banasthali is specific in more directions than one. Banasthali University is its existence neither to the willingness of a specialist, nor to that of a social apparatus. It is also not the introduction of a Philanthropist's sum. The sensation and assignment of Banasthali is to prepa...
  • Diploma In Nephrology
    Diploma In Nephrology The Nephrology Unit provides two specialist postgraduate degrees in nephrology. It has very strong international connections, which are reflected in our Diploma and Masters courses. Many institutes offered Diploma In Nephrology there are giving a list of institutes who offe...
  • BINC Exam
    Introduction Bioinformatics National Certification (BINC) Examination will be acquitted on 20-21 February 2010. The section of Biotechnology (DBT), authorities of India has established this testing with an accusative of certifying Bioinformatics professionals and to facilitate industries and possib...
  • Small Industries Development Bank of India Act 1989
    Introduction Small Industries Development Bank of India is an independent fiscal introduction directed to aid the development and development of micro, small and average scale endeavors in India. Establish in 1990 by an act of fantan, it was comprised initially as a all owned auxiliary of Industria...
  • Science and Engineering Research Council UK
    Introduction Science and Engineering Research Council (SERC) used to be the UK means in charge of privately collected scientific and technology research actions excluding physics, biotechnology and biological sciences, space research and particle physics. The SERC had oversight of the Royal Greenwi...
  • Rajiv Gandhi Institute of Technology and Management Education
    Rajiv Gandhi Institute of Technology and Management Education Rajiv Gandhi Institute of Technology is 1 of the ISO 9001:2000 Certified premier educational institutions, launched in 1992 under Manjara Charitable Trust. Manjra Charitable Trust was launched in 1988 with the prime goal of affording e...
  • Institute Of Management Technology Dubai
    Institute Of Management Technology Dubai The Institute of Management Technology Dubai was established in 2006 at Dubai International Academic City. IMT provides a recognized MBA program as well as Executive education to companies functioning in the UAE. One of the main advantages of the 2 year M...
  • Dsvv .Org
    Dsvv .Org dsvv .org is a official website of Dev Sanskriti Vishwa vidyalaya (http://www.dsvv.org). This is a best website of Dev Sanskriti Vishwa vidyalaya. DSVV was founded in 2002. This is a Residential University. The University is punctually realized by the University Grants Commission (UGC...
  • VNIT Nagpur Cut Off
    Introduction Visvesvaraya National Institute of Technology VNIT lies in the midst of a rain brought on stupor, a group of seven were having an evidently covert assembling on the instant floor. Little did they earn that the room was badgered, thus making it potential to describe the following speech...