ICT II Test 1

Data models that have been important throughout the history of Databases are the hierarchical model, NoSQl, etc.

It is a type of database where the storage is located in different physical locations with a distributed processing

Are the people whose jobs require access to the database for querying, updating, and generating reports

is a column or a set of columns in a database table that uniquely identifies each record in that table

Refers to any limitation or restriction that affects the design, implementation, or use of technology systems

Is a type of database that organizes data into tables with rows and columns, where data points are related to each other

The data that is stored on a database are managed by a data system that is usually organized by rows and columns.

A foreign key contains values that correspond to values in the primary key of another table.

Relationships are not the associations among the entities.

Is an exact copy of the database kept in a separate location, including a company’s master and transaction data files

An attribute is not a unit fact that characterizes or describes an entity in some way.

Is an organized collection of structured data.

There are different users of a Database system, but one of the most important is the Database Administrator (DBA)?

Contains specific data, like information about a particular employee or a product.

Initials SQL mean – Structured Query Language.

Primary key is not a column or a set of columns that uniquely identifies each row in a table.

One of the objectives of the Database is to allow access to the data at any time.

A process used by companies to turn raw data into useful information

Some examples of database applications are banking, medical, universities, etc.

Is a general-purpose software system that facilitates the processes of defining, constructing, manipulating, and sharing