Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 347 Weeks Ago, 6 Days Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Information Systems Posted 14 May 2017 My Price 5.00

List the bookings for which no dateTo has been specified

List the bookings for which no dateTo has been specified. Aggregate functions

 

The following tables form part of a database held in a relational DBMS:

Where Hotel contains hotel details and hotelNo is the primary key; Room contains room details for each hotel and (hotelNo, roomNo) forms the primary key; Booking contains details of bookings and (hotelNo, guestNo, dateFrom) forms the primary key; Guest contains guest details and guestNo is the primary key.

 

Answers

Alpha Geek
(8)
Status NEW Posted 14 May 2017 12:05 PM My Price 5.00

-----------

Attachments

file 1494766285-Answer.docx preview (120 words )
L-----------ist----------- th-----------e b-----------ook-----------ing-----------s f-----------or -----------whi-----------ch -----------no -----------dat-----------eTo----------- ha-----------s b-----------een----------- sp-----------eci-----------fie-----------d. -----------Agg-----------reg-----------ate----------- fu-----------nct-----------ion-----------s -----------The----------- fo-----------llo-----------win-----------g t-----------abl-----------es -----------for-----------m p-----------art----------- of----------- a -----------dat-----------aba-----------se -----------hel-----------d i-----------n a----------- re-----------lat-----------ion-----------al -----------DBM-----------S: ----------- -----------Whe-----------re -----------Hot-----------el -----------con-----------tai-----------ns -----------hot-----------el -----------det-----------ail-----------s a-----------nd -----------hot-----------elN-----------o i-----------s t-----------he -----------pri-----------mar-----------y k-----------ey;----------- Ro-----------om -----------con-----------tai-----------ns -----------roo-----------m d-----------eta-----------ils----------- fo-----------r e-----------ach----------- ho-----------tel----------- an-----------d (-----------hot-----------elN-----------o, -----------roo-----------mNo-----------) f-----------orm-----------s t-----------he -----------pri-----------mar-----------y k-----------ey;----------- Bo-----------oki-----------ng -----------con-----------tai-----------ns -----------det-----------ail-----------s o-----------f b-----------ook-----------ing-----------s a-----------nd -----------(ho-----------tel-----------No,----------- gu-----------est-----------No,----------- da-----------teF-----------rom-----------) f-----------orm-----------s t-----------he -----------pri-----------mar-----------y k-----------ey;----------- Gu-----------est----------- co-----------nta-----------ins----------- gu-----------est----------- de-----------tai-----------ls
Not Rated(0)