File Chap 6

Question 1

hybrid databases that have a relational database framework but data is stored in forms other than a table (classes) – works for both structured and unstructured data.

Answer 1

Object Oriented Database

Question 1

data is broken into multiple tables of related fields which are connected to one another. Best for structured data

Answer 1

Relational Database

Question 2

(not only SQL) each item is stored individually rather than in rows and columns and because it uses more than just SQL it works well with other languages and websites. Best for unstructured data

Answer 2

NoSQL Database

Question 3

establish a broad view of what should be included. The entities. Foundation for logical data models. Relationship among entities .

Used by Business Analyst

Answer 3

Conceptual ERD

Question 4

Brings in the field names

Used by Business Analyst

Answer 4

Logical ERD

Question 5

design blueprint The physical data model is the most granular level of entity-relationship diagrams, and represents the process of adding information to the database. Physical ER models show all table structures, including column name, column data type, column constraints, primary key, foreign key, and relationships between tables.

Used by Database Engineer

Answer 5

Physical ERD

Question 6

A: Tables

B: Records

C: Fields

Answer 6

Components of a Database

Question 7

occurs when the same piece of data is stored in multiple places.

Answer 7

Data Redundancy

Question 8

The unique IDs that identify the records in the database

Answer 8

Keys

Question 8

Managing data accuracy and consistency, including data redundancy risks

Answer 8

Data Integrity

Question 9

states that an FK can’t be entered into a table unless it exists as a PK in the base table. For example, you cannot enter the customer ID into the Orders table if the customer ID does not exist in the Customers table.

Answer 9

Referential Integrity

Question 10

The primary key cannot be null, which means empty.

Answer 10

Entity Integrity