Resort Reservation

Powerful Essays
Introduction to SQL

| | |

SQL is a standard language for accessing and manipulating databases.

[pic]

What is SQL?

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL is an ANSI (American National Standards Institute) standard

[pic]

What Can SQL do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

SQL Syntax

| | |

[pic]

Database Tables

A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain records (rows) with data.

Below is an example of a table called "Persons":

|P_Id |LastName |FirstName |Address |City |
|1 |Hansen |Ola |Timoteivn 10 |Sandnes |
|2 |Svendson |Tove |Borgvn 23 |Sandnes |
|3 |Pettersen |Kari |Storgt 20 |Stavanger |

The table above contains three records (one for each person)

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Resort Reservation System

    • 462 Words
    • 2 Pages

    THE PHILIPPINES – TAGUIG CAMPUS Project Proposal Resort reservation System Prepared by: Matitu, Ruel Llosa, Emmanuel A. MAAM: ANDONG Professor Project Proposal Project Title: Resort Reservation System Proponents: We the Computer Student’s make this Proposal for the purpose of Easy Access for the information of the Resort Reservation. Target Participants: All Customers that Looking for having…

    • 462 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Web-based Hotel and Resort Reservation System with Virtual Tour A Thesis Submitted to the College of Computer Studies AMA Computer College Santiago Campus Santiago City In Partial Fulfillment of the Academic Requirements for the Degree Bachelor of Science in Information Technology Krista Angelica Miguel Maricris Natalia Suguitan John Angelo Tania October 2012 CHAPTER I PROBLEM AND ITS BACKGROUND This chapter explains the statement of the problem, hypothesis, significance of the study, scope and…

    • 5187 Words
    • 21 Pages
    Powerful Essays
  • Good Essays

    CHAPTER 1 Introduction Hotel & Resort is a place used for relaxation or recreation, attracting visitors for holidays or vacations. Resorts are places, towns or sometimes commercial establishment operated by a single company. An establishment that provides paid lodging on a short-term basis. The provision of basic accommodation, in times past, consisting only of cottages, a room with a bed has largely been replaced by rooms with modern facilities, including en-suite bathrooms and air…

    • 918 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    RATIONALE OF THE STUDY The web has become an opportunity for the marketers to add value to products and services. The phenomenal growth and rising of the popularity of the internet and the World Wide Web has become a key to attract more consumers and businesses to engage the benefits of Electronic Commerce (E-commerce). This E-commerce is sited as any form of business transaction in which the parties interact electronically rather than by physical exchanges or direct physical contact (Aldin, Brehmer…

    • 3744 Words
    • 14 Pages
    Powerful Essays
  • Satisfactory Essays

    Reservations DBA for Baderman Island Resorts Business Requirements Document (BRD) Prepared by: Instructor: H Dater Class: IM/305 Date: 04/06/2014 Table of Contents Revision History 3 1. Assumptions, Constraints, and Dependencies 3 1.1 Related Projects and Dependencies 3 1.2 Assumptions and Constraints 3 2. Business and Customer Requirements 3 2.1 Strategic Business and Customer Requirements 3 3. References 3…

    • 412 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    people are fond of hotel and resorts because these is where we have fun, bond with their family and friends, do some recreational activities and/or just simply enjoy, relax and take a break from those stressful things at work or at school. Kristine Rica Resort is found in Sinasajan, Penaranda, Nueva Ecija owned by Ms. Cristina Pagunsan. Its wide space that covers 15000 square meters can really provide the relaxation that vacationers want for their vacation. The resort consists of 13 rooms; 4 single…

    • 569 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    TIMOTHY JAMES ITURIAGA 1. Pelagianism is a theological theory named after Pelagius (AD 354 – AD 420/440), although he denied, at least at some point in his life, many of the doctrines associated with his name. It is the belief that original sin did not taint human nature and that mortal will is still capable of choosing good or evil without special Divine aid. This is still sometimes called Limited Depravity. Thus, Adam's sin was "to set a bad example" for his progeny, but his actions did not…

    • 327 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    LAN-BASED RESERVATION WITH BILLING SYSTEM FOR RESORT AND HOTEL SCOPE AND LIMITATIONS OF THE STUDY SCOPE The proposed study includes ways and strategies in developing a LAN-Based Computerized Reservation with Billing System for Resort and Hotel where all inputted records and information from guests/guests are being saved in the database. The database serves as the back-office system for storing and retrieving data/records. All queries are being processed in the database for the system’s administrator’s…

    • 463 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Chapter 1 - The Problem Domain I. Introduction Technology is now part of everyday life. Human beings develop ways to make their work easy. Technology is progressing as times goes by. It must be planned and maintain for future generation who will use it. The world is turning to be a technological giant due to the pressure of computers and the innovation of computers eventually manufacturing a more definite model of computers and different communication gadgets. This is the competition…

    • 553 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Study Online Billing and Reservation system can help the people to perform a reservation through the use of internet. The reservation in a specific hotel or resort and paying bills can be done easily, no more hassles and time consuming. Using of internet access in online billing and reservation system, the different features of the resort can be viewed freely and easily such as amenities and function rooms, packages and other services. The Boso-Boso Highlands Resort and Convention Center is one…

    • 3335 Words
    • 14 Pages
    Powerful Essays