Fundamentals of Database System

AND operator displays a record if all the conditions separated by AND are TRUE.

• True
• False

A thing that shares a common attribute.

• ENTITY CLASS

The table is in a 1NF if It satisfies the definition of a relation.

• True
• False

Used to performed or rollback the changes that we made in the database using DML commands.

• Transaction Control Language (TCL)

It is a command used or a request for information from a database.

• QUERY

They are liable for identifying the data to be stored within the database and for selecting appropriate structures to represent and store this data.

• DATABASE DESIGNERS

A single entity instance of one entity class is related to a multiple entity instance of another entity class.

• One-to-Many

The participation of an entity in the relationship is optional.

• Optional

The interface allows users to access their data through their mobile phone or mobile device.

• Applications for mobile devices

Facts that can be recorded and that have implicit meaning.

• DATA

Who is responsible in administering the primary and secondary resource in the database?

• DATABASE ADMINISTRATOR

Records that have matching records from two (2) tables

• INNER JOIN

No primary key can be null.

• True
• False

Display a form to be fill out by the user.

• Forms-based Interfaces

Multi-value dependency

• 4th Normal Form (4NF)

Data model is a collection of concepts that is used to describe the structure of a database.

• True
• False

Each entity instance of one entity class is related to a multiple entity instance of another entity class; and vice versa.

• Many-to-Many

It is between high-level and low-level data models.

• REPRESENTATIONAL OR IMPLEMENTATION DATA MODELS

All possible column values

• Domain

Used to manage data within the object schema.

• Data Manipulation Language (DML)

Use to retrieve data from multiple tables.

• TABLE JOIN

An Expression can be a single constant, column, variable, or scalar function.

• True
• False

Character

• Text

Relationships can't have attributes.

• True
• False

DDL - Schema: databases, tables, views and many more

• True
• False

Use to get aggregation results for different groups of records.

• GROUP BY

maximum of all or selected values

• max

The participation of an entity in the relationship is mandatory.

• Mandatory

Relational Model is a table with columns and rows.

• True
• False

Attribute is a name for a set of similar things that you can list. Like objects, events, people.

• True
• False

It is the number of attributes in a relation.

• DEGREE OF RELATION

NO Transitive Dependency

• 3rd Normal Form (3NF)

Minimum Cardinality describes the minimum number of entity instances that must participate in a relationship.

• True
• False

Data abstraction is the data type, relationships and constraints that apply to the data.

• True
• False

To sort the records in descending order, use the DESC keyword.

• True
• False

Composite Attribute can be calculated from other attributes.

• True
• False

DCL - Use the command: Permissions

• True
• False

Composite attribute can be divided into more attributes.

• True
• False

Numeric

• Integer

An attribute that has a multiple value.

• MULTI-VALUE ATTRIBUTE

OR operator displays a record if any of the conditions separated by OR is TRUE.

• True
• False

Structured Query Language is a command use by relational database management system to perform database operations.

• True
• False

It is a collection of related data.

• DATABASE

It is a question or an inquiry, sometimes loosely used for all types of interactions with databases.

• QUERY

_____ means missing value.

• NULL

Null means zero

• True
• False

Logical Design – transforming the ERD into relational model.

• True
• False

Entity Instance is an instance of a particular entity.

• True
• False

Data Manipulation Language is use for manipulating data in a database.

• True
• False

Used for creating tables, schema etc. in database.

• Data Definition Language (DDL)

Attribute describes an entity class.

• True
• False

DML - Manipulate data using commands: insert, update and delete

• True
• False

minimum of all or selected values

• min

A computerized system that permits users to create and maintain a database.

• DATABASE MANAGEMENT SYSTEM

Compound Conditions use logical operators to filter or connect multiple criteria.

• True
• False

SQL is used to retrieve data from relational databases.

• True
• False

There’s no difference between the description of database and the database itself.

• True
• False

The table is in a 2NF if there's NO Partial Dependency.

• True
• False

People whose jobs require access to the database for querying, updating, and generating reports.

• END USERS

Constraints

• all kinds of keys

Physical data models is a concept that shows how the data is stored on the computer.

• True
• False

Entity Relationship Diagram (ERD) was proposed by _____

• DR. PETER CHEN

Asterisk (*) means all or a list of _____

• COLUMNS

A process of producing a set of tables (relations) with a proper attribute.

• NORMALIZATION

We call the database and DBMS software together as a _____

• DATABASE SYSTEM

sum of all or selected values

• sum

Internal Level describes the physical storage structure of the database.

• True
• False

It is needed when minimum cardinality is optional on a table.

• OUTER JOIN

An Expression can't be a number, columns, literals, functions connected by operators

• True
• False

Entities can be related indirectly by two (2) relationships.

• TRANSITIVE RELATIONSHIP

Used to retrive data and manipulate data

• DML

Database System automatically takes care of backup and recovery.

• True
• False

Columns or expressions can be in the SELECT clause only if they are in the GROUP BY clause.

• True
• False

Tables

• name, primary key

average of all or selected values

• avg

Its is one or more columns of a relation or table that is used to identify a record.

• KEY

SQL is not a Programming Language.

• True
• False

Like Web search engines (engine like Google), which the user can specify a string or any keywords and expect to get a relevant result.

• Keyword-based Database Search

Null means a value is unknown.

• True
• False

Cross Join – Used the foreign key as the matching criteria

• True
• False

The relational model (RM) was first described by Edgar F. Codd

• True
• False

Columns

• name, data type, size, value range

It describes how entities are related to each other.

• RELATIONSHIP

Maximum Cardinality describes the maximum number of entity instances in the relationship.

• True
• False

For each entity instance the value of the identifier attribute is Unique.

• True
• False

Include all qualified records from the left table in the join condition even if they do not have matching records in the right table.

• LEFT JOIN

Is an instance of a particular entity.

• ENTITY INSTANCE

It is a stricter form of 2nd and 3rd normal form

• Boyce Codd Normal Form (BC/NF)

Date

• Time

Use _____ if there is ambiguity when distinguishing a column.

• QUALIFIERS

A displayed schema is called Schema figure.

• True
• False

Row

• Tuples

A single entity instance of one entity class is related to a single entity instance of another entity class.

• One-to-One

A non-key attribute is dependent on part of a composite primary key.

• PARTIAL DEPENDENCY

Used to sort the result.

• ORDER BY KEYWORD

This relationship exists if they are independent or different to each other.

• MULTIPLE RELATIONSHIPS

number of all or selected values

• count

Used to give or control privilege in a database.

• Data Control Language (DCL)

Indirect relationship causes functional dependency.

• TRANSITIVE DEPENDENCY

NO “repeating groups” (columns)

• 1st Normal Form (1NF)

Level of database design use to create database.

• PHYSICAL DESIGN

In SQL the command language used is like an Spanish language.

• True
• False

It is a combination of symbols and operators that returns a single value.

• EXPRESSION

Used to control data access

• DCL

Used to define and modify data structures

• DDL

AND operator displays a record if all the conditions separated by AND are FALSE.

• True
• False

Include all qualified records from both tables in the join condition.

• FULL JOIN

Boolean

• true/false

The interface presents a menu that lead to a user through request.

• Menu-based Interfaces for Web Clients or Browsing

Include all qualified records from the right table in the join condition even if they do not have matching records in the left table.

• RIGHT JOIN

Describes how entities are related.

• RELATIONSHIPS

Table

• Relation

Controlling Redundancy is used to improve the performance of queries.

• True
• False

We use _____ to give column another name.

• ALIAS

DDL used to control data access.

• True
• False

NO Partial Dependency

• 2nd Normal Form (2NF)

Table definition

• Schema of relation

Column header / field

• Attributes

Displays a record if any of the conditions separated by OR is TRUE.

• OR OPERATOR

It is the number of tuples in a relation.

• CARDINALITY OF RELATION