Chris Pollett> CS157a
( Print View )

Student Corner:
[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
CLO1CLO2CLO3CLO4CLO5CLO6CLO7CLO8CLO9N/A
HW1XXX
HW2XXXX
HW3XX
MT1XXXX
MT2X
MT3X
MT4X
MT5X
HW4XXXX
HW5XXX

CLO1 (Course Learning Outcome 1) -- Explain basic database concepts, including the structure and operations of the relational data model.

CLO2 -- Identify key components of database management systems and their functions at a high level.

CLO3 -- Conduct normalization to decompose relations into 3NF or BCNF when that removes anomalies.

CLO4 -- Use SQL as a data definition language (DDL) to create and alter databases, tables, views, and indexes

CLO5 -- Use SQL as a data manipulation language (DML) for querying and modifying databases

CLO6 -- Define and use constraints and triggers in SQL

CLO7 -- Describe the concept of transactions

CLO8 -- Build a simple database application in a high-level programming language (e.g., Java and Python) that interacts with a relational database system at the back-end

CLO9 -- Describe one of the well-known data distribution technologies such as replication and partitioning

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