ADMN 410 - MIS Exam 2 |Questions Solved
100% Correct| Verified Solutions
Three phases of DBMS Design - ANSWER 1NF
2NF
3NF
Entities vs Tables - ANSWER entities are the things within a table, (first name, last
name...)
Crow's Foot Notation - ANSWER the connections in relationships (one-to-one, one-to-
many, many-to-many)
Cardinality (optional/mandatory) - ANSWER MANDATORY - The relationship of one to
the other must be precise and exact between each other in order to explain how each
table links together.
Flat File - ANSWER -A table/file with no structural relationships between the records
-A file having no internal hierarchy.
Normalization concepts - ANSWER Normalization is a data analysis technique used to
design a database system.
issues with unnormalized tables - ANSWER
Compound Key - ANSWER is a key that consists of two or more simple keys that uniquely
identify an entity occurrence.
, Simple key - ANSWER is one that has only one attribute.
Cascade Delete - ANSWER automatically deletes all records that reference a PK. This
prevents orphaning records
SQL concepts - ANSWER You use SQL to describe sets of data that can help you answer
questions. When you use SQL, you must use the correct syntax. Syntax is the set of rules
by which the elements of a language are correctly combined.
Inner vs Left vs Right table joins - ANSWER
LEFT table vs RIGHT - ANSWER left is primary right is foreign
Know when to use "Totals" - ANSWER instead of showing detail, we can quickly see the
overall stats for the entire table or query
when to modify join properties in a query - ANSWER
difference between table joins in Relationships and Queries
Types of reports - ANSWER
Real World vs Academic World - ANSWER
Hard Code - ANSWER -Hard coded SQL:
Select * from customers where last_name = "Jones";
-SQL with parameters:
100% Correct| Verified Solutions
Three phases of DBMS Design - ANSWER 1NF
2NF
3NF
Entities vs Tables - ANSWER entities are the things within a table, (first name, last
name...)
Crow's Foot Notation - ANSWER the connections in relationships (one-to-one, one-to-
many, many-to-many)
Cardinality (optional/mandatory) - ANSWER MANDATORY - The relationship of one to
the other must be precise and exact between each other in order to explain how each
table links together.
Flat File - ANSWER -A table/file with no structural relationships between the records
-A file having no internal hierarchy.
Normalization concepts - ANSWER Normalization is a data analysis technique used to
design a database system.
issues with unnormalized tables - ANSWER
Compound Key - ANSWER is a key that consists of two or more simple keys that uniquely
identify an entity occurrence.
, Simple key - ANSWER is one that has only one attribute.
Cascade Delete - ANSWER automatically deletes all records that reference a PK. This
prevents orphaning records
SQL concepts - ANSWER You use SQL to describe sets of data that can help you answer
questions. When you use SQL, you must use the correct syntax. Syntax is the set of rules
by which the elements of a language are correctly combined.
Inner vs Left vs Right table joins - ANSWER
LEFT table vs RIGHT - ANSWER left is primary right is foreign
Know when to use "Totals" - ANSWER instead of showing detail, we can quickly see the
overall stats for the entire table or query
when to modify join properties in a query - ANSWER
difference between table joins in Relationships and Queries
Types of reports - ANSWER
Real World vs Academic World - ANSWER
Hard Code - ANSWER -Hard coded SQL:
Select * from customers where last_name = "Jones";
-SQL with parameters:
