01 - Introduction Into Databases

Question 1

What is a database?

Answer 1

• Collection of records or data
• persistent repository of data
• a collection of related data
• Tool that stores data, and let you create, read, update and delete the data in some manner.

Question 2

What is a DBMS?

Answer 2

Software designed to store and manage databases. To manage huge amount of data.

It provides:

• Data independency and efficient access
• reduce application development time
• data integrity and security
• data administration

Drawbacks:

• Costs of HW/SW and education

Question 3

Examples of DBMS?

Answer 3

• Microsoft SQL Server
• Oracle Database
• PostgreSQL
• MySQL

Question 4

Elements of DBMS?

Answer 4

1. Implementation of a modelling language (e.g. relational data model)
2. Data structures
3. Data query language
4. Transactions

Question 5

Database types?

Answer 5

• Flat file
• Windows System Registry
• Hierarchical DB
• Network DB
• Object DB
• Relational DB
• Multidimensional DB