M04 Quiz Take 2

pdf

School

Ivy Tech Community College, Indianapolis *

*We aren’t endorsed by this school

Course

110

Subject

Computer Science

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by MagistrateScorpionPerson5065

2/6/24, 10:36 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 1/9 M04 Quiz Due Feb 10 at 5pm Points 20 Questions 20 Time Limit 60 Minutes Allowed Attempts 2 Instructions Attempt History Attempt Time Score KEPT Attempt 2 12 minutes 19 out of 20 LATEST Attempt 2 12 minutes 19 out of 20 Attempt 1 26 minutes 18.67 out of 20 Score for this attempt: 19 out of 20 Submitted Feb 6 at 10:36pm This attempt took 12 minutes. This assignment takes the format of a quiz over Module 4. This quiz consists of 20 multiple choices, multiple answer, and true-false questions. There is a 30-minute time limit on this quiz, and you will be provided two attempts, the highest score will be kept. This quiz is due by the stated due date. It is suggested that you print the questions, review the chapter, and then come back and enter your answers. 0 / 1 pts Question 1 What is a composite primary key? A primary key consisting of two or more attributes that uniquely identifies each row orrect Answer orrect Answer

2/6/24, 10:36 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 2/9 A primary key consisting of exactly two attributes that uniquely identifies each row ou Answered ou Answered A primary key that has partial dependency on the foreign key 1 / 1 pts Question 2 Functional Dependency occurs: When an entity contains a composite key When a non-key attributes exhibits a dependency on one or more super key attributes. Correct! Correct! When rows in one table have a dependency of rows in another table. 1 / 1 pts Question 3 Normalization will: Eliminate data redundancy Minimize data redundancy Correct! Correct! 1 / 1 pts Question 4 What is normalization?

2/6/24, 10:36 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 3/9 A process used to map data elements to entities in an ERD A set of rules that is used to determine the design of a database schema A process used to reduce data redundancy in relational database Correct! Correct! 1 / 1 pts Question 5 Data redundancy anomalies are encountered when the same data is stored in multiple database. True False Correct! Correct! 1 / 1 pts Question 6 A functional dependency is like a partial key: It uniquely determines the value for some attributes but not all in general. True Correct! Correct! False 1 / 1 pts Question 7 The goal of normalization is to:

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

2/6/24, 10:36 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 4/9 Simplify the joining of two are more tables Create smaller entities Establish relationship between one or more entities Generate a set of relation schemas that allows us to store information without unnecessary redundancy Correct! Correct! 1 / 1 pts Question 8 Normalization is for: Select the correct data elements Identify business rule Retrieve data is easily Designing relational database schemas Correct! Correct! 1 / 1 pts Question 9 As it relates to functional dependency, what does the equation “A,B - -> C” represents? The combination of values in columns A and B determines the value of column C Correct! Correct!

2/6/24, 10:36 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 5/9 A is the primary key, B is the foreign key which is dependent on the value in column C C is the primary key and the columns A and B are determined by the primary key 1 / 1 pts Question 10 There are six types of data anomalies? True False Correct! Correct! 1 / 1 pts Question 11 What are the some of the rules of second normal form? Each table must contain data about one type of thing Correct! Correct! Each row of a table must be unique A relation must not contain any partial dependency Correct! Correct! A database most be in first normal Correct! Correct! Can not contain any transitive dependency

2/6/24, 10:36 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 6/9 1 / 1 pts Question 12 What are the some of the rules of third normal form? A table is automatically in third normal form All integrity constraints are defined Data must be in second normal form Correct! Correct! Data most have no transitive dependency Correct! Correct! 1 / 1 pts Question 13 Data redundancy leads to repetition of data hence extra space is required and anomalies are encountered. True Correct! Correct! False 1 / 1 pts Question 14 You should identify the PK in first normal form True Correct! Correct! False

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

2/6/24, 10:36 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 7/9 1 / 1 pts Question 15 What are the some of the rules of first normal form? A table must not contain composite or multi-valued attributes Correct! Correct! A table must not contain any repeating groups of attributes Correct! Correct! A table must have the data type defined A table must have no repeating columns Correct! Correct! Each row of a table must be unique Correct! Correct! 1 / 1 pts Question 16 What happens if a database is not normalized? Users access to data is restricted Less storage space is required. Maintenance issues Performance issues Data redundancy Correct! Correct! 1 / 1 pts Question 17 In first normal form each field should contain a single (atomic) item

2/6/24, 10:36 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 8/9 True Correct! Correct! False 1 / 1 pts Question 18 Transitive functional dependency occurs when: There are one or more candidate keys One or more non key attributes has a dependency on another super key attribute that was not chosen as a member of the primary key. Correct! Correct! Not all the attributes in a table is fully dependent on the primary key 1 / 1 pts Question 19 A database model is a set of entities and relationships that exist in the real world. True Correct! Correct! False 1 / 1 pts Question 20 Advanced phases of normal form includes:

2/6/24, 10:36 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 9/9 7NF BCNF Correct! Correct! 4NF Correct! Correct! DKNF Correct! Correct! PJNF Correct! Correct! Quiz Score: 19 out of 20

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

Related Documents

Viruses and Malicious Code.docx

Cybercrime Tech:Response .docx

ITN v7 SG SECTION 1 (Modules 1-3).docx

Analysis of the 5 Tickets.docx

M4_L1_ICMP.doc

CS 410 Binary to C++ Activity Template.docx

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag...

Computer Science

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Principles of Information Systems (MindTap Course...

Computer Science

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

Fundamentals of Information Systems

Computer Science

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning