CIS209: Final Examination Area of Concentration (FALL 2021/2022)

Chapter 5

  1. Transforming a Data Model into a Relational Design
  2. What is Functional dependency
  3. Learn to identify a Determinant
  4. Learn the Boyce-Codd Normal Form (BCNF)

Chapter 6 (Database Administration and Management)

  1. What does Concurrency control seek to achieve?
  2. What is a logical units of work (LUW)?
  3. Understand and explain the different concurrency issues
  4. Explain how Resource Locking can help prevent concurrency issues
  5. What is the difference between implicit and explicit locks

Chapter 7 (Database Processing in Applications)

  1. Explain triggers and stored procedures
  2. What is the full meaning of the abbreviation API
  3. Mention 2 API interface standards (ODBC and JDBC)

Chapter 7 (Big Data, Data Warehouses, and Business Intelligence Systems)

  1. What Business intelligence (BI)
  2. The two broad categories of BI systems (Reporting systems and data minning applications)
  3. What is the meaning of ETL (Etract transform and load)
  4. What is the difference between a data warehouse and a data mart

Leave a Reply

Your email address will not be published.