Database Design and Development (Design)

Question 1

What are databases made of?

Answer 1

Databases are made of entities and attributes

Question 2

Entities become tables during implementation. What are entities?

Answer 2

Entities are;

a person
a place
an object
a thing

Question 3

Attributes become fields during implementation. What are attributes?

Answer 3

Attributes are characteristics of entities. Examples of attributes are;

firstName
lastName
address etc.

Question 4

What are Primary Keys (PK)?

Answer 4

Primary Keys are unique identifiers of entities

Question 5

What are Foreign Keys (FK)?

Answer 5

Foreign Keys are what links two or more tables together

Question 6

What is it necessary to show in databases?

Answer 6

Relationships between tables

Question 7

What do data dictionaries do?

Answer 7

Data Dictionaries define the structure of the database

Question 8

What do data dictionaries hold information on?

Answer 8

Data Dictionaries contain;

Names of entities
Names of attributes
Data types of attributes
Size of attributes
Indication of PK's or FK's

Question 9

What are the field types and what do they hold?

Answer 9

Text - holds any character/number
Number - holds only numbers (but not telephone numbers)
Boolean - True/False
Date - stores dates
Time - stores times

Question 10

What are the four types of input validation?

Answer 10

Presence Check
Restricted Choice
Field Length
Range

Question 11

What is a Presence Check?

Answer 11

Presence Checks are pieces of validation which make any data in a field compulsory

Question 12

What is a Restricted Choice?

Answer 12

Restricted Choice limits the amount options a user can input thus cutting down the number of execution errors

Question 13

What is Field Length?

Answer 13

Field Length restricts the amount of characters a field can hold

Question 14

What is Range?

Answer 14

Range makes sure that the numbers inputted are between two extremes

Question 15

What are Queries?

Answer 15

Queries are ways of looking up certain data from a database

Question 16

What do we state when making queries at this level?

Answer 16

Field(s)
Table(s)
Sort Order
Criteria