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

  • NIMCET official website
    NIMCET 2010 official website NIMCET is an entrance examination directs the course of; manage or control by National Institute of Technology’s for admission to the 1st year of their MCA courses. National Institute of Technology (NITs) is Payment for insurance institutes for technical education funde...
  • TNAU Mail
    Introduction Tamilnadu Agricultural University is a leading agro engineering provider of India and its alumnae are discerned throughout the world. Though the Tamil Nadu Agricultural University (TNAU) came into being on June 1, 1971, it had its genesis from institution of an Agricultural School at S...
  • SINP MAIL
    SINP MAIL Saha Institute of Nuclear Physics grew out of the Palit Research Laboratory in Physics of the University of Calcutta. The Saha Institute of Nuclear Physics is an institute of basic scientific research located in Kolkata (Calcutta). The Institute was founded in 1950 by Professor Meghnad Sa...
  • Life Sciences PhD Notification in Osmania University
    Osmania University is also known as OU. This is a public university located in the city of Hyderabad in Andhra Pradesh, India. It is one of the most previous new universities in India. This university provides excellence faculty with good knowledge. The university develops good skills in their stude...
  • CCRAS India
    CCRAS India The Central Council for Research in Ayurveda & Siddha (CCRAS) is an autonomous body enrolled in 1978. This Council came into universe after bifurcation of the formerly Central Council for Research in Indian Medicine and Homeopathy into four different Research Councils. The Council c...
  • Rivers Scholarship Exam
    Rivers Scholarship is also known as Irene Nickelson Scholarship. This Scholarship gives by The Rivers Family Scholarship Committee. This Committee judges applications, establishes policy, and solicits scholarship efforts. The Irene Nickelson Scholarship was founded in 2002 because education is the p...
  • National institute of epidemiology India
    Introduction The National Institute of Epidemiology (NIE) was launched on July 2, 1999 by merging the Central JALMA Institute Leprosy (CJIL), Field Unit, Avadi with the Institute for Research in Medical Statistics (IRMS), Chennai. This initiative mainly purposes to arise middle-level managers for p...
  • Maharaja Institute Of Technology, Udaipur
    Maharaja College of Engineering (MCE) is an institute for technical education, making it’s perform in 2008. It offers B. Tech programs. Maharaja Foundation is an educational first step of the National Society for Engineering Research and Development. Commitment to extend the highest standards of edu...
  • 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...
  • IIT Hyderabad Techfest
    IIT Hyderabad Techfest IIT Hyderabad is one amongst the six new IITs in India. It is has made significant accomplishments n a very short span of time. The institute commenced functioning from August 20, 2008, under the instruct of IIT Madras. IIT Hyderabad is presently operating from its own tempor...
  • TANCET application form downloads
    Tamil Nadu Common Entrance Test (TANCET) is an entrance examination Direct the course of; manage or control every year by Anna University on behalf of Tamil Nadu Government for admission in the professional post-graduate programmes in various Government/Private universities/institutes in Tamil Nadu ...
  • NDA Pune
    NDA Pune National Defense Academy Pune was established in 1955. Color of The Academy is red. The colors representing the three services Olive green (Army), Prussian blue (Navy) and Sky blue (Air Force) when mixed with red, the color of velour and sacrifice, blend into a shade of maroon. The Academy...
  • IPMX Blog
    IPMX Blog IPMX, the third, full time, one-year residential organization program would be founded in 2010 at the Indian Institute of Management Lucknow. The International Program in Management for Executives is planned for mid/senior rank professionals, to instruct them for leadership roles. This ...
  • AMIE Question Papers
    AMIE Question Papers AMIE conducted under the umbrella of Institution of Engineers, India. AMIE degree is accepted as an equivalent of engineering degree and is accredited through UPSC, AICTE, Central Govt., State Govt., and SSC etc. Besides, the degree holders are also qualified to write GRE, GATE...
  • SNDT Mumbai College Santancruz
    Shreemati Nathibai Damodar Thackersey Women's University (SNDT) is a women's university in the city of Mumbai, India. SNDT was founded in 1986. This college provides excellence faculty with good knowledge. Shreemati Nathibai Damodar Thackersey develops good skills in their students. This is a public...