Database

Question 1

What is a database?

Answer 1

a collection of data files/lists stored in a computer system that allows user to enter, access and analyze data quickly and easily

Question 2

Field

Answer 2

part of a record in a database (column)

Question 3

Record

Answer 3

a collection of fields (rows)

Question 4

Query

Answer 4

a method used to store and answer questions about information in a database

Question 5

Data types

Answer 5

alphanumeric, numeric, date, logical

Question 6

Relationship

Answer 6

a situation between two database tables when one has a foreign key that references the primary key of the other

Question 7

Primary Key

Answer 7

ensures that only unique records are entered

Question 8

Foreign Key

Answer 8

used to establish relationships between tables

Question 9

Composite Key

Answer 9

a set of multiple attributes that help identify each row in a table uniquely

Question 10

Advantages of a dbms

Answer 10

data redundancy is reduced
greater data integrity
improved data security
data can be backed-up and restored

Question 11

Disadvantages of dbms

Answer 11

to create a good dbms can be time consuming, difficult and complex
moving from traditional systems to dbms can be costly and time consuming