Database Management System I

(Database) is the software or application that manages databases.

(Database Management System) stores data in a table format.

The (input) in a form of data is processed in an information system to produce information used for decision making of an organization.

During the processing of data, (information) can be passed back to enhance or modify the type of data that is collected and how it is collected.

A DBMS cannot handle many users with good performance.

(Information) is the repository of data.

A DBMS characteristic which makes it realistic and uses real-world entities in designing its architecture is (Relation-based tables).

Multiuser and concurrent access is NOT a DBMS characteristic as it does not support multi-user environment and allows users to manipulate data in parallel.

A RDBMS is equiped with query language which makes more efficient to retrieve and manipulate data.

Database Management System does not offer security to the users or data and does not impose constratints while entering data into the database.

A (Database Designer) is the user who provides user authentication and access in the database in an organization.

The mediator tier which acts as a mediator between the end-user and the database and uses an application or program to access the database is (User) Tier.

A (Entity-Relationship) model defines how the logical structure of a database is modeled. It is the fundamental entities to introduce abstraction in a DBMS.

An entity is an object that has some properties which these properties are also called (relationship).

(Domain) is the logical association among the entities of a database and has three types.