GEP 664 Midterm Examples of Definitions, Assuming No Incorrect Information Example term: SQL Answers --------- The standard language used for working with databases Credit: zero. Misses the key points, no supporting details. --------- The structured query language is the language used for accessing and creating relational databases. The language uses declarative commands and is a standard that is used across many different databases. Relational databases are designed to efficiently store and provide access to datasets. Credit: partial. Has some key points, not enough detail, tangential information. --------- SQL is the language used for accessing, modifying, and creating data tables in a relational database. It uses straight-forward commands like SELECT to select data from a table and CREATE TABLE to create new tables. A statement has individual parts that are usually written on separate lines and the statement must end with a semicolon. Credit: partial. Lacks key points, not enough detail. --------- The structured query language is the standard language used for creating and manipulating relational databases. SQL is an international standard that is used across many different relational database systems. It uses basic declarative commands in English like 'SELECT' and 'ALTER' and is based on relational algebra. It can be divided into many subsets - the two primary subsets are the Data Manipulation Language for updating and retrieving data and the Data Definition Language for creating and modifying database objects. Credit: full. Covers all key points, has sufficient detail. Example of a technical definition. --------- Short for structured query language, it is the standard language that is commonly used in many relational databases for accessing, modifying, and storing data. Most database systems will adopt a core or root part of the language, so that basic commands written in one database system will work in another. Statements consist of several clauses that span several lines. The SELECT statement is a common command for retrieving data, and is written as: SELECT some columns FROM some tables WHERE certain criteria is met. Statements like CREATE and ALTER are used to create objects like tables and views. Credit: full. Covers all key points, has sufficient detail. Example of a practical definition.