Database Management System I - BSIT - Long Test (Midterm)

The language for managing data in relational database management system.

A category of SQL statement which uses statements such as rollback and savepoint which group DML statements togerther to be executed

SQL category which creates, modifies, deletes database objects is (Data Manipulation Language).

SQL statements such as select, insert, update, and delete belongs to what SQL statement category?

Operators such as less than, greater than or equal, and equal belongs to what?

In (relational) operator AND, if one condition is false, then the result will always be false.

The step in planning a query where the process of finding the fields needed in what relation they contained in.

In planning a query, (pinpoint) is the process where you point out what condition you want to apply in the query.

(Locate) is the process in planning a query which the user check what attribute contains the data needs to be shown.

A model which represents sets of entities with their relationships with each other is (Entity Relationship Diagram)

One building block of ERD which is the object with some properties is (attribute).

In ERD, (relationship) is the logical association among entities and has 3 typical types.

A building block of relationship which has the pipe line, less than, and greater than symbol is?

A type of relationship which is the connection of an entity set connected to ONE entity set.

In mapping entities to a table, the (entity) will become the column names of the table.