Describe the relationship between the database and DBMS. 

Q2: What is the purpose of conceptual database modeling? 

Q3: What is metadata? 

Q4: What is the purpose of ER modeling? 

Q5: What is depicted by cardinality constraints? 

Q6: Why an associative entity construct is added to an ERD? 

Q7: Using the AIRPORT KLX Table (Textbook page 131), describe an example that illustrates the insertion anomaly. 

Q8: Using the AIRPORT KLX Table (Textbook page 131), describe an example that illustrates the deletion anomaly. 

Q9: Using the AIRPORT KLX Table (Textbook page 131), describe an example that illustrates the modification anomaly. 

Q10: Structured Query Language (SQL): What is the purpose of DDL, DML, and DCL? 

Q11: What is the goal of optimizing database performance? List 3 actions that can be taken to improve database performance. 

Q12: What are the three basic OLAP/BI tool features? 

Q13: What is the purpose of an Index? 

Q14: What is the purpose of database front-end applications? 

Q15: What are the roles of Fact and Dimension tables in the STAR schema?