Database

Question 1

Relational Database

Answer 1

There exists a relation between databases

Question 2

Non-Relational Database

Answer 2

There does not exist a relation between databases

*Databases do not have to be related

Question 3

Dialects

Answer 3

“Flavours” of database languages

ex) Oracle, MySQL, MicsrosoftSQL

Question 4

_______ are types (What should be contained

Answer 4

Columns

Question 5

_______are the actual entries

Answer 5

Rows

Question 6

Constraints

Answer 6

Additional Modifiers to data

ex) keys, unique requirements

Question 7

Primary Key

Answer 7

Unique Identifying column for a table

Cannot be Null

Question 8

Foreign Key

Answer 8

Reference to another table

Does not strictly have to be referenced to a primary key, but is good practice

Question 9

Composite Key

Answer 9

Primary Key made up of two or more rows

Question 10

Surrogate Key

Answer 10

Value generated solely to become the primary key

Question 11

Multiplicity

Answer 11

Relationship between fields and tables
1-1
1-many
many-many

Question 12

Referential Integrity

Answer 12

All Foreign Keys need to point to something

Question 13

Normalisation

Answer 13

Process of removing redundancies in database

Question 14

Look-Up Table

Answer 14

Essentially joins two tables

Question 15

Entity Relation Diagram

Answer 15

Maps out the relationships between entities in a database