Showing posts with label Class Notes: Database Management System. Show all posts
Showing posts with label Class Notes: Database Management System. Show all posts

All questions in Class Notes - Database Management System

Following is a list of all the question in the section Class Notes: Database Management System. When new class notes will be added, links of those posts will be added to this list too.

Draw the database system architecture. DBMS

Following is a flowchart drawing of Database system architecture.

Who is Database administrator? Write some functions of DBA in DBMS

Database Administrator: One of the main reasons behind using DBMS is to have central control on both data and the applications access those data. The person who has such central control over the data is called a database administrator (DBA). Some of the functions of DBA are given below,

Describe different types of database users and their interfaces. DBMS

There are about 4 different types of database users differentiated by their way of interaction with the database system. Brief description has been given below,

What is transaction? What is Transaction Management? DBMS

Transaction: A transaction is a collection of operations that performs a single logical function in a database application. Such as, when we want to add BDT 500 to account A and subtract BDT 500 from account B, that will be a transaction. 

Briefly describe the two-tier and three-tier architecture. DBMS

Two-tier Architecture: In the two-tier architecture, the application is partitioned into a component that resides at the client machine and calls the database system functionality at the server machine using query language statements. Application program interface standards like ODBC and JDBC are used for interaction between the client and the server. 

Describe the components of the query processor. DBMS

Query Processor: As query is very much necessary to find out only the data user need from tons of data of the database, query processor is very important to process these query requests. Query processors come with the following components,

Describe the data structures implemented by the storage manager.

Data Structures Implemented by the Storage Manager: The storage manager implements several data structures as part of the physical system implementation.

What is storage manager? Describe the components of storage manager. DBMS

Storage Manager: A storage manager is a program module which is responsible for storing, retrieving and updating data in the database. 

In how many ways can database constraints be tested/evaluated? Describe briefly. DBMS

Database Constraints: Database constraints are like conditions given to the manipulation of values of a field or attribute. Such as, we may limit the values under the payment attribute of a table that its value can never be less than BDT 350. Constraints can be tested as follows,

Describe Data Definition Language (DDL). DBMS

Data Definition Language (DDL): The specific language used to express the database schema by a set definitions is called Data Definition Language (DDL). The DDL is also used to specify additional properties of the data. Another special type of DDL, called the Data Storage and Definition Language, is used to specify storage and data access methods.

What are database languages? Describe DML (DBMS)

Database Language: As whatever we want to be manipulated by computer has to be written using specific language, database is not beyond them. To write or create database management system we use database languages. They are of two types; Data Definition Language (DDL) and Data Manipulation Language (DML). DDL is used to design a database and DML is used express database’s queries and updates.

What is data model? Describe various data models. DBMS

Data Model: Data model is the structure of the database, which is a collection of conceptual tools for describing data, data relationships, data semantics and consistency constraints. 

What are instances and schema? DBMS

Instances: A database is generally used by many users where insertion and deletion of data occurs frequently. Overall information stored in a database at a particular moment is called the instance of the database. 

What is data abstraction? Describe the levels briefly. DBMS

Data Abstraction: Different users require different view of the database which is useful and necessary to them. This is data abstraction by which we abstract useful data from a database for a particular type of users to use. 

Briefly describe the disadvantages of file processing system? DBMS

Disadvantages of File Processing System: Keeping organization information in a file processing system has some disadvantages including the followings,

What are the applications of DBMS?

Applications of DBMS: DBMS is getting used in many places. Everything from file cabinets to dictionaries is disappearing from today’s working place, because it is easy to make use of the data using a DBMS. The uses or applications of DBMS include the following,

What is Database? Define DBMS (Database Management System).

Database: A database contains a collection of related items or facts arranged in a specific structure. The most obvious example of a non-computerized database is a telephone directory.