Database Design

What is a database?

• A collection of software programs

• A structured collection of data

• A type of computer hardware

• A way to browse the internet

Answer explanation

A (a)   is an organized collection of data.

Which of the following is a common Database Management System (DBMS)?

• MS Excel

• MS Word

• MS DTP

• MS Access

Electronic databases have several

​ (a)   over manual databases.

• advantages
• misadventures

• advanteges

What is a primary key in a database?

• A special key for opening the database

• A unique identifier for each record in a table

• A key used to lock the database

• A password to access the database

Organize these options into the right categories

Groups:

(a) Currency

,

(b) Text

,

(c) Boolean(Yes/No)

,

(d) Date/Time

• Available

• Street Address

• Amount outstanding

• Last visit

A _______ or label usually displays data for every field of a single record.

• form

• table

• dictionary

• sheet

(a)   is the number of characters allowed in each field.

A ​ (a)   key is a field where each item is unique and must have a value.

• primary
• secondary

• prime

Identify the primary key in the form displayed.

• Address

• Post Code

• Contact ID

• Last Name