Software Development (CSC 321 2016S) : Outlines

Primary: [Front Door] [Schedule] - [Academic Honesty] [Disabilities] [Email] [FAQ] [Teaching & Learning]

Current: [Outline] [EBoard]

Sections: [Assignments] [EBoards] [Examples] [Handouts] [Outlines]

Reference: [Slack] [Ruby@CodeCademy]

Related Courses: [Rails Tutorial] [CSC 321 2016S @ EdX] [CSC 321 2015S (Davis)] [CSC 321 2015F (Rebelsky)] [CSC 322 2016S (Rebelsky)]

Misc: [SamR] [Glimmer Labs] [CS@Grinnell] [Grinnell] [Issue Tracker]

Outline 10: Modeling, Continued

Held: ,

Back to Outline 09 - Software as a Service. On to Outline 11 - Behavior-Driven Development.

Summary

We continue our exploration of data modeling by looking at a sample Web application.

Related Pages

Overview

A Sample Database Design.
Analysis.
A Revised Design.
Lessons.

Administrivia

Upcoming Work

SaaSBook 8 for Wednesday.
Reading Journal for Wednesday (due Tuesday at 8pm)
- Subject: Reading Journal for Class 11 (Your Name)
- How does Fox and Patterson's presentation of test-driven development compare to your prior experiences with unit testing?
- Choose the most confusing idea from 8.2 - 8.6. Make a serious attempt to explain this idea in your own words. What questions remain?
- Choose the most confusing idea from 8.7 - 8.9. Make a serious attempt to explain this idea in your own words. What questions remain?
- What do you see as the relationship(s) between BDD and TDD? Which do you prefer?
- What do you see as the most important or enduring concept in this chapter overall?
- Citation: Questions are based on journal questions from JLND.

Good Things to Do

Academic

Misc. department stuff
Thursday convo: Hilary Mason '00
Thursday extra: Hilary Mason '00

Peer

Bad Spuds, Continued

Here's one solution to Bad Spuds. We'll take a look at it.

Tables

A Movie table with
- Title
- Rating
- Release Date
- Description
- Reviews
A Reviewer table with
- Name
- Description
- Reviews
A Reviews table with
- Movie Title
- Score
- Reviewer Name
- Description.

Relationships

a one-to-many relationship between movies and reviews
a one-to-many relationship between reviewers and reviews

Analysis

Observation

Is a review just a more complex many-many relationship between reviewers and movies?

Questions

Is this DRY? Why or why not?
What types would you associate with these various fields?
What other fields would you want in each table?
What other tables would you want?
What restrictions would you place on various relationships? (E.g., can the same reviewer review a movie more than once?)

A Revised Data Description

We will build this on the fly.

Lessons

Forthcoming.