Objective 1: Differentiate among terms used in Information Management

Question 1

Database management systems (DBMS) are

Answer 1

collections of tools used to manage databases.

Question 2

Four basic functions performed by all DBMS are:

Answer 2

1. Create, modify, and delete data structures, e.g. tables
2. Add, modify, and delete data – Data Manipulation
3. Retrieve data selectively
4. Generate reports based on data

Question 3

A short list of database applications would include:

Answer 3

· Reservation

· Invoicing

· Accounting

· Security

Question 4

Looking from top down, databases are composed of related tables, which in turn are composed of

Answer 4

records

Question 5

What is a Field?

Answer 5

this a single piece of information. It is an area (within a record reserved for a specific piece of data. Examples: customer number, street address, city, current balance etc.

Question 6

Fields are defined by:

Answer 6

1. Field name
2. Data type
3. Character: text, including such things as telephone number
   and address
4. Numeric: number can be manipulated using math operations
5. Date: Calendar dates which can be manipulated mathematical
6. Logical: True or False, Yes or No
7. Field Size – The amount of space reserved for storing data

Question 7

What is a record?

Answer 7

A collection of values for all the fields
pertaining to one entity: i.e., anything that data will be collected on e.g. person, product, company, transaction
etc.

Question 8

What is a Table/ File?

Answer 8

A collection of related records. E.g.
employee table, product table, customer table, student table, flight table etc. In a table, records are represented by rows and fields are represented as columns. In a
relational database a table may be referred to as a relation and a row may be referred to as a tuple.

Question 9

What is Database?

Answer 9

A collection of related tables. It can also incude other objects, such as quiereis, forms and reports. The structure of a database is the relationships between its tables.

Question 10

What is an Entity?

Answer 10

A person, place, or thing on which data will be collected e.g. student, lecturer, product, store

Question 11

What is a Attribute?

Answer 11

a characteristic or property of an entity e.g.
First Name, ID No, Product Code, branch name