DB 1 - Introduction to database

Question 1

What is Filed-based systems?

Answer 1

-Collection of application programs that perform services for the end users
-Each program defines and manages its own data

Question 2

What are the problems with Filed-Based data?

Answer 2

• Separation and isolation of data
• Duplication of data
• Data dependence
• Incompatible file formats
• Fixed queries/Proliferation of application programs

Question 3

What is database?

Answer 3

A collection of related data which allows input, editing and deletion, and can be queried (asked) for patterns, and produce reports and charts

Question 4

What is metadata(system catalogue)?

Answer 4

It provides description of data to enable program-data independence
(in short it means ‘data about data’)

Question 5

What does related data consist of?

Answer 5

Entities, attributes and relationships of an organization’s information

Question 6

What is database management systems (DBMS) ?

Answer 6

A software system that enables users to define, create and maintain the database and that provides controlled access to this database

Question 7

List 5 advantages of DBMS

Answer 7

• Control of data redundancy
• Data consistency
• Improved data integrity
• Improved security
• Improved backup and recovery services

Question 8

List 3 disadvantages of DBMS

Answer 8

• Complexity
• Size
• Cost of DBMS

Question 9

What is the differences between relational and non-relational database?

Answer 9

Relational databases store data in rows and columns form, while non-relational database store data in various form