Chapter 2:

What is an Entity?

Describe the difference between required and optional attributes.

What is a composite attribute?

Describe and explain Relationships.

What are Primary Keys?

What are Foreign Keys?

What is the Entity integrity rule?

What is referential integrity?

Explain cardinality and the different types.

What is an associative entity?

Composite Keys are described as what?

Describe the difference between Unary vs. binary vs. ternary

What is a derived attribute?

What is a simple attribute?

Chapter 3:

Describe the supertype/subtype hierarchy

What is a subtype?

Do subtypes that are lower in the hierarchy inherit attributes not only from their immediate supertype but also from all supertypes higher in the hierarchy all the way to the root?

When should subtypes be used?

A subtype can only have one supertype

Describe Specialization and generalization.

Describe Total and Partial specialization.

Describe disjoint and overlap rules.

Chapter 4:

What is an anomaly and what are the different types?

What are the six different normal forms? How do we get to 3NF?

A two dimensional table of data is a(n)?

What is the difference between a synonym and homonym?

Explain the concept of denormalization.

Chapter 5:

Describe the process of selecting a datatype.

What is blob?

What is a Derived attribute?

Explain partitioning and indexing.

Chapter 6:

When preparing to create a table, one should:

What is the purpose of the SQL standard?

What are the three classes or types of SQL commands?

What does * do in SQL?

Describe and explain the SELECT clause, FROM clause, and WHERE clause.

What is the GROUP BY clause and why is it useful?

What is the HAVING clause?

Can you do mathematical operators in SQL?

INSERT INTO is an example of?

DCL is a set of commands used to?

DML is a set of commands used to?

CREATE TABLE is used to?

What is alter table?

What are the standard functions that can be broken down into 4 categories?

A create command may be reversed by a?

What are the steps of execution in SQL (slide 34 in chapter 6).

Identify techniques to help with query writing

What is a subquery?

What is a Join?

Identify times when subqueries and joins are appropriate.

What are the different types of joins? Be able to explain each and how to do them

What is a natural join?

What is a self-join?

What does EXISTS do in a sql statement?

What is a data warehouse? What are the four key factors that make it a data warehouse?

What is the difference between an operational system and an informational system?

Be able to draw, explain, and identify a star schema and the components

What is a departmental data warehouse referred to?

What are the goals of data mining?

How does RFID integrate with data warehouses?

What is ETL? Describe each step and some detail about each step

What are the characteristics of quality data? Why is this so important?

What are data transformations?

What is the difference between static and incremental extracts?

What is TQM?

Explain data scrubbing and you would do data scrubbing

What is an issue with external data sources?

What is a data quality audit? What are some of the tasks associated with it?

What is data propagation?

What is NOSQL? What are some of the focuses?

What are the five Vs of big data? Explain each.

What are the different kinds of stores? Describe each of them.

What are the three levels of analytics? What do you do in each of them?

What are some of the core roles of a database administrator?

What are core roles for a data administrator?

What are factors to consider when choosing an open source DBMS?

What are things to consider when establishing a data security plan?

What is the cause of most security outages?

NOTE

Please add an example after answer, and please answer like (first question than answer, example, than second question and answer etc)