Introduction to SQL and Relational Databases
1. Relational Data- A relational database is a collection of relations or two-dimensional tables con-
base trolled by the MariaDB server.
2. Table A 2-dimensional structure consisting of rows and columns.
3. Field The intersection of a row and a column; it may contain an atomic value or it may
be null.
4. Row Also known as a Record or Entity Instance.
5. Column Also known as an Attribute.
6. Atomic Value A value that cannot be divided further.
7. SQL Structured Query Language, the ANSI standard language for operating relational
databases.
8. SELECT State- A SQL command used to retrieve data from a database.
ment
9. Unique Name Re- A table must have a unique name under the relational model.
quirement
, Introduction to SQL and Relational Databases
10. Unique Row Re- Each row in a table must be unique.
quirement
11. Atomic Values A table must contain only atomic values, with no multivalued attributes.
Requirement
12. Row Order Irrele- The order of rows in a table must be irrelevant.
vance
13. Column Order Ir- The order of columns in a table must be irrelevant.
relevance
14. HR Schema A schema that includes tables such as REGIONS, COUNTRIES, LOCATIONS, DE-
PARTMENTS, EMPLOYEES, JOBS, and JOB_HISTORY.
15. REGIONS Table Contains rows that represent a region such as America, Asia, and so on.
16. COUNTRIES Contains rows for countries, each associated with a region.
Table
17. LOCATIONS Contains the specific address of a specific office, warehouse, or production site of
Table a company in a particular country.
18. Shows details about the departments in which the employees work.
, Introduction to SQL and Relational Databases
DEPARTMENTS
Table
19. EMPLOYEES Contains details about each employee working for a department.
Table
20. JOBS Table Contains the job types that can be held by each employee.
21. JOB_HISTORY Contains the job history of the employees, with new rows inserted for changes in
Table jobs or departments.
22. Identifying Rela- Represented by a solid line in HR schema.
tionship
23. Non-Identifying Represented by a dotted line in HR schema.
Relationship
24. Table A collection of data organized in rows and columns within a database.
25. Unique Name A requirement that each table in a database must have a distinct identifier.
26. Unique Row Each row in a table must be distinct from all other rows.
27. Atomic Values Values that cannot be divided further; no multivalued attributes are allowed.
1. Relational Data- A relational database is a collection of relations or two-dimensional tables con-
base trolled by the MariaDB server.
2. Table A 2-dimensional structure consisting of rows and columns.
3. Field The intersection of a row and a column; it may contain an atomic value or it may
be null.
4. Row Also known as a Record or Entity Instance.
5. Column Also known as an Attribute.
6. Atomic Value A value that cannot be divided further.
7. SQL Structured Query Language, the ANSI standard language for operating relational
databases.
8. SELECT State- A SQL command used to retrieve data from a database.
ment
9. Unique Name Re- A table must have a unique name under the relational model.
quirement
, Introduction to SQL and Relational Databases
10. Unique Row Re- Each row in a table must be unique.
quirement
11. Atomic Values A table must contain only atomic values, with no multivalued attributes.
Requirement
12. Row Order Irrele- The order of rows in a table must be irrelevant.
vance
13. Column Order Ir- The order of columns in a table must be irrelevant.
relevance
14. HR Schema A schema that includes tables such as REGIONS, COUNTRIES, LOCATIONS, DE-
PARTMENTS, EMPLOYEES, JOBS, and JOB_HISTORY.
15. REGIONS Table Contains rows that represent a region such as America, Asia, and so on.
16. COUNTRIES Contains rows for countries, each associated with a region.
Table
17. LOCATIONS Contains the specific address of a specific office, warehouse, or production site of
Table a company in a particular country.
18. Shows details about the departments in which the employees work.
, Introduction to SQL and Relational Databases
DEPARTMENTS
Table
19. EMPLOYEES Contains details about each employee working for a department.
Table
20. JOBS Table Contains the job types that can be held by each employee.
21. JOB_HISTORY Contains the job history of the employees, with new rows inserted for changes in
Table jobs or departments.
22. Identifying Rela- Represented by a solid line in HR schema.
tionship
23. Non-Identifying Represented by a dotted line in HR schema.
Relationship
24. Table A collection of data organized in rows and columns within a database.
25. Unique Name A requirement that each table in a database must have a distinct identifier.
26. Unique Row Each row in a table must be distinct from all other rows.
27. Atomic Values Values that cannot be divided further; no multivalued attributes are allowed.
