Oracle Homework Help l Project l Oracle Assignment Help Assignment Help | Project | Homework Problem Solution

Oracle Assignment Help l Project l Homework Problem Solution

Hokie Resort Hotels are growing day by day. In both the ERD diagram the hotel wants to store the detail of reservation. There are several different kinds of Oracle assignment help rooms in a hotel complex.  Most are set up for sleeping with Oracle homework solution one or two double beds (which may be regular size, extra-long, queen size, or king size).  Any given room could have two different types of beds.  Some sleeping rooms have a minimal amount of extra space, some have an extra-large Oracle homework help open area with chairs and tables for meeting, etc., or for extra rollaway beds.  All sleeping rooms help with Oracle homework  have toilet and bath facilities, telephone, television, closets, and drawers.  All sleeping rooms are designated as smoking or nonsmoking. A sleeping room is rated according to the number of sleeping guests it can accommodate (assuming adults, with adjustments made for small children).

CREATE table ResortDIM

(C_ResortCode_Rs number (10) not null,

T_ResortName_Rs      varchar(50),

T_RegionID_Rs          number (5) not null,

C_CityName_Rs         varchar(50),

T_ResortName_Rs      varchar(50),

T_StreetAddress_Rs   varchar(100),

T_State_Rs     varchar(20),

C_ZipCode_Rs           number (12,2),

constraint ResortDIM_pk Primary key (C_ResortCode_Rs)

);

A suite consists of a sleeping room with an additional, separated room for meeting or working. However, there is only a single hallway access door to the suite.  If there are separate hallway

access doors to adjacent help with Oracle assignment rooms (whether sleeping rooms or meeting-only rooms), the rooms are considered two separate rooms and can be allocated separately.

 

So from both the database we will create data warehouse oracle project help where we will dimension table and fact table. All dimension tables are connected to fact table with a key.

CREATE table EmployeeDim

(C_EmployeeNumber_Em number (5) not null,

T_EmployeeMiddleName_Em           varchar(50),

T_EmployeeLastName_Em    varchar(50),

T_EmployeeAddress_Em       varchar(100),

I_EmployeePhoneNumber_Em number (10) ,

T_EmployeeRanking_Em       number (4) not null,

T_EmployeeStatus_Em          varchar(20),

constraint EmployeeDim_pk Primary key (C_EmployeeNumber_Em)

);

 

Oracle Assignment Help

The three important questions that management must answer to achieve a competitive advantages in hotel market is to develop a viable customer Oracle sql assignment help retention strategy. For achieving this hotel should have help with Oracle assignment. For a oracle project key to develop such system. achieving this we use data mining techniques. Based on both the ERD diagram I have created these questions. So that it will be easy to retrieve information from data warehouse.

CREATE table RoomDIM

(C_RoomID_MG number (10) not null,

C_LocationID_MG       number (4) not null,

T_SeatingCapacity_MG          number (5) not null,

C_FacilityIDCode_Fa   number (10) not null,

constraint RoomDIM_pk Primary key (C_RoomID_MG)

constraint RoomDIM_fk Foreign key (C_FacilityIDCode_Fa) references FacilityDIM

);

How the customer information will be collected from both the database and stored in Data warehouse make my Oracle assignment. We all the information of customer like their first name, middle name, last  name etc. So have to write a query to select Oracle homework help all information from data warehouse.

We need to know all customer reservation detail that on which date they stay in a resort and which facility they have used their. We need keep these Oracle programming help detail with us for further use and for creating invoice for that customer. To know reservation detail write a query by its date.

CREATE table ReservationFact

(C_RoomReservationNumber_Rr number (10) not null,

C_CustomerID_Rr       number (10) not null,

C_RoomID_MG           number (10) not null,

C_EmployeeNumber_Em       number (5) not null,

C_TimeID_rrv             number (6) not null,

C_ResortCode_Rs       number (10) not null,

constraint ReservationFact_pk Primary key (C_RoomReservationNumber_Rr)

constraint ReservationFact_fk4 Foreign key (C_CustomerID_Rr) references CustomerDIM

constraint ReservationFact_fk Foreign key (C_RoomID_MG) references RoomDIM

constraint ReservationFact_fk2 Foreign key (C_TimeID_rrv) references TimeDim

constraint ReservationFact_fk3 Foreign key (C_EmployeeNumber_Em) references EmployeeDim

constraint ReservationFact_fk4 Foreign key (C_ResortCode_Rs) references ResortDIM

);

All the information of room type and the facility in that rooms should be recorded and we need to know the time  of maintains of that room are done properly or not. All the retail of room in the resort are do my Oracle homework help stored in the database .There are many option in room type suits, single room, double room, etc. A suite consists of a sleeping room with an additional, separated room for help with Oracle homework meeting or working. However, there is only a single hallway access door to the suite.  If there are online experts in Oracle separate hallway access doors to adjacent rooms (whether sleeping rooms or meeting-only rooms), the rooms are considered two separate rooms and can be allocated separately. To know all room detail of the resort with its facility.

/* Medications is a fact table.*/

CREATE table ReservationFact

(C_RoomReservationNumber_Rr                             number (10) not null,

C_CustomerID_Rr                          number (10) not null, /*fk to PatientInfo dimension table */

C_RoomID_MG                               number (10) not null, /*fk to Provider which is Resort or doctor */

C_TimeID_rrv                                                  number (6), /* fK from time dimension table */

C_EmployeeNumber_Em                                                          number (5), /* fK from drug dimension table */

C_ResortCode_Rs                                          number (10),

constraint C_RoomReservationNumber_Rr_pk Primary key (C_RoomReservationNumber_Rr)

);

image

DDL for the Data warehouse schema is attached named DDLcomands.sql. Oracle sql homework help.    

CREATE OR REPLACE PROCEDURE Get_Medications_Facts

 

declare @TimeId int

declare @Month int

declare @Day int

declare @Year int

declare @C_CustomerID_Rr int

declare @C_RoomID_MG int

declare @C_EmployeeNumber_Em int

declare @C_ResortCode_Rs int

 

declare @RevDate

declare @ResortIDNumber int

declare @AmountTaken

declare @TimeTaken

declare @ReservationPric

Oracle Homework Help

User will use these queries to retrieve information from the system. By the use of these queries it become easy to know room detail or reservation detail of any customer.. In the first do my Oracle homework query we have collected the information of customer like their first name, middle name etc so that the Oracle online tutors use will know  proper detail of Oracle questions with answers the customer. And in other query we have retrieve the information of reservation that on which date the Oracle sql homework help respective customer in checked in the resort and how many help with Oracle assignment days they stay and which facility they are using. And in the last query we have retrieve the room detail with all facility which are available in the rooms which can be use used by the customer at what rate.

CREATE table CustomerInfo

(c_CustomerInfo_pi                number (6) not null,

c_corp1CustomerId_Cu         number (6), /* fK from db1 */

c_corp2CustomerId_Cu         number (6), /* fK from db2 */

T_CustomerFirstName_Cu                varchar(100)

T_CustomerMiddleName_Cu                        varchar(100)

T_CustomerLastName_Cu                             varchar(100)

T_CustomerAddress_Cu                                            varchar(200)

I_CustomerPhoneNumber_Cu                                   varchar(13)

constraint c_CustomerInfo_pi_pk Primary key (c_CustomerInfo_pi)

);

CREATE OR REPLACE PROCEDURE Get_CustomerInfo_Dimension

/* There are two Resort operational DBs to merge into the DW.