Database Management

Question 1

Complete this sentence.

“A table that extends another table is called a _____ class, and the table that it extends is called the _____ class.”

Answer 1

“A table that extends another table is called a child class, and the table that it extends is called the parent class.”

Question 2

There are 4 ways tables can be related to each other. What are they?

Answer 2

1. One-to-Many
2. Many-to-Many
3. Database Views
4. Extensions

Question 3

Fill in the blanks for this example to indicate the reference relationship using “Caller” and “User”.

“The ______ field on the Incident table is a reference to a record on the ______ table.”

Answer 3

The Caller field on the Incident table is a reference to a record on the User table.

Question 4

Every field in a record has 3 key attributes.

What are they?

Answer 4

1. Label - user-friendly term (ex. “Last Name”)
2. Name - system-friendly term (ex. “last_name”)
3. Value - actual data (ex. “Hullah”)

Question 5

What is the name of the 32-character, globally unique ID, that is assigned to a record?

Answer 5

sys_id

Question 6

What path in the All Menu allows you to access the System Dictionary?

What key function does this serve?

Answer 6

All > System Definition > Dictionary

This contains the definition for each and every table and field in the database.