Databases

what's a database?

- its a structured collection of data that allows people to extract info easily/to their needs. data can include text, number or pics. 

what is a single table database?

- its 1 table that does not connect to others.

what is a field?

- a single piece of data about something.

what is a record?

- its a collection of fields. 

what is a table?

- it is a collection of records.

What's a relational database?

- A relational database has more than one table and the tables are linked using key fields.

- This data base uses the concept of organising the data into tables, colums and rows.

- each table would be considered a category of data to be stored.

- each  row is a field or attribute; which describes what is being stored about the category.

- a row is an entity, mainly stating  that each row is its own different oblject (containg its own unique data)

whats a primary key?

- its a unique id (a special relational database) designated to uniquely identify all table records. 

the characteristics of a relational…