Week 04: Database Design – ER Modeling & Schema Refinement (under construction)

SLOs for Week 04

Students will be able to…

Add conditional logic to queries using CASE.
Create and understand the view concept using CREATE VIEW and DROP VIEW.
Differentiate between materialized and non-materialized views.
Design ER diagrams to model database structures.
Convert ER models into relational schemas.
Create SQL schemas from conceptual designs.
Identify and resolve redundancy issues in schemas.

Slides, videos, and application exercises

Week 04: Slides

Slides

No readings for Week 4.

Homework 04:

Instructions

Project 04:

Instructions

Exam 1

Exam on Friday during class. Bring your laptop. Content: Weeks 1 - 3.

---
title: "Week 04: Database Design – ER Modeling & Schema Refinement (under construction)"
format: 
  html:
    css: /styles.css
# draft: true
# draft-mode: visible
---

## SLOs for Week 04

Students will be able to...

1.  Add conditional logic to queries using `CASE`.
2.  Create and understand the view concept using `CREATE VIEW` and `DROP VIEW`.
3.  Differentiate between materialized and non-materialized views.
4.  Design ER diagrams to model database structures.
5.  Convert ER models into relational schemas.
6.  Create SQL schemas from conceptual designs.
7.  Identify and resolve redundancy issues in schemas.

## Slides, videos, and application exercises

::::: slide-deck
**Week 04: Slides**

::: slides
[Slides]()
:::

::: reading
No readings for Week 4.
:::
:::::

<!-- ## Homework assignments -->

:::: homework
**Homework 04:**

::: instructions
[Instructions](/hws/hw04.qmd)
:::
::::

<!-- ## Lab -->

:::: lab
**Project 04:**

::: instructions
[Instructions](/projects/proj04.qmd)
:::
::::

::: exam
**Exam 1**

Exam on Friday during class. Bring your laptop. Content: Weeks 1 - 3.
:::