MIS access Quiz UNH |Questions
Solved 100% Correct| Verified Solutions
*Referential Integrity* - ANSWER Feature that prevents users from entering inconsistent
data. Referential integrity guarantees that the vales entered in a table's foreign key
match values entered in a related table's Primary Key. The 1 connects to the primary
key, and the infinity sign is on the many side. Guarantee the validity of the data from a
design perspective.
Parameter Query - ANSWER Prompts the user for input every time the query is run.
User enters a parameter rather than specific criteria every time the query is run.
Wildcards - ANSWER symbols that represent any character or combination
of characters.
* Represents any collection of characters
? Represents any individual character
Foreign Key - ANSWER A primary key of one table that appears as an attribute in
another table and acts to provide a logical relationship between the two tables
Individual Record Calculation - ANSWER A calculation that involves values from
the fields in a single record.
Group Calculation - ANSWER each calculation involves groups of records
What is a database? - ANSWER -A collection of data organized in a manner that
allows access, retrieval, and use of that data
-Are part of most information systems
-ex. Amazon or a phone book
Solved 100% Correct| Verified Solutions
*Referential Integrity* - ANSWER Feature that prevents users from entering inconsistent
data. Referential integrity guarantees that the vales entered in a table's foreign key
match values entered in a related table's Primary Key. The 1 connects to the primary
key, and the infinity sign is on the many side. Guarantee the validity of the data from a
design perspective.
Parameter Query - ANSWER Prompts the user for input every time the query is run.
User enters a parameter rather than specific criteria every time the query is run.
Wildcards - ANSWER symbols that represent any character or combination
of characters.
* Represents any collection of characters
? Represents any individual character
Foreign Key - ANSWER A primary key of one table that appears as an attribute in
another table and acts to provide a logical relationship between the two tables
Individual Record Calculation - ANSWER A calculation that involves values from
the fields in a single record.
Group Calculation - ANSWER each calculation involves groups of records
What is a database? - ANSWER -A collection of data organized in a manner that
allows access, retrieval, and use of that data
-Are part of most information systems
-ex. Amazon or a phone book
