SQL Intro

Question 1

What is SQL

Answer 1

Structured Query Language - programming language designed for working with databases

Question 2

Data Value

Answer 2

One piece of a record, i.e. a single cell value

Question 3

Record

Answer 3

A full set of data values, i.e. a row

Question 4

Field

Answer 4

Column in a table containing specific information about every record in the table

Question 5

Tabular Data

Answer 5

Data stored on tables

Question 6

Entity

Answer 6

The smallest unit that can contain a meaningful set of data

Question 7

Database Designer

Answer 7

Lays the foundation for your system. They will do this by first drawing a Entity-Relationship (ER) Diagram and/or Relational Schema

Question 8

Entity-Relationship (ER) Diagram

Answer 8

Shows the different entities and their relationships within the system

Question 9

Relational Schema

Answer 9

An existing idea of how the database must be organized. It is useful if you are certain of the structure/organization of the database you are designing. They are blueprints for databases

Question 10

Data Manipulation

Answer 10

Using database to extract business insights

Question 11

Database Management

Answer 11

Refers to all the steps a business manager takes to design, create, and manipulate a database

Question 12

Database Administration

Answer 12

Daily care and maintenance of the database

Question 13

Primary Key - what is it and can there be more than one in a table? Do all tables need a primary key?

Answer 13

Column or set of columns whose value exists and is unique for every record in a table. Each table can only have one primary key. Cannot have null values. Not all tables require a primary key.

Question 14

Foreign Key (FK) - What is it, and can it have repeating and/or null values?

Answer 14

Identifies the relationship between tables, not the tables themselves. Repeating and/or Null values are allwoed

Question 15

Unique Key - what is it, and can it contain null values? Can there be more than one Unique Key?

Answer 15

Used whenever you want to specify that there should not be duplicate values in a given field, but that that field is NOT a Primary Key. In this case, Null Values are allowed. THere can be more than one Unique Key

Question 16

Relationships

Answer 16

Tell you how much of the data from a FK field can be seen in a PK of the table the data is related to and vice versa