Lesson 1 - Review of Theory Database

Question 1

is a collection of logically related data such as name, address, birthday and gender.

Answer 1

DATABASE

Question 2

is the overall design of a database.

Answer 2

SCHEMA

Question 3

is an automated system that enables users to define, create, maintain and control access to the database.

Answer 3

DATABASE SYSTEM

Question 4

Components of a DBMS Environment (5 and in order)

Answer 4

1. HARDWARE
2. SOFTWARE
3. DATA
4. PROCEDURES
5. PEOPLE

Question 5

DML stands for…?

Answer 5

DATA MANIPULATION SYSTEM

Question 6

DBMS stands for…?

Answer 6

DATABASE MANAGEMENT SYSTEM

Question 7

DDL stands for…?

Answer 7

DATA DEFINITION LANGUAGE

Question 8

4 types of Entity Relationships

Answer 8

• ONE TO ONE
• ONE TO MANY
• MANY TO ONE
• MANY TO MANY

Question 9

is divided into logical units called table which is composed of rows and columns of data.

Answer 9

RELATIONAL DATABASE

Question 10

is composed of rows and columns of data.

Answer 10

RELATION

Question 11

In relational database, the table columns correspond to attributes.

Answer 11

ATTRIBUTE

Question 12

refers to a set of valid atomic values for a given attribute.

Answer 12

DOMAIN

Question 13

refers to an attribute or field that serves as a unique identifier for a particular record within a relation.

Answer 13

PRIMARY KEY