ISTM 210 Exam 3 Curtsinger (ch.15-17, speaker 3, access)
Complete Questions and Guide Answers
100% Verified Graded A+
1. An alternate name for Table
Answer: Entity
2. An alternate name for Row
Answer: Record
3. An alternate name for Column
Answer: Field
4. primary key field
Answer: uniquely identifies each record
5. Foreign Key
Answer: A primary key from one table that is used in another table.
,6. Another name for field name
Answer: Attributes
7. two kinds of attributes
Answer: simple and composites
8. simple attribute
Answer: attribute that cannot be broken down any further.
9. composite attribute
Answer: An attribute that can be further subdivided to yield additional attributes.
10. single-valued attribute
Answer: An attribute that can have only one value.
11. Multi-valued attribute
Answer: having the potential to contain more than one value for an attribute
12. null
Answer: if it does not apply it can be left blank
13. stored attribute
Answer: The attribute that is used to derive the exact attribute
14. derived attribute
Answer: An attribute whose values can be calculated from related attribute values.
, 15. Short Text
Answer: data type used to store up to 255 characters and is a good data type for a field that stores small
amounts of text
16. description
Answer: used to describe something like how they always explain where to find the security number on the back of a
credit card
17. Input Mask
Answer: A set of placeholder characters that forces users to enter data in a specific format. EX: SSN
must have proper amount of digits and proper format
18. Database Management System (DBMS)
Answer: A program that lets the user add/delete records, query data, create reports, and get immediate
response from data
19. Advantages of using databases
Answer: -can encrypt with a password
-cheap and easy to install
-allows multiple users at once
-helps prevent redundancy
20. Access Objects
Complete Questions and Guide Answers
100% Verified Graded A+
1. An alternate name for Table
Answer: Entity
2. An alternate name for Row
Answer: Record
3. An alternate name for Column
Answer: Field
4. primary key field
Answer: uniquely identifies each record
5. Foreign Key
Answer: A primary key from one table that is used in another table.
,6. Another name for field name
Answer: Attributes
7. two kinds of attributes
Answer: simple and composites
8. simple attribute
Answer: attribute that cannot be broken down any further.
9. composite attribute
Answer: An attribute that can be further subdivided to yield additional attributes.
10. single-valued attribute
Answer: An attribute that can have only one value.
11. Multi-valued attribute
Answer: having the potential to contain more than one value for an attribute
12. null
Answer: if it does not apply it can be left blank
13. stored attribute
Answer: The attribute that is used to derive the exact attribute
14. derived attribute
Answer: An attribute whose values can be calculated from related attribute values.
, 15. Short Text
Answer: data type used to store up to 255 characters and is a good data type for a field that stores small
amounts of text
16. description
Answer: used to describe something like how they always explain where to find the security number on the back of a
credit card
17. Input Mask
Answer: A set of placeholder characters that forces users to enter data in a specific format. EX: SSN
must have proper amount of digits and proper format
18. Database Management System (DBMS)
Answer: A program that lets the user add/delete records, query data, create reports, and get immediate
response from data
19. Advantages of using databases
Answer: -can encrypt with a password
-cheap and easy to install
-allows multiple users at once
-helps prevent redundancy
20. Access Objects
