The assignment asks us to create queries using SQL based on the information in the photo. **"Take note that you have also hear the owners plan on purchasing golf courses, casinos and day spas in the near future, all of which carry the Van Whinkle brand name." "

 

You do not need to define primary and foreign keys." 

 

Part 2- it asks us to make one single technical document for your tables, diagrams and SQL scripts. (What does this look like?) 

The sections of the document include TABLE DATA , SQL QUERIES (list each query's name and SQL statements using ANSI SQL). Use only one top level SELECT statement for each query,

DATABASES (screenshots of)- sql server (database design diagram), oracle (database design diagram, table structure), MySQL (database design diagram, table structure).

  

 

You were also handed over the following data scribbles on 8 x 11 pages, napkins, and the backs of customer receipts. They are for one hotel based in London Ontario. Notice that some data is missing. How are you going to handle it? Defaults? Manually entering data? You will need to update your approach & assumptions accordingly. O Bob Smith is the manager of the hotel with 20 years' experience. He makes $80,000 per year and lives in Windsor Ontario. His manager is Deena Donor. Bob Smith is the desk clerk with only 5 years of experience at the hotel. He makes $15 per hour and lives in Toronto Ontario. His manager is the other Bob Smith. o Tanya Duncan does maintenance and has been with the hotel for 10 years. She makes $5,000 per month and lives in London Ontario. Her manager is Bob Smith. o Kristoff Kurn was a customer that reserved a room Jan 3rd and schecked in on Feb 3rd. She checked out on Feb 17th. She paid a deposit of $50 and her room rate per day was $50. She was a smoker so she was charged $25 for smoke damage and $30 for the carpet burns. She lives in Vancouver, British Columbia o Billy Elliot was a customer that reserved a room online the same day he checked in. He checked in on Jan 20th at 4pm. He is a student at Queens University and paid the student discount rate of $30 per day. Because he is a loyal customer he didn't need to pay a deposit. He lives in Toronto. He used to live in Winnipeg Manitoba. O Justin Hackman is in sales and travels back and forth from Detroit and Toronto. Because of his frequent stays at the hotel he doesn't need a reservation and pays a discount rate of $35 per day and a deposit of $20 because he is a smoker. He lives in Woodstock and stayed at the hotel overnight on Feb 2nd, 8th, 17th, and 28th. O Deena Donor is the operation manager of the hotel. She oversees the hotel by coming, in person on the 1st of every month. She has been doing this from January through to April. Because of her position, she is not charged a deposit or room rate. When she does checkout the desk clerk sends the invoice directly to Van Whinkle for reimbursement.