Quiz # 1 Definitions

Question 1

Define Database?

Answer 1

organized collection of logically related data

Allows data IN
Allow information OUT

Question 2

Define Data?

Answer 2

Data refers to factual information.

Stored representations of meaningful objects and events

Data can come in different formats.

Data can be structured or non-structured.

Question 3

Define Metadata?

Answer 3

Data about data(information about data)

Provides context to the data.

Example: if ‘Salary’ for an employee is 65000.

65000 is the data and ‘Salary’ is the context or metadata.

Question 4

Define Information?

Answer 4

Data and Metadata together make Information.

optional:
Data has to be processed in a way that
increases the knowledge of the audience
to become information.

Question 5

Define Conceptual Data Modelling

Answer 5

• Define detailed inventory of data attributes
• Lists all the data categories
• Establishes relations between data categories

Results in conceptual schema that is usually
displayed graphically
(known as the Entity-Relationship Diagram)

Question 6

Define Logical Data Modelling

Answer 6

Transform The conceptual schema to logical schema

Describe data in terms of data management
technology that will be used (i.e relational database)

Transform data to atomic elements through the process of normalization (tune the conceptual model)

Question 7

Define Physical Data Modelling

Answer 7

Describe how data will be stored and managed by the technology (i.e RDBMS)

Responsible for specifications for memory
management, storage layout, data indexing, etc

Results in a physical schema