CS157a Fall 2019

Learning Outcomes versus Collected Course Materials
	CLO1	CLO2	CLO3	CLO5	N/A
HW1		X
HW2	X	X	X
HW3				X
MT1P1		X
MT1P2	X
MT1P3							X
MT1P4						X
MT1P5						X
HW4	X	X		X	X

CLO1 (Course Learning Outcome 1) -- Write relational algebra queries and predict given a database instance what such a query will return.

CLO2 -- Write SQL commands to create databases, create tables, insert/update/delete/retrieve rows in a common database management system.

CLO3 -- Use a database management system's bulk loader to populate a database.

CLO4 -- Write simple transactions using JDBC and ODBC, or similar programmer interfaces in other languages.

CLO5 -- Know the algorithms for testing if a decomposition is in a given normal form and the algorithms which given a set of functional dependencies can do table decomposition into 3NF or BCNF

N/A -- Important material covered in the course but not directly related to a specific learning outcome.