MIS 582 Quizzes Week 2 4 and 6 Database Concepts

MIS 582 Week 2 Quiz

1. Question: (TCO A) The database elements include _____.
2. Question: (TCO C) A tuple is also known as a _____.
3. Question: (TCO D) In a SQL query, which SQL keyword is used to join two conditions that both must be true for the rows to be selected?
4. Question: (TCO G) An online drugstore, such as Drugstore.com, is an example of a(n) _____.
5. Question: (TCO C) Saying that two attributes are functionally dependent means that _____.
6. Question: (TCO D) Match the following terms to their definitions.
7. Question: (TCO C) Explain denormalization and why it may be appropriate to denormalize a set of tables.
   

   ---

MIS 582 Week 4 Quiz

MIS 582 Quizzes Week 2 4 and 6 Database Concepts

Order 100% plagiarism free essay now

1. Question: (TCO B) Minimum cardinality refers to _____.
2. Question: (TCO B) A composite identifier _____.
3. Question: (TCO C) Each attribute of an entity becomes a(n) _____ of a table.
4. Question: (TCO C) To represent a one-to-many relationship in a relational database design, _____.
5. Question: (TCO C) In relational database design, ID-dependent entities are used to _____.
6. Question: (TCO B) Match the following terms to their definitions.
7. Question: (TCO C) Briefly describe the process of converting an extended E-R model into a relational database design.
   

   ---

MIS 582 Week 6 Quiz

1. Question:(TCO E) Which of the following can only interact with relational database and table-like data structures?
2. Question: (TCO E) The characteristics of an object are called _____.
3. Question: (TCO G) What type of JDBC driver is known as a JDBC-ODBC bridge?
4. Question: (TCO G) PHP is _____.
5. Question: (TCO F) When changing the minimum cardinality on the parent side of he relationship from zero to one, the foreign key _____.
6. Question: (TCO F) Match the following SQL key words with their definitions.
7. Question: (TCO F) When redesigning a database that contains data, how can we check assumptions about functional dependencies?
   

   MIS 582 Quizzes Week 2 4 and 6 Database Concepts

   Order 100% plagiarism free essay now