M04 Quiz Take 1

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:23 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 LATEST Attempt 1 26 minutes 18.67 out of 20 Score for this attempt: 18.67 out of 20 Submitted Feb 6 at 10:22pm This attempt took 26 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. Take the Quiz Again 1 / 1 pts Question 1 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

2/6/24, 10:23 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 2/9 0 / 1 pts Question 2 What are the some of the rules of third normal form? A table is automatically in third normal form ou Answered ou Answered Data must be in second normal form Correct! Correct! All integrity constraints are defined ou Answered ou Answered Data most have no transitive dependency Correct! Correct! 1 / 1 pts Question 3 An attribute that contains the firstname, lastname, and middle name would be considered as having multiple values. True Correct! Correct! False 1 / 1 pts Question 4 Data redundancy anomalies are encountered when the same data is stored in multiple database. True False Correct! Correct!

2/6/24, 10:23 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 3/9 1 / 1 pts Question 5 There are six types of data anomalies? True False Correct! Correct! 1 / 1 pts Question 6 As it relates to functional dependency, what does the equation “A,B - -> C” represents? A is the primary key, B is the foreign key which is dependent on the value in column C The combination of values in columns A and B determines the value of column C Correct! Correct! C is the primary key and the columns A and B are determined by the primary key 1 / 1 pts Question 7 A database model is a set of entities and relationships that exist in the real world.

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:23 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 4/9 True Correct! Correct! False 1 / 1 pts Question 8 The goal of normalization is to: Generate a set of relation schemas that allows us to store information without unnecessary redundancy Correct! Correct! Create smaller entities Simplify the joining of two are more tables Establish relationship between one or more entities 0.67 / 1 pts Question 9 What type of anomalies results from data redundancy? Insertion orrect Answer orrect Answer Selection Deletion Correct! Correct! Update Correct! Correct!

2/6/24, 10:23 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 5/9 1 / 1 pts Question 10 In first normal form each field should contain a single (atomic) item True Correct! Correct! False 1 / 1 pts Question 11 What are the some of the rules of first normal form? A table must have no repeating columns Correct! Correct! A table must not contain any repeating groups of attributes Correct! Correct! A table must not contain composite or multi-valued attributes Correct! Correct! Each row of a table must be unique Correct! Correct! A table must have the data type defined 1 / 1 pts Question 12 Normalization is for: Retrieve data is easily Designing relational database schemas Correct! Correct! Select the correct data elements

2/6/24, 10:23 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 6/9 Identify business rule 1 / 1 pts Question 13 What happens if a database is not normalized? Less storage space is required. Performance issues Data redundancy Correct! Correct! Maintenance issues Users access to data is restricted 1 / 1 pts Question 14 Functional dependency can: Enforces the business rules Determine the value of the dependent attribute Correct! Correct! Specify the primary key for the entity 1 / 1 pts Question 15 In which normal form does an attribute that is not fully dependent on the primary key is split into a separate table.

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:23 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 7/9 Third Normal Second Normal Correct! Correct! BCNF First Normal 1 / 1 pts Question 16 You should identify the PK in first normal form True Correct! Correct! False 1 / 1 pts Question 17 What are the some of the rules of second normal form? A database most be in first normal Correct! Correct! A relation must not contain any partial dependency Correct! Correct! Can not contain any transitive dependency Each row of a table must be unique Each table must contain data about one type of thing Correct! Correct!

2/6/24, 10:23 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 8/9 1 / 1 pts Question 18 Functional Dependency occurs: When rows in one table have a dependency of rows in another table. When an entity contains a composite key When a non-key attributes exhibits a dependency on one or more super key attributes. Correct! Correct! 1 / 1 pts Question 19 Advanced phases of normal form includes: DKNF Correct! Correct! 4NF Correct! Correct! 7NF BCNF Correct! Correct! PJNF Correct! Correct! 1 / 1 pts Question 20 Transitive functional dependency occurs when: There are one or more candidate keys

2/6/24, 10:23 PM M04 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401352 9/9 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 Quiz Score: 18.67 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

1_senator_pca - Jupyter Notebook.pdf

Mitigating Risk .docx

Performance Lab 2.docx

Viruses and Malicious Code.docx

Cybercrime Tech:Response .docx

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

Recommended textbooks for you

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

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

Fundamentals of Information Systems

Computer Science

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
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
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning