Module 16: Introduction to Databases

What do you understand by ‘Database’?

• Database is an organized collection of related data where the data is stored and organized to serve some specific purpose.

• A spreadsheet such as Excel tables

• Unstructured piles of data

• Text files with neatly tabulated data

The Advantages of relational databases include the following:

• - Physical Storage.

  - Maintenance.

  - Low cost.

  - Data Integrity​.

  - Physical Storage.

   

• - Complex Model​.

  - Increase in performance over time

  -Easy Access to Data​.

  - Complexity in Structure​.

  - Multiple user interfaces.

• - Simple Model​.

  - Data Accuracy​.

  -Easy Access to Data​.

  -Data Integrity​.

  -Flexibility.

• - Simple Model​.

  - Maintenance

  - Easy Access to Data​.

  - Low cost.

  - Physical Storage.

DBMS stands for:

• Database Memory Security

• Database Management System

• Database Management Security

• Database Memory

  System

What is the definition of DBMS?

• It is a collection of application programs. Which allow the users to conduct a variety of actions on it, such as manipulating the data in the database or managing the database structure itself. 

• It is a collection of application programs. Users of the system are can acces the data, but they are NOT able to manipulate the data in the database or managing the database structure itself

Table is another term for:

• Union

• Combination

• Relation

• All of the above are correct

Is a Data type:

• Strings

• Integer

• Character

• All of the above