David Robbins drobbins

COSC 315 Database Detectives

Name: Kelmy Lemus Date: 28 January 2026

Task Results

Task 0 - AI Paragraph

AI was very helpful with explaining topics that I was not too confident on. It listed a detailed explanation to my questions with multiple examples that helped a lot. Whenever I got stuck with figuring out what data was related to each other I would ask the AI and it would help make connections between the tables. Even though AI was helpful I couldn't depend fully on it because I was the one coming up with the SQL queries to get the data that I wanted.

Task 2 - Inventory the Database

nginx SSL Proxy for Meteor

This configuration file is based on that provided by the HTML 5 Boilerplate group: h5bp/server-configs-nginx @ version 228c5ccc

Usage

Replace all instances of example.com with your domain name in the configuration file.
Replace references to the SSL key and certificate with your files.
Save the configuration (renamed) and SSL files in /etc/nginx/conf.d.
Start or restart nginx (e.g. service nginx restart).

The Question

Collection contains a pair of strings Obj.a and Obj.b, find out the sum of all unique pairs?

Note Obj{a:"abc",b:"xyz"} is equivalent to Obj{a:"xyz",b:"abc"}, although they are two separate documents.

	// ==UserScript==
	// @name BoodleBox Human Message Navigator
	// @namespace http://tampermonkey.net/
	// @version 1.0
	// @description Navigate between human-generated messages in BoodleBox conversations using keyboard shortcuts
	// @author You
	// @match https://boodlebox.com/*
	// @match https://.boodlebox.com/
	// @match https://box.boodle.ai/*
	// @grant none

	(* Customize Review Intervals *)
	using terms from application "OmniFocus"
	property onHoldReviewInterval : {unit:month, steps:1, fixed:false}
	property activeReviewInterval : {unit:day, steps:4, fixed:false}
	end using terms from

	tell application "OmniFocus"
	tell front document
	tell document window 1 -- (first document window whose index is 1)
	set theSelectedItems to selected trees of content

	stream = require "stream"

	class StringifyStream extends stream.Transform
	constructor: ->
	super()
	@_readableState.objectMode = false
	@_writableState.objectMode = true
	_transform: (obj, enc, done) ->
	@push JSON.stringify obj, null, 2
	done?()

	.PHONY=build,clean

	build/scripts.js: src/*.coffee
	coffee --join $@ -c $^

	build: build/scripts.js

	clean:
	rm -rf build/*

	public class AtmMachine {

	Account[] accounts;

	public static void main(String[] args) {

	int command;
	int id;

	for (int i=0; i<10; i++) {

	FROM codenvy/angular-yeoman

	# Change the user ID and group to be compatible with Boot2Docker
	RUN sudo usermod -g staff user && sudo usermod -u 1000 user