1. The first sub-bullet point above gives clues as to which tables you will; need in your
database.
- How many tables will you need?
2 tables
2. The bullet point above tells you which data entry forms you will need for your database.
- How many data entry forms will you need?
2
3. The sub-bullet points at the bottom of page 27 tell you which queries and reports you will
need for your database.
- How many queries will you need to create?
2
- How manty reports will you need to create?
3
, 1. Look at the table of data on page 29. Identify two types of repeating data. The first one has
been done for you.
a- Customer
b- Customer address
2. Write down the attributes (fields) which belong to each item of repeating data. The first two
have been started for you. You may not need all the boxes.
Customer
Customer address
3. Check if all the fields in these two tables are atomic. List any fields which are not atomic, and
list the fields they should be split into.
database.
- How many tables will you need?
2 tables
2. The bullet point above tells you which data entry forms you will need for your database.
- How many data entry forms will you need?
2
3. The sub-bullet points at the bottom of page 27 tell you which queries and reports you will
need for your database.
- How many queries will you need to create?
2
- How manty reports will you need to create?
3
, 1. Look at the table of data on page 29. Identify two types of repeating data. The first one has
been done for you.
a- Customer
b- Customer address
2. Write down the attributes (fields) which belong to each item of repeating data. The first two
have been started for you. You may not need all the boxes.
Customer
Customer address
3. Check if all the fields in these two tables are atomic. List any fields which are not atomic, and
list the fields they should be split into.
