Databases

Question 1

what is a database

Answer 1

A database is a structured collection of related data used to run the activities of a particular organization in the form of tables

Question 2

schema

Answer 2

a description of a database
(meta-data) data about data

Question 3

what is a dbms

Answer 3

a collection of programs that create and maintan the database table

Question 4

Advantages of a DBMS

Answer 4

controls data redundancy
supports multi user access
data integrity

Question 5

Disadvantages of the file-based system

Answer 5

does not promote multi user access
data redundancy
integrity problems

Question 6

advantages of the file based system

Answer 6

simple to use
does not require multi-user use

Question 7

program

Answer 7

A set of instructions that tell the computer what to do

Question 8

process

Answer 8

a instance of a program running in a computer

Question 9

database approach

Answer 9

Modern database which is formally defined as an integrated, self-describing collection of related records organizes into files which are often refered to as database tables/entities/relations