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

  • Ph.D. Programme from TIFR
    I am a College teacher, seeking off campus Ph.D admission (UGC recognized)in Environment Science. Working in U.G College (28 years) affiliated under B.U(West Bengal) , Physically Challenged person. Is it possible for me to join Ph.D. programme?...
  • SINP Summer Project
    With due respect i beg to state that i am a student of Amity Institute Of Biotechnology,Noida. I am persuing B.Tech (Biotechnology) Final year (8th semester) . i want to do training in your institute for 3 months. Please tell me the procedure for the same. Subha Sharma...
  • BBA syllabus of Karnataka University of Dharwad
    Question: I want syllabus of Karnataka University of Dharwad BBA. Please give me address of such any website from where I can download the syllabus or you provide me the syllabus. Answer: The Karnataka University of Dharwad offers BBA. As you need its syllabus so here is the syllabus of 1st s...
  • Vidyasagar University 1st Year Result
    Vidyasagar University 1st Year Result Vidyasagar University is also known as VIDU. This is one of the prime universities settled in Medinapore, West Bengal. VIDU came into being with the passing of Vidyasagar University Act, 1981. This university provides excellence faculty with good knowledge. Vi...
  • OU supplementary results
    The Vision of the University is to give and spread knowledge through a balanced blend of old and modern wisdom, and to serve the society by formulating in students combined rational, cultural, ethical, and humane sensibilities; to foster a scientific temper, and to encourage professional and technic...
  • NIT Calicut Rank
    Question: What is ranking of NIT Calicut? Give me its ranking? Answer: Here I am providing you ranking of NIT Calicut NITC was ranked 13 (Factual Rank 7) by the India Today Best Engineering colleges 2012. In rankings limited to government institutes it was ranked 18 by the Mint Top 50 Go...
  • Rajasthan University Syllabus
    Rajasthan University Syllabus The University of Rajasthan is considered one of the oldest institutions of higher learning in Rajasthan. It was established on 8th January, 1947. University of Rajasthan’ is a multi-faculty University. The location of the University is overall urban and hip. Rajastha...
  • SHCIL Career
    SHCIL Career Stock Holding Corporation of India Ltd. (SHCIL) was included as a Public Limited Company in 1986. It has been jointly encouraged and owned by guiding Banks and Financial organizations. SHCIL requires Officer Trainees for Marketing and Operational functions. SHCIL invites all eligible c...
  • Corporation bank PO
    Corporation bank PO 2011 Corporation Bank is a Public Sector invited online applications for the act of putting a person into a non-elective position to the posts of Probationary Officers. The Probationary Officers exam by Corporation bank will be Direct the course of; manage or control on 09 may 2...
  • Guru Gobind Singh Khalsa College Amritsar
    Trai Shatabdi Guru Gobind Singh Khalsa College is a Premiere Institute run by S.G.P.C. This college was founded in 1999. Guru Gobind Singh Khalsa College Amritsar is affiliated to Guru Nanak Dev University, Amritsar. Mission of GGSKC Amritsar is to encourage motive and sobriety of life, to proclaim...
  • Chitkara University Barotiwala Solan
    Chitkara University Barotiwala Solan Chitkara University was established in 1998. Chitkara University is a private university settled at Barotiwala, Himachal Pradesh, India. The university course of study points on undergraduate and postgraduate engineering and business management subjects. The fie...
  • SIDCUL Pantnagar
    Introduction SIDCUL, a Government of Uttarakhand Enterprise, was contained as a Limited Company in the year 2002 with an approved allotment of Rs. 50 Crores and Rs. 20 Crores paid up capital by Government of Uttarakhand in order to encourage Industrial growth in the State, offer financial aid in th...
  • FMGE questions
    FMGE 2011 questions FMGE is a screening Test Direct the course of; manage or control for those Indian citizens possessing a primary medical qualification awarded by any medical institution outside India. The exam consists of one paper Separated into parts in two parts having only objective type que...
  • Mean Platelet Volume
    Mean Platelet Volume Mean platelet volume (MPV) is a measurement of the average size of platelets determined in blood and is generally included in blood tests. Since the mean platelet size is bigger when the body is developing increased numbers of platelets, MPV test results can be utilized to crea...
  • Aurangabad University MA Syllabus
    Aurangabad University MA Syllabus Dr. Babasaheb Ambedkar Marathwada University (“BAMU”) is settled in Aurangabad, Maharashtra, India. BAMU was founded as "Marathwada University" in 1958. Objective of Dr. Babasaheb Ambedkar Marathwada University is to disseminate create and maintain knowledge and ...