Database Management

Question 1

What is a database?

Answer 1

group of related files

Question 2

What is a file

Answer 2

group of records of same type

Question 3

What is a record

Answer 3

group of related fields

Question 4

What is a field

Answer 4

group of characters

Question 5

What are the problems with traditional file environment?

Answer 5

data redundancy (duplicate)
data inconsistency
program-data dependence
lack of flexibility
poor security
lack of data sharing, availability

Question 6

What is a primary key used for

Answer 6

uniquely identify a record

Question 7

What is a foreign key used for

Answer 7

link 2 or more tables or entities together

Question 8

What is a secondary key used for

Answer 8

search records

Question 9

What does normalisation minimise?

Answer 9

minimize redundant data

reduce many to many relationships

Question 10

What is normalisation also known as

Answer 10

streamlining

Question 11

What is referred to when we mention ‘key’

Answer 11

attribute

Question 12

What is the main function of a database

Answer 12

centralise data

Question 13

What are the two designs/views of data in DBMS?

Answer 13

physical

logical

Question 14

What are examples of DBMS

Answer 14

oracle
access
Microsoft SQL
DB2

Question 15

What does DBMS act as an interface between

Answer 15

application and data file

Question 16

What is physical design database arranged for

Answer 16

direct-access storage devices

Question 17

What is the perspective of logical view/ design

Answer 17

business

Question 18

What is the rule to ensure consistent relationship between tables

Answer 18

referential integrity rules

Question 19

Before data becomes useful, what steps must the DBMS perform?

Answer 19

select
join
project