Section 1: Intro to Database SQL and MySQL Keyterms

Question 1

SQL Definition

Answer 1

Structured Query Language

Question 2

SQL programming purpose

Answer 2

A programming language specifically designed for working with databases.

Question 3

3 functions of SQL

Answer 3

1. Create
2. Manipulate
3. Share
   Data form relational database Management Systems

Question 4

What is a Query

Answer 4

A piece of code inducing the computer to execute a certain operation that will deliver a desired output

Question 5

What is SQL and what does it do

Answer 5

1. A programming language specifically designed for working with databases.
2. Allow you to write queries that the computer can execute and then provide databases insights in return.

Question 6

Record

Answer 6

A row in an SQL table

Question 7

A field

Answer 7

A column in a table containing specific information about every record in the table

Question 8

STD

Answer 8

Stored Tabular Data

When data is stored in rows and communs

Question 9

Entity

Answer 9

The smallest unit that can contain a meaningful set of data

Question 10

2 types of Entities

Answer 10

1. Vertical entity: Information along the Y-axis

2. Horizontal entity: (Entity instance) Information along the X-Axis