Preview

Resort Reservation

Powerful Essays
Open Document
Open Document
3177 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Resort Reservation
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)
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    bis221 r1 Overview of Information Systems Table Week1 1
    • 492 Words
    • 3 Pages

    bis221 r1 Overview of Information Systems Table Week1 1

    A database is essentially an electronic filing system. It allows you to quickly select desired pieces of information.…

    • 492 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Bis221 Mel Johnson
    • 765 Words
    • 3 Pages

    Bis221 Mel Johnson

    A database stores information for any given reason and can be tracked back for any needed purpose.…

    • 765 Words
    • 3 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Unit 18 - Database P1, M1
    • 995 Words
    • 4 Pages

    Unit 18 - Database P1, M1

    Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.…

    • 995 Words
    • 4 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Dbm/380 Database Concepts
    • 461 Words
    • 2 Pages

    Dbm/380 Database Concepts

    A database is a set of programs and applications used to store data, this allows the data to be used by different individuals in different areas and access information from it quickly. A database stores the information so it can be used at a later time so additional information can be added, taken away, or used as needed. Once in the database the data is compressed so it takes up less space in the computer’s memory. The database allows those authorized to use the data within it and control the creation, maintenance, and use of a database. A database stores various kinds of files, data records, and other objects. There are a variety of database models; there is the relational model or object model, which supports applications. That use query languages, which are high-level programming languages, and dedicated database languages that simplify writing database application programs. The main function of a database is basically retrieving and presenting information it controls, in doing this it allows the users data access, protects the data’s and makes it more manageable. It also provides safety features for the data so that it is not lost or misplaced and if there is a serious event or natural disaster, fire, etc. it can be recovered and restored from a backup. In my work we use Microsoft Access as a relational database for employment records and to store our client information such as names, addresses, phone numbers, and email addresses from this database we send out a monthly newsletter with special offers on services and products. By using a database, an organization saves time and money because it is only a few simple steps and we can email all of our clients and customers a monthly newsletter which informs them about what is happening within the organization, services and products we offer, and what is on sale which generates more business. By using a…

    • 461 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Bis221 R1 Overview Of Information Systems Table Week1
    • 598 Words
    • 3 Pages

    Bis221 R1 Overview Of Information Systems Table Week1

    A database is a computer mechanism for storing and retrieving data. It gives one true command of their data, enabling one to retrieve it, sort it, analyze it, summarize it, and report results in changes.…

    • 598 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Is3110 Chapter 1
    • 789 Words
    • 4 Pages

    Is3110 Chapter 1

    1. In a ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.…

    • 789 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Week 1 BIS221

    • 536 Words
    • 3 Pages

    Week 1 BIS221

    Databases allows companies to organize all their information on one place, making it easy for people to access and share information.…

    • 536 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Dbm 381 Week 1paper
    • 885 Words
    • 4 Pages

    Dbm 381 Week 1paper

    A database consists of one or more tables; each containing data stored as individual records. Different database architectures determine how the tables and records are organized or related…

    • 885 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Electronic Keyboarding Applications and Softwares
    • 253 Words
    • 2 Pages

    Electronic Keyboarding Applications and Softwares

    A database is any collection of related items stored in computer memory. The data in a database may be about club members, employee payroll, company sales, and so on. Database software allows the user to enter data, arrange it, retrieve and change it, or select certain data (such as an address) for use in documents.…

    • 253 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Cis 276
    • 374 Words
    • 2 Pages

    Cis 276

    5.What is a database? A database is a structure that can store information about multiple types of entities, the attributes of the entities,…

    • 374 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Bis Midterm Sheet
    • 1467 Words
    • 6 Pages

    Bis Midterm Sheet

    Database: A data base is a self-describing collection of integrated records. Bytes (character of data) are grouped into columns. Columns are also called fields. Columns or fields, in turn, are grouped into rows, which are also called records. The collection of data for all columns is called a row or a record. A group of similar rows or records is called a table or a file. A database is a collection of tables plus relationships around the rows in those tables, plus special data, called metadata, that describes the structure of the database. Databases are usually stored on magnetic disks.…

    • 1467 Words
    • 6 Pages
    Good Essays
    Read More
  • Good Essays

    Business and Administration Unit 3
    • 2906 Words
    • 12 Pages

    Business and Administration Unit 3

    • A database is a collection of data which has been organised so that a computer program can quickly select desired items. This could be something as straightforward as a list of names in alphabetical order or an ascending list of numeric stock codes. Ideal for use with telephone contacts or staff details.…

    • 2906 Words
    • 12 Pages
    Good Essays
    Read More
  • Powerful Essays

    Computer Concepts Exam 1
    • 951 Words
    • 4 Pages

    Computer Concepts Exam 1

    According to the textbook authors, what is another name for the rows in a database table? Records…

    • 951 Words
    • 4 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Database Environment
    • 1121 Words
    • 5 Pages

    Database Environment

    A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Database Design Paper
    • 429 Words
    • 2 Pages

    Database Design Paper

    A database system is a computer term for a structured set of data that can be saved, retrieved, added to or deleted from relatively easy. There are a variety of different databases and the type of database will determine how the data is arranged when it is stored and how that data will be located when it is called upon.…

    • 429 Words
    • 2 Pages
    Satisfactory Essays
    Read More

Related Topics