MIS UNH EXAM 4 |Questions Solved
100% Correct| Verified Solutions
How can we identify the Right vs the Left? - ANSWER Left is always the parent table
and right is always the child
When to use "Totals" in queries? - ANSWER when there is repetition in the tables
and we need to combine the data into Average, Sum, Count ect.
When to modify join properties in a query - ANSWER *Use joins to limit the records
that you want to see, based on how the data sources are related to each other
*You also use joins to combine records from both data sources, so that each pair
of records from the sources becomes one record in the query results.
What are the difference between table joins in Relationships and Queries? - ANSWER
*In a query, a relationship is represented by a join. When you add tables to a query,
Access creates joins that are based on relationships that have been defined between
the tables.
*You can manually create joins in queries, even if they do not represent relationships
that have already been defined.
First Normal Form (1NF) - ANSWER *Eliminates repeating groups
*Create a seperate table for each set of related data
*Identify each set of related data with a primary key
, Second Normal Form (2NF) - ANSWER *Creates separate tables for sets of values
that apply to multiple records
*Relate theses tables with a foreign key
Third Normal Form (3NF) - ANSWER *Eliminate fields that do not depend on the
primary key (No Transitive Dependancies)
Kludge meaning - ANSWER An awkward or inferior computer system or program that is
created quickly to solve a problem
Anomaly meaning - ANSWER something that deviates from what is standard, normal
or expected
Hard Code meaning - ANSWER Fix (data or parameters) in a program in such a way
that they cannot be altered without modifying the program
*Database queries are not always hard coded*
A table with transitive dependency must have at least how many columns? - ANSWER 3
Cardinality meaning - ANSWER the number of elements in a given mathematical set
*In database design, the cardinality or fundamental principle of one data table
with respect to another is a critical aspect
*In the relational model, tables can be related as any of "one to many" or "many-
to-many." This is said to be the cardinality of a given table in relation to another
Database Administrator's duties include - ANSWER *Schema definition
*Storage structure and access method definition
100% Correct| Verified Solutions
How can we identify the Right vs the Left? - ANSWER Left is always the parent table
and right is always the child
When to use "Totals" in queries? - ANSWER when there is repetition in the tables
and we need to combine the data into Average, Sum, Count ect.
When to modify join properties in a query - ANSWER *Use joins to limit the records
that you want to see, based on how the data sources are related to each other
*You also use joins to combine records from both data sources, so that each pair
of records from the sources becomes one record in the query results.
What are the difference between table joins in Relationships and Queries? - ANSWER
*In a query, a relationship is represented by a join. When you add tables to a query,
Access creates joins that are based on relationships that have been defined between
the tables.
*You can manually create joins in queries, even if they do not represent relationships
that have already been defined.
First Normal Form (1NF) - ANSWER *Eliminates repeating groups
*Create a seperate table for each set of related data
*Identify each set of related data with a primary key
, Second Normal Form (2NF) - ANSWER *Creates separate tables for sets of values
that apply to multiple records
*Relate theses tables with a foreign key
Third Normal Form (3NF) - ANSWER *Eliminate fields that do not depend on the
primary key (No Transitive Dependancies)
Kludge meaning - ANSWER An awkward or inferior computer system or program that is
created quickly to solve a problem
Anomaly meaning - ANSWER something that deviates from what is standard, normal
or expected
Hard Code meaning - ANSWER Fix (data or parameters) in a program in such a way
that they cannot be altered without modifying the program
*Database queries are not always hard coded*
A table with transitive dependency must have at least how many columns? - ANSWER 3
Cardinality meaning - ANSWER the number of elements in a given mathematical set
*In database design, the cardinality or fundamental principle of one data table
with respect to another is a critical aspect
*In the relational model, tables can be related as any of "one to many" or "many-
to-many." This is said to be the cardinality of a given table in relation to another
Database Administrator's duties include - ANSWER *Schema definition
*Storage structure and access method definition
