Intro to database

What is Data?

• Collection of related data organized in a way that can be easily access.

• Information especially facts or numbers, collected through observation

• Data that is being continuously updated and added.

• Software based or hardware based, with one sole purpose, storing data.

How would you describe Database?

• An information when it processed, turning it into something meaningful.

• Allow multiple users to work on it.

• An organized collection of structured information or data that can be easily accessed, managed and updated

• Simple language designed to write commands to access, insert, update and delete data stored

Which of the following is an Open Source DBMS?

• MySQL

• Microsoft SQL Server

• Microsoft Access

• Oracle

DBMS is a collection of ___________ that enables user to create and maintain a database

• Keys

• Program

• Translator

• Language activity

What is mean by processed data?

• Raw data

• Source

• Useful data

• Information.

Which one is the advantage of DBMS?

• Large size

• Complexity

• Minimal data redundancy

• Easy retrieval of application using the Query Language

Which statement support about Data in DBMS component?

• Data is that resource, for which DBMS was designed.

• Data is the program which controls everything

• Data refer to general instructions to use a database management system,

• Data is a simple language designed to write commands.

List the three components of 2-tier DBMS architecture.

• User/Client, GUI/Presentation Layer, DBMS

• User/Client, Application Layer, GUI/Presentation Layer

• User/Client, Basic Layer, DBMS

• User/Client, Application Layer, DBMS

Which one refer to DBMS Database Models above?

• Hierarchical Model

• Network Model

• Entity-relationship Model

• Relational Model

What is Entity?

• Object of relation

• Present working model

• Thing in real world

• Model of relation