Module 4

Question 1

Define Database

Answer 1

A set of interrelated centrally coordinated data files that are stored with as little data redundancy as possible.

Question 2

Database Management System

Answer 2

The program that manages and controls the data and the interfaces between the data and the application programs that use the data stored in the database.

Question 3

Advantages of Database Systems

Answer 3

Data integration
Data sharing
Minimal data redundancy / inconsistencies
Data independence
Cross-function analysis

Question 4

Logical View of Data

Answer 4

How people conceptually organise, view and understand the relationship among the data items.

Question 5

Physical View of Data

Answer 5

The way data is physically arranged and stored in the computer system.

Question 6

Define Schema

Answer 6

A description of the data elements in a database, the relationship among them and the logical
model used to organise and describe the data.

Question 7

Types of Schemas

Answer 7

Conceptual-Level Schema
External-Level Schema
Internal-Level Schema

Question 8

Define Data Dictionary

Answer 8

Information about the structure of the database, including a description of each data
element.

Question 9

DBMS Languages

Answer 9

DDL
DML
DQL

Question 10

Data Definition Language

Answer 10

Language that builds the data dictionary, creates the database, describes
logical views, and specifies record or field security restraints.

Question 11

Data Manipulation Language

Answer 11

Language that changes database content, including data element creations, updates, insertions and deletions.

Question 12

Data Query Language

Answer 12

High-level, english like, DBMS language that contains powerful, easy-to-use commands that enable users to retrieve, sort, order and display data.