Introduction to Database management

What is database?

• Collection of organized data that allows access, retrieval of  that data.
• Collection of organized data that allows access, retrieval, and use of  that data.
• Collection of organized data that allows retrieval, and use of  that data.

Data is

• collection of processed items
• collection of unprocessed items

Information is

• collection of processed data
• collection of unprocessed data

Why we need database?

• To store  a particular picture
• To store  a particular text
• To store  a particular collection of data.
• To store  a particular audio

Which is the example of File Based System?

• Using MySQL to find specific data
• Using MS Access to control users access
•  Using spreadsheet software to manage data of employee
• Using OpenOffice.org Base to create new table

Why File Based System become unpopular?

• It causes sync with all the data synchronization
• It causes data redundancy

What is Database Management System?

• A software system that enables users to access to the database.
• A software system that enables users to create  access to the database.
• A software system that enables users to define, create, maintain and control access to the database.
•   A software system that enables users to maintain and control access to the database.

Which of the following is NOT Advantages of DBMS

• Increased data consistency 
• Reduced data redundancy
• Improved data security 
• Increase data isolation

Which type of application should you use if you need to store a large quantity of data in an organized format that you can easily query?

• Database
• Presentation
• Spreadsheet
• Word Processor

Column titles are __________________________.

• Field Names

• Records

• Primary Keys

• Foreign Keys