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

  • Kalasalingam results
    Kalasalingam results Kalasalingam University situated in a serene campus surrounded by scenic mountainous setting at Krishnankoil. Kalasalingam University is located in Krishnankoil near Madurai in Tamil Nadu in India. Result available in its official web site. Kalasalingam University 2010 Res...
  • Gorakhpur University Ba Results
    Introduction Gorakhpur is a teaching and resident-cum-associating college. It is located at a aloofness of about 2 clicks form the business district to the east and nearly taking the air length from railway broadcast station to the south. though the idea of nonresidential college at Gorakhpur was f...
  • Manipur University
    Manipur University Manipur University is located at Canchipur, Imphal, the capital city of Manipur, Manipur University established on June 5, 1980. which is established under the Manipur University Act.1980. this University Act No.54 of 2005 received the ent of theass President on 28/12/2005. . Ma...
  • RMAT Syllabus
    RMAT Syllabus RMAT stands for Rajasthan Management Aptitude Test for Admission in MBA colleges of Rajasthan. This is carried on for the students by Rajasthan Technical University. Rajasthan Technical University was found in 2005 by Govt. of Rajasthan to improve technical education in Rajasthan. Thi...
  • Gauhati University Girls Hostel
    Gauhati University Girls Hostel Gauhati University, the 1st University of North East India, situated in Jalukbari area in the western component Guwahati metropolis, Assam, India the university was accomplished in the year 1948. Gauhati University has as well come with a 5-years Integrated MCOM prog...
  • LNJP Delhi Govt nic
    Introduction is a web site of Lok Nayak Jai Prakash Hospital. Lok Nayak Jai Prakash Hospital is devoted to render quality health care services free of cost without any discrimination to all (except CT Scan, nursing home etc.), As a policy nobody is refused medical care inc...
  • UNI Mysore Ac Results
    Introduction University of Mysore is among the best introductions of its kind, and is an bearing symbol in the sphere of higher education in India. It was set up by the then Maharaja of Mysore, His height Sri Krishna raja Wodeyar IV and his Dewan, the famous individual international leader, Sir M...
  • University Of Jammu Directorate of Distance Education
    Introduction University of Jammu, appointed as 'A' grade University by National cost & accreditation Council of India came into being in 1969 vide Kashmir and Jammu Universities Act 1969 adopting big of the former University of Jammu and Kashmir. University of Jammu-Board of Distance Education,...
  • Jharkhand Board Syllabus
    The Jharkhand Academic Council is also known as Jharkhand Board. It was established for holding and carrying on examinations at the goal of Intermediate, Education, Secondary Education, Sanskrit Education and Madrasa Education and for imposing courses of studies for such examinations and for proposi...
  • Jammu University ETT
    Jammu University ETT The University of Jammu, accredited as 'A' grade University by National Assessment & Accreditation Council of India came into The state or fact of existing in 1969 vide Kashmir and Jammu Universities Act 1969 following bifurcation of the erstwhile University of Jammu and Kash...
  • Orissa Hsc Exam Result
    Orissa Hsc Exam Result 2010 Result Candidate can search their result is by giving role number and by name. Orissa Hsc Exam Result 2010 Result is available in below website ...
  • RBI Grade B Results
    Introduction Reserve Bank of India has published the list of success people based on Phase 1 write out exam that was carried on October 11, 2009. Phase 2 of the write out exam will be carried on January 2 and 3, 2010. Separate letter will be sent to selected candidates. Many of Question Like las...
  • National Institute Of Design Hyderabad
    National Institute Of Design Hyderabad National Institute Of Design is an international institute. National institute of designing offer various courses in designing. It is a public institute was Brought about or set up or accepted; especially long established in 1961 year. The institute functions ...
  • Veer Bahadur Singh Purvanchal University BA Result
    Purvanchal University was renamed as Veer Bahadur Singh Purvanchal University in Jaunpur was founded in 1987. This university provides excellence faculty with good knowledge. This university develops good skills in their students. VBSPU provides UG & PG courses. Result Candidates search thei...
  • Sri Krishnadevaraya University Distance Education
    Sri Krishnadevaraya University had its starting as the Post Graduate centre of Sri Venkateswara University in the year 1968. It was confabbed the status of an associating University in the year 1987.Sri Krishanadevaraya University launched the Centre for Distance Education (CDE) in the academic year...