1. Engineering
  2. Computer Science
  3. i have to create a database using mysql workbench editor...

Question: i have to create a database using mysql workbench editor...

Question details

I have to create a database using MySQL workbench editor. You can make up the data!

Hotel The hotel chain operates 500 hotels in 40 states. Primary source of revenue is accommodations in hotel rooms. Each of hotels has between 30 and 500 rooms. There are different types of rooms (standard, suits deluxe) of different sizes (small, medium, and large). Each room may incorporate optional features like refrigerator or kitchenette. The biggest challenge is how to price the rooms of different types. To determine how to price and market room types, analysts need to look at the use of hotel capacities over the time (occupancy rate or utilization rate). Occupancy rate is calculated as the ratio of occupied rooms to the total number of rooms. Some of the rooms can be temporarily unavailable for occupancy (e.g. renovation). So, total number of rooms includes occupied rooms, not occupied rooms, and unavailable rooms. Operational Database: Create databases with detailed information about hotel occupancy oom_Type (Type, Description) Room (Number, Hotel_Id, Type, Size, Number_of_Beds, Bed_Type, Max Occupants, Refrigerator, Kitchenette) Customer (ID, Name, Address) Occupancy (Date, Room Number. Customer ID, Number _Occupants, Number_Days, Daily_Price, Daily_Taxes) Unavailability (Date, Room_Number) Hotel (Hotel Id, H Address, H State) We need to design a data warehouse that will help vice president of Sales and Marketing in pricing the rooms at the maximum the market will bear at close to 100% occupancy. Itrooms arent filling, the Sales Department can modify the pricing or market more aggressively to bring customers in. Our primary objectives are: 1. For any day, allow capacity utilization (occupancy rate) to be analyzed across room types or hotels Over time, allow analysis of average utilization levels for specific hotels or room types For each room type and hotel, capture the revenue for comparison to occupancy level (revenue is calculated as amount customer pays minus all taxes) sure that your design can deliver the following results: (Queries) What was the occupancy rate of for each hotel in Virginia last night? What was last nights occupancy rate for each room type in Virginia hotels? What were the occupancy rates of Virginia hotels for July? What were average room revenues for different hotels during Christmas season Create a Dimensional Model that would allow you to answer the case requirements 2. 4. e an ERD using Visio or any tool you like. It must be neat and complete.)

コHOTEL コROOM ROOM NUMBER INT(11) HOTEL-ID VARCHAR(20) HOTEL ADDRESS VARCHAR(100) HOTEL STATE VARCHAR(2) HOTEL ID VARCHAR(20) ROOM_TYPE VARCHAR(1) ROOM_SIZE VARCHAR(20) NUMBER-OF-BEDS IT(11) BED TYPE VARCHAR(20) MAX OCCUPANTS INT(11) REFRIGERATOR VARCHAR(1) KITCHENETTE VARCHAR(1) コROOM-TYPE 木 ROOM TYPE VARCHAR(1) ROOM DESCRIPTION VARCHAR(20) コUNAVAILABILITY ▼ DATE DATE ROOM NUMBER INT 11) コOCCUPANCY DATE DATE コCUSTOMER ROOM NUMBER INT (11) CUSTOMER ID VARCHAR(20) CUSTOMER ID VARCHAR(20) CUSTOMER NAME VARCHAR(30) CUSTOMER ADDRESS VARCHAR(100) や NUMBER-OCCUPANTS INT(11) NUMBER DAYS INT (11) DAILY-PRICE DECIMAL(62) DAILY-TAXES DECIMAL(52) t

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution