Database Systems Test CMPE 180B

 
Time and Location:
Fall 2020 TBD

Note: Be sure to arrive early, if you are late for any reason, you will not be allowed to take the test. As exam day and time can be subject to change, check this webpage often for possible updates
 

Test Scope 

  • Database system concepts and architecture 
  • Entity-Relationship (ER) Model, relational data model, and constraints
  • SQL queries, schema modification, views, and triggers 
  • Relational algebra, and ER-to-Relational mapping 
  • Normalization, and functional dependencies 
  • Transaction, concurrency control, and recovery


Reference Textbooks 

R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 7th edition, Pearson, 2015
 
For test rules please click here.