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

  • Asia Pacific Institute of Management Reviews
    Asia-Pacific Institute of Management was founded in 1996. This institute ranks between the top Business schools in the Delhi area. This institute provides best education to their students. Asia-Pacific offers AICTE sanctioned full time and part time PGDM programs Specialization is available in the a...
  • Himalaya Medical College Dehradun
    Himalaya Medical College Dehradun The Medical College Himalayan Institute of Medical Sciences was founded in 1995. The medical college is recognized by the Medical Council of India (MCI). The services and staff are as per the averages of the Medical Council of India. The faculty is knew and skil...
  • Gujarat State Petroleum Corporation Share Price
    Gujarat State Petroleum Corporation Share Price The government of Gujarat, which had earlier ordered all its profit-making public sector units (PSUs) to part with 30% of their profit before tax (PBT) for a welfare fund, has made a special provision for Gujarat State Petroleum Corporation (GSPC). Ev...
  • NIT Durgapur MBA
    Introduction National Institute of Technology, Durgapur carries an admission procedure for admission to its two year MBA programme. NIT- Durgapur is a extremely regarded as engineering institute which was founded in 1960 and since then has been a introducing institute in the area of technical teach...
  • Rashtriya Chemicals and Fertilizers Limited RCF
    Introduction Rashtriya Chemicals and Fertilizers as a collective body and Government of India attempting is responsible for to the people of India, the Government as owner, Government as Government, Consumers, Employees, the club at small and generation. . The company is at the same time responsibl...
  • HPCL Recruitment For Freshers
    Introduction Hindustan Petroleum Corporation Limited (HPCL) is a leading “Navratna” Public sphere endeavor employed in downing, dispersion and selling of crude oil productions. HPCL invites applications from entitled MALE campaigners to fill up following spaces at plant, Mumbai HPCL has attempted s...
  • SEBI Act 1992
    Introduction Securities and Exchange Board of India Act, 1992 (the SEBI Act) was improved in the years 1995, 1999 and 2002 to meet the demands of altering needs of the certificates market and answering to the growth in the securities market. Based on the Report of Joint democratic commission (JPC) ...
  • BPSC Patna
    BPSC Patna The Government of Bihar has set up an official website to inform several recruitment activities directed by the Bihar Public Service Commission (BPSC). The Commission releases all the recruitment activities, recruitment results, names of successful Examinees, schedules and venue of writt...
  • Rohilkhand university date sheet
    Rohilkhand university date sheet The Mahatma Jyotiba Phule Rohilkhand University (MJP) Rohilkhand University was Start and new organization or institution in year 1975. This university examination will be commenced from 10th March 2010. MJP Rohilkhand University has announced its exam date sheet ...
  • Manav RACHNA mba
    Manav RACHNA mba Manav Rachana University is come into existence; take on form or shape in 1997. Manav Rachana University offers several professional Management courses to the aspiring candidates. Manav Rachana University provides the MBA courses in Institute of Management Studies which is approved...
  • Deccan College of Medical Sciences
    Introduction Deccan College of Medical Science (DCMS) is a medical college for the Muslim majority located in Hyderabad, Andhra Pradesh extending the course of MBBS. It has an sanctioned intake of 150 seats. The gains of this college are also covered to non-minority students. The Deccan College ...
  • WBUT Question Papers
    Introduction The Govt. of WBUT launches an expert committee on Dec 31, 1998. The WBUT commonly mentioned to as WBUT. The WBUT has been allowed the affiliating University status with its jurisdiction broad the entire state of WBUT. The UTech is set to become a "Center of Excellence" in multidiscipli...
  • IGTC Ltd
    Introduction IGTC Ltd is a long established organization, offering Safety footgear and Work wear to clients during the UK. Based in 2003, the firm is based in Louis. Specializes in safety footgear and clothes the range admit big brands such as Dickies, Snickers, Timberland, Caterpillar and Makita. ...
  • Distance Learning Montessori Training
    Distance Learning Montessori Training ICME Montessori Early Childhood Teacher Training course extending to a Diploma is provided online with a complementary set of course books and handbooks on CD-ROM (a colour-printed version is available at an additional cost). There is a meaningful shortage an...
  • India Tourism Development Corporation Mumbai
    India Tourism Development Corporation Mumbai Mumbai is a city of souls who take over opportunities. This has percolated the zillion tourist guides and tours. You can take your pick or choose to do it all alone. Mumbai, for convenience sake, is separated into 2 parts. The north and the south. As the...