Toggle navigation
TOC
Project Outline
Deliverables
Presentations
Examples
Data Modeling
Data Modeling Background
What does the term ‘Data Modeling’ mean?
How Relational Databases work
Tables, Columns, Databases, Joins
“3d Normal Form”
Different approaches
Key question is how you correlate the tables in a database with the attributes of a class
Data Modeling
Crucial step in design
SQL vs. NOSQL databases
SQL Databases
Schema
Tables
Fields
Joins
Relationships
One to One (Student <-> Transcript)
One to Many (Student -> Car)
Many to Many (Student <-> Courses)
Careful analysis of the product requirements
Exercise
Team up with one other person
Using what you know about Twitter, propose a data model. Start with for example the “tweets” table where all the tweets will be stored.
15 Minutes, ask questions
Steps
What are the entities?
Is something contained in something else?
How many X’s are there for each Y?
What kinds of facts do we need to know about each entity?
What are the datatypes of those facts? Are there any ‘arrays’?
Possibly identify other entities
Repeat until done
Welcome
2018 Syllabus
Calendar of Lectures and homeworks
Resources
Lectures
Pilot Project
Welcome!
Lean Startup
Hypotheses
Working on Teams
MVP
Guest Lecture: Michael Skok
Pilot Project Conclusion
Term Project: Startup
Welcome to Term Projects!
Build Measure Learn
Project Planning
The Pivot
The Engine of Growth
Mockups & Prototypes
Testing Techniques
Term Project: Product
Product Market Fit
Jeffrey Beir: Metrics
Business Models
Pricing Models
Andy Payne: Startup Finance
Intellectual Property
Term Project: Business
Finance for Geeks
Founding a company
Real World Survival Kit
Management and Leadership
Dulcie Madden: Startup Teams
Last day converstation
Term Project
Term Project Outline
Minimum Viable Product Info
Hypotheses
Final Presentations
Background
Learning Goals
Grading
Teachers
Lexicon
Interesting links
Credits and acknowledgements