Database Systems Test CMPE 180B

Time and Location:
Wednesday 01/27 @ 7pm (online location)
 

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.