WEEK 1 : Intro to Relational Database

Question 1

What is Data?

Answer 1

A collection of facts, statistics or information in the form of numbers, text, images, sounds or other formats.

Question 2

What is the characteristics of Data?

Answer 2

Structured, unstructured, quantitative, qualitative , primary, secondary, static, dynamic and big data.

Question 3

What is utility?

Answer 3

The value of usefulness of data in its processed or refined form.

Question 4

What are the aspects of utility?

Answer 4

Accessibility, relevance, accuracy, timeliness, completeness, consistency, context, security, privacy, interoperability, scalability, visualization, presentation and data goverence.

Question 5

What is a database?

Answer 5

A structured collection of data that is organized and to be stored in an information system for efficient retrieval, management and manipulation and designed to systematically store and manage data to make it easy to store, access, update and query information.

Question 6

What is Data Abstraction?

Answer 6

A layer that provides separation between the physical implementation of data storage and the way users and applications interact with the data.

Question 7

What is the importance of abstraction?

Answer 7

Data independence, simplified data access, flexibility, adaptability, data security and access control, portability, query optimization, data aggregation and transformation, data integration and ease of maintenance.

Question 8

What is a database system?

Answer 8

A software system designed to manage and facilitate the efficient storage, retrieval, organization and manipulation of data.