Description
In CPSC 304, you will learn about modeling data using the relational data model using a systematic step-by-step approach, that starts with the entity-relationship model and then translates the ER design into a relational database schema. Integrity Constraints captured in the ER design as well as those that aren't are then used to refine the design further, minimizing various design anomalies.
You will also learn about how to query a relational database using powerful query languages such as Relational Algebra, Datalog, and SQL.
Going further afield, you will also learn about Data Warehousing, Online Analytical Processing (OLAP), and Data Mining.
You will also learn about how to query a relational database using powerful query languages such as Relational Algebra, Datalog, and SQL.
Going further afield, you will also learn about Data Warehousing, Online Analytical Processing (OLAP), and Data Mining.
General Information
Piazza home:
Off Piazza home (Hazra's section):
Off Piazza home (Laks' section):
| Name | Office Hours | |
|---|---|---|
Laks V.S. Lakshmanan | When? Where? | |
Rachel Pottinger | When? Where? | |
Maggie Chen | When? Where? | |
Eric Secules | When? Where? | |
Kaitlyn Melton | When? Where? | |
Oliver Zhang | When? Where? | |
Samir Marin | When? Where? | |
Kevin Mienata | When? Where? | |
Pouria Lotfi | When? Where? | |
Ben Gee | When? Where? | |
Dylan(Wenqiang) Dong | When? Where? | |
Hazra Imran | When? Where? |