jokes4miles joke database

BUILDING THE FUNNIESTDATABASE ON EARTH

Starring: Eric Tendian, Emmanuel Ampo,

Mohammad Khan, Safia Abdalla

Visit us at: Northside College Preparatory High School

The Beginning…

What is Jokes4Miles?

Our project is a joke.

Literally.

THE WEBSITE

There’s no better cure than laughter.

THE VISION

OUR PROCESS

THE COMEDIANS

Eric Tendian Safia Abdalla

Mohammad Khan Emmanuel Ampo

Project ManagerLead EngineerSkills: Web Dev, Frontend

Data ScientistSkills: AI, Machine Learning

Business RelationsData ArchitectSkills: Database Design

Relationship ManagerSkills: Management

PROJECT MANAGEMENT

Trello

Google Drive

(+Email)

STARTJanuary 20th, 2013

THE TIMELINE

FINISHApril 1st, 2013

THE CHALLENGES

SCALABILITY

LOTS OF DATA

LIMITED HARDWARE

CONSISTENT CONTENT DELIVERY

NON-PROFITS HAVE A BUDGET

DATABASE DESIGN

Define information requirementsDefine entities

List assumptionsDocument business rules

Define relationships between entitiesCreate the ERD

DATA MODELING

Entities to tablesUnique key to primary key

Attributes to columnsOther implementation details

Test queries

DATABASE IMPLEMENTATION

SITE INTEGRATIONet15.x10.mx/jokes/

OUR SOLUTION

CATALOG JOKES

SORT JOKES

NEXT STEPS

LESSONS LEARNED

What went wrong?

Our ERD had normalization issues.

We had to resolve our many to many relationships.

We had trouble organizing group meetings.

Creating queries to retrieve all necessary information.

Taking what we learned in class and applying it to an actual project.

How to meet deadlines (time management).

To never give up.

What did we learn?

Thank you!

Questions?