College of Charleston SQL Programming Code


3 attachmentsSlide 1 of 3attachment_1attachment_1attachment_2attachment_2attachment_3attachment_3

Unformatted Attachment Preview

INFM 330 – Exercise 05
Section A: ClassicModels database queries
Use the ClassicModels script and create the database, including its values. Run the queries in
Don’t forget to type in “USE ClassicModels” before running queries!
1. Who are the employees in Boston?
2. Report total payments for October 28, 2004.
3. List the products ordered on a Monday.
4. Which orders have a value greater than $5,000? (Hint: group by having)
5. Which customers are located in Germany?
6. How many customers are located in Germany?
7. List the city and the location of all customers in Germany.
8. How far apart are Stuttgart customers from Berlin customers in km? Hint: Use
ST_AsText(customerLocation); Divide by 1000 in order to get km
9. Create a list that displays the distances in km from Stuttgart to all other cities in Germany that
have customers. Hint: build on the previous
As your deliverable, please submit one .sql file that contains all the SQL queries in OAKS.
Section B: Build a room reservation system in
I would like you to re-create a version of the reservation system with a different tool. Get an account
with Knack. Note that you have only a two-week trial period for this. So make sure you get this all done
before your account expires.
For simplicity, set up the following data model with two entities:
Create a 1:m connection between both that looks as follows:
Go to Pages. Knack has already provided you with some generated Pages. Your goal is to create a
calendar Page, i.e., a page that shows a calendar with varies reservation entries.
Go to this video: (27 minutes)
As your deliverables, please submit one Word file that contains a screen shoot (or two) along with the
answer to the following question: Which tool did you like better (Caspio or Knack)? Tell me why!

Purchase answer to see full

Explanation & Answer:
3 pages




User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

Looking for this assignment?

do my essay homework

Reviews, comments, and love from our customers and community

Article Writing

Great service so far. Keep doing what you do, I am really impressed by the work done.



PowerPoint Presentation

I am speechless…WoW! Thank you so much! Definitely, the writer is talented person. She provided me with an essay a day early before the due date!

Stacy V.

Part-time student

Dissertation & Thesis

This was a very well-written paper. Great work fast. I was in pretty desperate need for help to finish this paper before the due date, which was in nine hours.

M.H.H. Tony


Annotated Bibliography

I love working with this company. You always go above and beyond and exceed my expectations every time. Kate did a WONDERFUL job. I would highly recommend her.

Francisca N.


Book Report / Review

I received my order wayyyyyyy sooner than I expected. Couldn’t ask for more. Very good at communicating & fast at replying. And change & corrections she put in the effort to go back and change it!

Mary J.


Essay (Any Type)

On time, perfect paper. All concerns & matters I had Tom was able to answer them! I will definitely provide him with more orders!

Prof. Kate (Ph.D)


Case Study

Awesome! Great papers, and early! Thank you so much once again! Definitely recommend to trust James with your assignments! He won’t disappoint!

Kaylin Green


Proofreading & Editing

Thank you Dr. Rebecca for editing my essays! She completed my task literally in 3 hours. For sure will work with her again, she is great and follows all instructions

Rebecca L.


Critical Thinking / Review

Extremely thorough summary, understanding and examples found for social science readings, with edits made as needed and on time. It’s like having a tutoring service available (:

Arnold W.



Perfect!I only paid about $80, which i think was a good price considering what my paper entailed. My paper was done early and it was well written!

Joshua W.


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>