Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

(4 pts) An educational institution stores information about students, classes, a

ID: 3877360 • Letter: #

Question

(4 pts) An educational institution stores information about students, classes, and grades. State whether each of the following represents data or metadata (if it represents data, state whether it is structured or unstructured data). If it represents metadata, state whether it is a fact describing a property of data or a fact describing the context of data. Remember that metadata is data about data, like the length of a field, or if the field is optional or mandatory.

a) Students name and address.

b) Grades for a course offered in database design.

c) The resolution of a student’s ID photo in pixels.

d) Length of the course number field.

Explanation / Answer

We have 3 types of data in an organization: Structured, Unstructured, semi-structured.

The data associated with database is called "Structured" data. This data will be stored and seek in defined format. We store data in database Tables.

The data associated with wordexcelpdfmusic files data i.e. everything which is not in database is "Unstructured" data. we will analyze or retrieve data from these based on file names.

The combination of "Structured" and "Unstructured" data is "semi-structured" data. for ex, mail application stores emails as a file.

Metadata is data that describes other data. It summarizes basic information about data, which can make finding and working with particular instances of data easier.

a) Students name and address. (it represents Data and can be stored in a database Table for reporting so answer is "Structured Data")

b) Grades for a course offered in database design. (it represents Data and can be stored in a database Table for reporting so answer is "Structured Data")

c) The resolution of a student’s ID photo in pixels.(it can be stored so answer is "Structured Data")

d) Length of the course number field. (Length describes the field size of the course number field so answer is "Metadata describing Property of the data")