Week 1

Question 1

What is a File-Based system?

Answer 1

Collection of application programs that perform services for the end-users.

Each program defines and manages its own data

Question 2

What is a Database System?

Answer 2

Shared collection of logically related data + description, designed to meet needs of an organisation

Question 3

What is the Database Management System (DBMS)?

Answer 3

DBMS is a software system are software systems that allow users to store, retrieve, and run queries on data

Question 4

What are the 4 Roles in he Database Environment?

Answer 4

1. Database Administrator (DBA) - Responsible for implementation and monitoring of the database
2. Database Designer - Identify data, relationships with data, constraints on the data
3. Application Developer - Use programming language to provide required functionality for the end-users
4. End-User - Run applications to perform specific database operations

Question 4

What are 3 Advantages of a DBMS?

Answer 4

1. Data consistency
2. Improved security
3. Sharing of Data

Question 5

What are 3 Disavantages of a DBMS?

Answer 5

1. Complexity - complex pieces of software, require those operating to fully understand them
2. Size Large piece of software which requires large amount of memory
3. Cost of DBMS - DBMS cost varies it i for a single user or a big organisation