Table of Contents
- What is database management system? Write capabilities of database management system.
- Write the advantage and disadvantage of DBMS.
- Write the major components of DBMS.
- What do you mean by File System? Explain
- Write the difference between database system and file system.
- Discuss the problem caused by data redundancies. Can data redundancies be completely eliminated when the database approach is used?
- Write brief notes on instance and schema.
- How does a category differ from a regular shared subclass?
- What is model in DBMS? write different type of models and also explain each.
- Describe the three level architecture of database system.
- What do you mean by logical and physical schemas?
- What is data independence? Write difference between logical data independence and physical data independence.
- What is database language? Explain DML and DDL.
- Write the difference between procedural and non-procedural DMLs.
- Discuss the role of DBA in database management system.
- Define the terms Data abstraction and Data redundancy.
- Write the functions of DBA.
- Explain ER-Model in detail.
- Design an E-R diagram for banking enterprise.
- Explain mapping constraints. Write its types
- Explain mapping constraints. Write its types. What do you mean by a key to the relation ? Explain the differences between super key, candidate key and primary key.
- What is foreign key? What is its purpose.
- Define Generalization , Specialization and Aggregation with a suitable example.
- What do you mean by entity set? What is weak entity and strong entity . Also write the difference between weak and strong entity.
What did you think?
Similar Reads
-
Aggregate function in SQL with Examples
In a Database Management System (DBMS), an aggregate function is a special tool that performs calculations on a set of… -
SQL and Parts of SQL language
SQL is a popular programming language, which is used to manage the relational databases and to perform various operations on… -
Views in Relational Algebra
In SQL, virtual table are considered as views. Like Tables, views also contain rows and columns. We can select the… -
Syntax of following SQL commands: sysdate, to date(), dual table ,to_number, substr() and initcap()
1. SYSDATE Purpose: SYSDATE is a function that returns the current date and time of the database server. Syntax SELECT… -
What is Super key, Candidate key and Primary key?
1. Super Key A super key is an attribute or a set of attributes within a table that uniquely identifies… -
What is Cursor? Difference between Implicit and Explicit Cursor
A Cursor is essentially a temporary work area created in the system memory that comes into play during the execution… -
What is Relational Algebra?
Relational algebra is a formal language used to query and manipulate data stored in relational database systems. It provides a… -
What do you mean by Relational Model? Explain with Example
The relational model is a type of model, which represents how the data are stored in a relational database. In… -
Functions of DBA in DBMS
The role of a Database Administrator (DBA) is to manage and maintain the performance, security, and integrity of a database.… -
What is Data Abstraction and Data Redundancy in DBMS
In the world of data management, two terms often come up: data abstraction and data redundancy. Both play crucial roles…