Databases

Question 1

What is Structured Data?

Answer 1

Fixed fields with data types and known meanings. has metadata that describes the data. E.G well-defined databases

Structured data is far easier for a computer to interact with and process becuase the data is arranged in a standard, defined layout

Question 2

What is Unstructured Data?

Answer 2

No discernible structure and no metadata. E.G raw text, as the structure it has may not be explicit

Unstructured data can’t be queried(A request to data) without a transformation

Question 3

What is a database?

Answer 3

A collection of infomation that us organised so that it can be easily accessed, managed and updated

Question 4

What is a table?

Answer 4

Two-dimensional repesentation of data that is stored in rows and columns

Question 5

What is a field?

Answer 5

Single piece of data about an entity

Question 6

What is a record?

Answer 6

The group of fields about a specific entity(aka a row)

Question 7

What is a entity?

Answer 7

An object/person/thing about which data is recorded

Question 8

What is a Key field

Answer 8

In a relational DB, each table should have a primary key which is a field that uniquely identifies each record
Relationships between tables are modelled with shared keys
A field in one table that is a primary in anothertable is called a foreign key
A 1:m relationship is created between a customer and orders