Skip to content

Instantly share code, notes, and snippets.

View brendalong's full-sized avatar
🌮
It's just a taco

Brenda Long brendalong

🌮
It's just a taco
View GitHub Profile
USE MASTER
GO
IF NOT EXISTS (
SELECT [name]
FROM sys.databases
WHERE [name] = N'StudentExercises'
)
CREATE DATABASE StudentExercises
GO

Pizza Shoppe

An ERD Exercise

The Circle of Crust pizza shoppe is known throughout the town for their delicious, artisanal pizzas. Until now, they have eschewed computers and managed to keep track of orders via pencil and paper, but due to high (largely hipster) demand for their surprisingly expensive pizza, they now need a software system to manager orders.

You are tasked with designing a database to support a pizza order management application. As the shoppe grows more popular the database design will grow in complexity.

You will use https://dbdiagram.io/ to create an ERD that represents your database design.

@askingalot
askingalot / word-processor.md
Created February 24, 2020 21:31
Word Processor

Word Processor

A JavaScript Exercise

The goal of this exercise is to build a simple word processor that runs in a web browser -- a simplified Google Docs.

You should use React to build the application.

Phase One

@askingalot
askingalot / markdown-to-html.md
Last active March 4, 2021 21:22
Markdown to HTML

Markdown to HTML

A JavaScript Exercise

Your task is to build a web application that will display a markdown file as HTML.

The web page should contain a text box, a button and an area to display HTML. When the user enters a URL into the text box and clicks the button, the application should fetch the file at the given URL, interpret it as a markdown file, generate HTML from the markdown file and display the HTML on the page.

To test your code, use the "raw" URL to this gist.

@askingalot
askingalot / my-array-functions.md
Last active November 30, 2020 20:57
My Array Functions

My Array Functions

A JavaScript Exercise

JavaScript arrays are a powerful tool for building complex applications. Along with the ability to store sequential data, the good people at TC39 have given us many useful array methods to make our lives easier. There are methods for modifying, looping over, transforming, sorting, querying and filtering arrays.

While array methods make it a LOT easier to use arrays, most of the things array methods do could be done with more low level JavaScript code. For example, if you wanted to write a function that did the same things as the array filter method, you might write something like this.

function myFilter(array, condition) {
@askingalot
askingalot / please-can-i.md
Last active August 30, 2021 13:38
Please Can I...

Please Can I...

A JavaScript Exercise

All children know the best way to get what they want is to pester their parents until they give in. The smartest children know that for the best results they should vary both their volume and the number of repetitions of their plea.

Your task is to build a web application that will help a child build their plea.

Requirements

Heist Part II

  • Knocking over banks isn't going to be easy. Alarms... Vaults... Security Guards.... Each of these safeguards is something we'll have to handle for a successful heist. First things first. Let's create a Bank class to represent the security we're up against. Give the Bank class the following properties:

    • An integer property for CashOnHand
    • An integer property for AlarmScore
    • An integer property for VaultScore
    • An integer property for SecurityGuardScore
    • A computed boolean property called IsSecure. If all the scores are less than or equal to 0, this should be false. If any of the scores are above 0, this should be true
  • Each type of robber will have a special skill that will come in handy while knocking over banks. Start by creating an interface called IRobber. The interface should include:

@stevebrownlee
stevebrownlee / projectsetup.sh
Last active August 16, 2018 14:45
For NSS students to quickly create basic project structure
#
#!/bin/bash
#
# To create a simple project setup with just an HTML file, a JavaScript file, and a CSS file
# just pass the string "simple" as the first argument
# ex: projectsetup.sh simple
#
# - All source code will be created in the src sub-directory
# - If using json-server, it will be configured and started in the api sub-directory
# - If distributing code, grunt task will be configured to create dist sub-directory