Project 8.0: Given a typical specification document, design a database that can accommodate the described application.
Strangely, life seems back to normal. Actually, better than normal, since you've now enjoyed your first two weeks on the job and that whole hiring process seems like a little silly joke between you and MegaCorp. Funny how a first paycheck of $12,000 can change one's mood.
One morning, Patricia, the department administrator comes to your desk.
"Um, hello," she says, "I'd like to introduce you to Comandante Romero, who has a new project for you. Comandante," she says, turning to the huge man behind her, "this is (your name). And Comandante, you know what we've said about smoking inside -- it's a crime!" she says, walking away.
"Mrrmh," he grunts, "grey jo whe that dribi -- *cough* *cough* -- sorry. Great job with that performance analysis the other day. I've got a new assignment for ya," he says, waving around a huge cigar. "We received a simple specification for a database-backed application from a new client, let's see here, Professor Evil, I believe."
"Oh my goodness, I took his database class at The Mines -- er, I mean, Mines," you say. "I thought after I graduated I could forget all about school and never look back!"
"Well, he's a paying client now," says the Comandante, "and we need you to design the database for this application. Here's the spec doc. Careful, there's an f-bomb in there somewhere," he warns.
"Ah, that's ok. Joe Biden does it all the time!"
Read the provided application specification and create a database schema in either SQLite or MySQL that can accommodate the application.
You will be graded on consistency, choice of data types, and overall design.
You must send me an email with a dump of your schema attached.