Skip to content

Latest commit

 

History

History
69 lines (44 loc) · 3.08 KB

content.md

File metadata and controls

69 lines (44 loc) · 3.08 KB
Raw

Database Architecture Practice: Todo List

Let's get some more practice designing databases. This time, we'll design a data model for an app called Todo List.

Todo List

Before you begin, remind yourself of our goal, and our two database constraints.

Then, click around Todo List, another app we might build during this course:

You can sign in with any of the following (all of their passwords are password):

It's aim is simple; it allows you to keep track of the status of your todo list items.

Try to figure out what database tables back this app. In order to test your database design, what questions can you ask? "Are we able to...?"

What tables and columns will you need? Try to produce a complete list of tables and columns.

Imagine that it's a mockup, and that you've been hired to build an app like that. (Don't come up with additional features or improvements; our job is to build it as it is now.)

I find it helpful to use paper or a spreadsheet to actually draw out all my tables, columns, and try entering in rows to make sure I can record everything necessary for all screens and possible user actions that I can see in the mockup.

Todo List: Spreadsheet

Please create a spreadsheet using Google Sheets and share your url. It should be something like this: docs.google.com/spreadsheets/<...>. Make sure anyone with the link can view.

  • Did you create a spreadsheet with the tables, columns, and rows of sample data?
  • Yes
    • Great job!
  • No
    • Please create a spreadsheet before continuing. {: .choose_best #spreadsheet_url title="Todo List: Spreadsheet URL" points="1" answer="1" }

After you submit the URL here, return to Canvas and submit the URL again in the assignment "Todo List: Spreadsheet".

An instructor will provide additional feedback on your submission there.

Todo List: Entity Relationship Diagram (ERD)

Please create an Entity Relationship Diagram (ERD) using the Ideas Tool and share a screenshot.

  • Did you create a entity relationship diagram (ERD)?
  • Yes
    • Great job!
  • No
    • Please create your entity relationship diagram (ERD) before continuing. {: .choose_best #todo_list_erd title="Todo List: Entity Relationship Diagram (ERD)" points="1" answer="1" }

Return to Canvas and submit your screenshot in the assignment "Todo List: Entity Relationship Diagram (ERD)".

An instructor will provide additional feedback on your submission there.

  • Approximately how long (in minutes) did this lesson take you to complete? {: .free_text_number #time_taken title="Time taken" points="1" answer="any" }