Quiz 3 - Summer_ 23SU ISQA3310-850_Managing Database Environment

pdf

School

University of Nebraska, Omaha *

*We aren’t endorsed by this school

Course

3310

Subject

Computer Science

Date

Feb 20, 2024

Type

pdf

Pages

13

Uploaded by DoctorPowerRam32

Report
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 1/13 Quiz 3 - Summer Due Jun 11 at 11:59pm Points 25 Questions 25 Available Jun 5 at 6am - Jun 11 at 11:59pm Time Limit None Instructions This quiz was locked Jun 11 at 11:59pm. Attempt History Attempt Time Score LATEST Attempt 1 42 minutes 19 out of 25 Score for this quiz: 19 out of 25 Submitted Jun 11 at 10:35pm This attempt took 42 minutes. Quiz 3 covers material presented during weeks 2 and 3 of the summer session. You have one hour to complete this quiz once you begin. This quiz must be completed by 11:59 p.m. on Sunday, of Week 1. A timer is not set, but time will be checked after quizzes are submitted for grading. It consists of 25 multiple-choice/true-false questions. 0 / 1 pts Question 1 In the figure below, the primary key for "Order Line" is which type of key?
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 2/13 Composite orrect Answer orrect Answer Foreign Standard Grouped ou Answered ou Answered 1 / 1 pts Question 2 The entity integrity rule states that: no primary key attribute can be null. Correct! Correct! referential integrity must be maintained across all entities. each entity must have a primary key. a primary key must have only one attribute.
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 3/13 1 / 1 pts Question 3 All of the following are the main goals of normalization EXCEPT: minimize data redundancy. simplify the enforcement of referential integrity. maximize storage space. Correct! Correct! make it easier to maintain data. 1 / 1 pts Question 4 When a table meets the definition of a relation, it is said to be in: first normal form. Correct! Correct! second normal form. Boyce-Codd normal form. third normal form. 1 / 1 pts Question 5 A candidate key must satisfy all of the following conditions EXCEPT: the key must uniquely identify the row.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 4/13 the key must indicate the row's position in the table. Correct! Correct! the key must be nonredundant. each nonkey attribute is functionally dependent upon it. 1 / 1 pts Question 6 The attribute on the left-hand side of the arrow in a functional dependency is the: candidate key. determinant. Correct! Correct! foreign key. primary key. 1 / 1 pts Question 7 A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency. partial key-based partial functional Correct! Correct! cross key merged relation
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 5/13 1 / 1 pts Question 8 A functional dependency between two or more nonkey attributes is called a: partial functional dependency. partial nonkey dependency. transitive dependency. Correct! Correct! partial transitive dependency. 0 / 1 pts Question 9 A table that meets the definition of a relation but has non-key attributes dependent on part of a composite primary key is in which normal form? first orrect Answer orrect Answer second third None of the above. ou Answered ou Answered 1 / 1 pts Question 10 A rule that states that each foreign key value must match a primary key value in the other relation is called the:
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 6/13 referential integrity constraint. Correct! Correct! key match rule. entity key group rule. foreign/primary match rule. 1 / 1 pts Question 11 When normalizing, the goal is to decompose relations with anomalies to produce smaller, well-structured relations. True Correct! Correct! False 0 / 1 pts Question 12 If a table is in 1NF and its primary key is not a composite key, then the table cannot be in 2NF. True ou Answered ou Answered False orrect Answer orrect Answer 1 / 1 pts Question 13
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 7/13 A ________________ key is a system-defined attribute generally created and managed via the DBMS used to uniquely define a row or record in an entity. Surrogate Correct! Correct! Composite Foreign Secondary 1 / 1 pts Question 14 To say that A functionally determines B (A->B) is to say that for every distinct value of B there is exactly one value of A. True False Correct! Correct! 1 / 1 pts Question 15 Based on the contents of the tables shown, does the TRUCK table exhibit referential integrity?
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 8/13 Yes Correct! Correct! No Referential integrity does not apply to these tables. 0 / 1 pts Question 16 Based on the contents of the tables shown, how many foreign keys does the BASE table contain?
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 9/13 1 2 ou Answered ou Answered 3 The BASE table does not have any foreign keys. orrect Answer orrect Answer 1 / 1 pts Question 17 Which of the following are anomalies that can be caused by redundancies in tables? Deletion Insertion Modification
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 10/13 All of the above Correct! Correct! 1 / 1 pts Question 18 A relational database table can have more than one candidate key. True Correct! Correct! False 0 / 1 pts Question 19 Which of the following is a mandatory qualities of a primary key? The value stored will not change over time. ou Answered ou Answered The data type of the value to be stored makes efficient use of storage space. The value stored will be unique for all entity instances The value is guaranteed never to be null. C and D above are both required qualities. orrect Answer orrect Answer 1 / 1 pts Question 20 A foreign key is an attribute in a relation that also is a primary key in another relation.
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 11/13 True Correct! Correct! False 1 / 1 pts Question 21 A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form? First Second Correct! Correct! Third Fourth 1 / 1 pts Question 22 A rule that CANNOT be violated by database users is called a: password. program. constraint. Correct! Correct! view.
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 12/13 1 / 1 pts Question 23 An _____________ entity may be used in the place of a many-to-many relationship (e.g. enrollment), especially when there are attributes that belong to the relationship (e.g. grade) rather than to either of the entities participating in the relationship (e.g. student, class). associative (or composite) Correct! Correct! weak categorization subjective 0 / 1 pts Question 24 Data bases with a very low level of data redundancy are said to be _____________________. normalized poorly designed weak well designed. ou Answered ou Answered Both A and D above. orrect Answer orrect Answer 1 / 1 pts Question 25
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
6/12/23, 8:49 PM Quiz 3 - Summer: 23SU ISQA3310-850:Managing Database Environment https://unomaha.instructure.com/courses/69728/quizzes/238469?module_item_id=2418800 13/13 To what level is the following table normalized? UNF Correct! Correct! 1NF 2NF 3NF BCNF 4NF Because Advisee and Committee_Code contain multi-valued entries, this table is not normalized. Quiz Score: 19 out of 25

Related Documents

Critical Analysis -2.docx
NoSQL_quiz.pdf
Hadoop MapReduce.pdf
Quiz # 2 - Psychodynamic.html
ISSC456_Week4_Project_Paper_Outline_Ocasio_Miguel.doc
ITMG281 Outline.docx
Assignment 01b - Number Systems.pdf
Week 5 domain 3 and 4 reflection.docx
Danyelle TASCCEC.docx
sample_final_solutions.pdf
sample_final.pdf
CSCI 2600 Homework 2.pdf
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS