File Base System vs Data Management System

Question 1

Composed of application softwares that have access to files?

Answer 1

File Based System

Question 2

File types can either be?

Answer 2

Text or binary

Question 3

How many records we can store in a file?

Answer 3

One

Question 4

How is the application software coded with?

Answer 4

It is coded with data management functions which follows the Data Processing Cycle

Question 5

What seems to be known to the programmer when coding application software in a file based system?

Answer 5

1. File location
2. File type
3. File operation
4. Structure of data in the file
5. How to code instructions to manipulate data

Question 6

What is the user’s view of the application software in a file based system?

Answer 6

1. Files can only be accessed through a software program unless the file is a text file
2. Users cannot share files
3. Only one user can access the file

Question 7

Name the 6 issues about File Base System?

Answer 7

1. Data becomes isolated
2. Dat redundancy and inconsistencies
3. Difficulties to relate data with one another
4. Security in data
5. Difficulties in sharing data among different applications
6. Adding new fields in the file will result to recording of all programs using it even if the program is not going to use it.

Question 8

How can we solve the issues on File Based System?

Answer 8

We use a Data Management System

Question 9

Name 2 components the DBMS usually uses?

Answer 9

1. Database Application
2. Database

Question 10

How does a data management system work?

Answer 10

1. Database application sends instructions to the DBMS
2. The DBMS uses the Database to perform instructions given by the Database Application

Question 11

What is a database?

Answer 11

Can collect files and act as a mode of storing data

Question 12

What does the DBMS use to provide conceptual and logical representation on how data is stored?

Answer 12

Data Model