Intro to Databases

A collection of tables linked together by shared attributes

• Primary Key

• Entity

• Relational Database

• Flat file database

An object about which data will be stored

A property or characteristic of an entity is a/an_______

An attribute that will uniquely identify an instance of an entity

• Entity

• Attribute

• Foreign Key

• Primary Key

Two (or more) attributes which are jointly used to uniquely identify a record

• Composite Primary Key

• Primary Key

• Composite Foreign Key

• Foreign Key

An attribute in one table which is a primary key attribute in another table is a _____ key

A visual method of describing relationships between entities.

• Entity Relationship Diagram

• Flowchart

• Data Flow Diagram

• Drawing

What type of relationship is this?

• One to Many

• Many to Many

• One to One

• Many to One

The process of ensuring that a relational database is structured efficiently is called ________

Normalisation increases data inconsistency

• True

• False