Chris Pollett> Old Classses >
CS157a

( Print View )

Student Corner:
[Submit Sec4]
[Grades Sec4]

[Lecture Notes]
[Discussion Board]

Course Info:
[Texts & Links]
[Description]
[Course Outcomes]
[Outcomes Matrix]
[Course Schedule]
[Grading]
[Requirements/HW/Quizzes]
[Class Protocols]
[Exam Info]
[Regrades]
[University Policies]
[Announcements]

HW Assignments:
[Hw1] [Hw2] [Hw3]
[Hw4] [Hw5] [Quizzes]

Practice Exams:
[Midterm] [Final]

Learning Outcomes versus Collected Course Materials
CLO1CLO2CLO3CLO4CLO5N/A
HW1X
HW2XXX
HW3X
MT1P1X
MT1P2X
MT1P3X
MT1P4X
MT1P5X
HW4XXXX

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.