ER-Diagrams to MS Access

Question 1

List the 3 main steps to convert ERD to a Database.

Answer 1

1. Create each table (with attributes and appropriate data types.
2. Create the relationships (using the relationship table)
3. Fill in (populate) the data.

Question 2

Define referential integrity.

Answer 2

Ensuring the data in a relational database maintains consistency when the data changes. This is achieved through the proper use of primary and foreign keys.

Question 3

How do you establish referential integrity in MS Access?

Answer 3

Click the “Enforce Referential Integrity” button.

Question 4

How should the primary key be stored?

Answer 4

As an autonumber, which uses the Long Integer data type.

Question 5

How should foreign keys be stored?

Answer 5

As Long Integers.

Question 6

What is normalization?

Answer 6

Converting un-normalized tables into two or more tables. Changes from poorly structured to well-structured databases.

Question 7

What are the effects of normalized tables?

Answer 7

1. Eliminates data duplication
2. Slower to process
3. Every table has a single topic

Question 8

What do forms do?

Answer 8

Read, insert, modify and delete data.

Question 9

What do reports do?

Answer 9

Shows data in structured way, also able to compute some values.

Question 10

What do queries do?

Answer 10

Find answers to questions regarding data.

Question 11

Briefly describe metadata/

Answer 11

Data that describes data, makes databases more useful and easier to use.