Session Five: Sketch!

May 3, 2017 - DePaul Entrepreneurship Center

Instructor - Kara

TAs - Jerliyah, Ryan, Nithun, Justin, Oscar

Session Goal:

To determine the data resources needed to build the app. We will use our wireframes, user flows, and other knowledge, to sketch out our database and understand how data is stored.

Session Schedule:

Welcome:

• Confirm TA groups!
• Review:
  • HTML/CSS
    • HTML Syntax: ```
    content </endElement> ``` - CSS Syntax: ``` selector { attribute: value; } ``` - Global Attributes ``` HTML:

    CSS: .classname { } HTML:

    CSS: #idname { } ``` - Font Use ``` HTML(head): HTML(body):

    lalala

    CSS: .fancyFont { font-family: 'Roboto' } ```

  • Discuss Tutorials

Intro to Data:

• Learn about Data Types
  • Strings, Integers, Floats, Boolean, Array, Hash/object
• Activity: From your wireframes and user flows, review all data being input and output. For those inputs and outputs, note what data types would need to be used.

Intro to Javascript:

• Learn about the Console Log
• Learn about Variables
• Intro to Javascript Syntax

Intro to Schemas:

• Learn about Table Relationships
  • Belongs To
  • Has Many
  • Many To Many (join table)
• Activity: Sketch a schema of a popular site.

Homework:

• [ ] In a sketch.md file, write examples of the following concepts/data types we learned
  • String, Boolean, Integer, Float, Array, Object Hash, data vs. information, database relationships (belongs-to, has-many, one-to-one, many-to-many)
• [ ] Sketch a detailed schema of your apps data. Use this DB Template
• [ ] Continue to wireframe and build HTML pages. Ensure that all work is uploaded to github.
• [ ] Complete this Javascript Tutorial Post your work in your github repository!
• [ ] Click through this Interactive Resource on Databases. Do all the activities, Quizes and for MOAR practice, add the definitions for Record, Query, Table and Field to your Internet Dictionary page!

References:

• Try SQL
• Javascript Tutorial
• Using Node.js with NodeSchool