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. Transaction Management: Transaction is a unit of both atomicity and consistency. Thus it …
What is transaction? What is Transaction Management? DBMS Read More »
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. Three-tier Architecture: In three-tier …
Briefly describe the two-tier and three-tier architecture. DBMS Read More »
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, DDL Interpreter: It interprets the DDL statements and records the definitions in data dictionary. DML …
Describe the components of the query processor. DBMS Read More »
Data Structures Implemented by the Storage Manager: The storage manager implements several data structures as part of the physical system implementation. Data Files: It stores the database itself. Data Dictionary: It stores metadata about the structures of the database, in particular schema of the database. Indices: It can provide fast access to data items. It …
Describe the data structures implemented by the storage manager. Read More »
Storage Manager in a Database Management System in DBMS The Storage Manager is a crucial component of a Database Management System (DBMS) that handles the storage, retrieval, and management of data on secondary storage devices. It acts as a bridge between the higher-level components of the DBMS, such as the query processor and transaction manager, …
What is storage manager? Describe the components of storage manager. DBMS Read More »
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, Domain Constraints: Using domain constraints one can …
In how many ways can database constraints be tested/evaluated? Describe briefly. DBMS Read More »
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 …
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 …
What are database languages? Describe DML (DBMS) Read More »
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. The data models can be classified into the following four categories. Relational Model: The relational data model uses a collection of tables to represent both data and the …
What is data model? Describe various data models. DBMS Read More »
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. Schemas: The overall design of a database which includes the data structures, table designing and relation of data from table to …
