CBIS - Test 2 Questions with Complete

CBIS - Test 2 Questions with Complete Solutions 2023/2024 Why isn't excel a great tool with large amounts of complex data? - Correct Answer - Data redundancy

• Data inconsistency
• Hard to answer some questions

data redundancy - Correct Answer occurs when unnecessary duplicate information exists in a database data inconsistency - Correct Answer A condition in which different versions of the same data yield different (inconsistent) results.Primary Key - Correct Answer A field (or group of fields) that uniquely identifies a given entity in a table Foreign Key - Correct Answer A primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables What is a database? - Correct Answer - A self-describing collection of Interrelated, shared, and controlled data

• Can be processed by one or more application systems
• Used to support the activities of a particular organizations
• A representation of some aspect of the real world or a collection of data (facts +

symbols) What is relational database? - Correct Answer - A type of database that stores data in tables

• Each table is composed of rows and columns, similar to a spreadsheet
• Each row of a table has data about a particular occurrence or instance of the of the

entity of interest

• Each column of a table stores a characteristic or attributes common to all rows

What does a relational database store other than data? - Correct Answer Relationships Entity Relationship Diagram (ERD) - Correct Answer A diagram that depicts an entity relationship model's entities, attributes, and relations.What is the first step in creating a database? - Correct Answer Design the database What are some steps to create a design for a database? - Correct Answer - Understand the goal of the how the database will be used

• Identify the data needed as part of accomplishing this goal
• Identify how the data is related to each other
• / 1