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

  • University Of Rajasthan Syllabus
    University Of Rajasthan Syllabus The University of Rajasthan was established in 1947, This University is regarded one of the oldest institutions of higher finding out in Rajasthan. University of Rajasthan main point is distributing knowledge and providing to the needs of the students of whole Rajas...
  • Bharat Dynamics Limited Tenders
    Introduction Bharat Dynamics Limited was based in the year 1970 to be a creating base for led artillery systems. Its approach into being muses the illusionist sapience of the country to accomplish self-trust in the technical domain. Rose by a pool of talented applied scientist drawn from DRDO and...
  • GITAM University Vishakhapatnam Andhra Pradesh
    Introduction Gandhi Institute of Technology and Management, popularly known as GITAM was based in 1980 by an animated group of high intellects and businessmen of Andhra Pradesh led by Dr. M.V.V.S.Murthi, Former Member of fantan and popular altruist. college on par with the best in the country,...
  • 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...
  • MBA Executive Course, India
    An Executive MBA is specially planned for the working executives to take part in a management program without limiting their career. Executive MBA is also known as EMBA. This program alters executives, business professionals and managers of several organizations to improve their career and look for ...
  • NIT Patna Techfest
    The Technical Society of NIT PATNA plays a key role in nurturing the coming technocrats and enterprisers. The basic need behind this council is to assure that there is a creative ambience in the campus which facilitates the coming up of both advanced solutions and ...
  • One Year Masters In Australia
    In Australia, 42 Australian business schools provide the Master in Business Administration degree. Universities differentiate themselves through earning international accreditation and concentrating on national and international rankings. Most MBAs are one year. Ratings for Australian MBAs are carri...
  • SK University Dumka
    SK University Dumka Sido Kanhu Murmu University or SKMU Dumka, once realized as Siddhu Kanhu University, was founded in 1992. It is located in one of the most backward fields of the country prevailed by the Santhals and the Pahariyas. SKU is joined to the Association of Indian Universities (AIU). S...
  • Rajasthan Atomic Power Station Rawatbhata
    Introduction Rawatbhata is a town and a metropolis in Chittorgarh district in the Indian state of Rajasthan. It is 50 km away from the nearest city Kota. Rawatbhata is associated to the major routes in nation through Kota. Rajasthan Atomic Power Station, India's largest power plant, is situated at ...
  • Veer Bahadur Singh Purvanchal University Time Table
    Veer Bahadur Singh Purvanchal University Time Table Veer Bahadur Singh Purvanchal University was established in 1987. This university structure development, achievement of academic excellence, quality assurance in the higher education and socio-economic development of this highly backward & rur...
  • MIDHANI Recruitment
    MIDHANI Recruitment Mishra dhatu nigam limited manufacture company of Superalloys, Titanium, Special Purpose Steels and other special metals and alloys. It is Government of India contracting Company. Mishra Dhatu Nigam Limited (MIDHANI) extended for recruitment of managers. Jobs Dy.Manager (OL)...
  • PhD in Kakatiya University
    PhD in Kakatiya University Mission of Kakatiya University is to strive constantly to achieve high standards in teaching and research & to carve out a niche for the University imparting higher quality teaching with a holistic approach. The University originally founded as a post-graduate college in...
  • AFIH Admission
    Introduction Associate Fellow of Industrial Health invites all the people for access into Post postgraduate courses. Institute invites all the Dr. to equip them with cognition in occupant wellness for benefit of company. This Course is had in mind for new fields for fresh and actress doctors who ar...
  • IIIT Hyderabad Fest
    Introduction International Institute of Information Technology Hyderabad is an independent establish started in 1998 with seed affirm from the authorities of Andhra Pradesh. It stresses explore from the undergrad level, which makes it unlike from the other following technology establishes in India ...
  • VEL Tech University Avadi
    Introduction Vel Tech Technical University located in Chennai, is a public co-informative University extending a number of courses. The University has abolished state-of-the-art structure and scientific services to assure that the students get the best photograph to face the world with authority. A...