Terminology

Question 1

RDBMS

Answer 1

Relational Database Management System, relational referring to relational data (i.e. tables). Schema Like packages/namespaces, groupings of tables expressing some database logical structure. In Oracle SQL its synonymous with the user. SQL implementations There is OracleSQL is an Enterprise Database like PostgreSQL, SQL Server, but there are others like MySQL, MariaSQL, as well as non relational SQL databases (NoSQL).

Question 2

Candidate Key

Answer 2

A column that can uniquely identify a row (or entry) and thus is a potential candidate for a primary key.

Question 3

Multiplicity

Answer 3

Refers to the relationship between linked tables. One-to-One (University, President), One-to-Many (University, Students), Many-to-Many (Students, Teachers). In 1:1, FKs will be within same table. 1:many, FKs will be in the other table. many:many, FKs will be in a junction/transition/join/lookup table.

Question 4

Referential Integrity

Answer 4

Enforcing data relationships, changes reflected between foreign keys. No orphans, all child rows must have their parent rows deleted as well.

Question 5

1st NF

Answer 5

Atomic values, No repeating Columns

Question 6

2nd NF

Answer 6

Remove Partial Dependencies

Question 7

3rd NF

Answer 7

Remove Transitive Dependencies

Question 8

ERD

Answer 8

Entity-Relational Diagram

Question 9

Composite Key

Answer 9

A primary key consisting of multiple columns.

Question 10

Primary Key Unique vs Foreign Key

Answer 10

Primary Key Unique (in that table), non-null candidate key.

Foreign key - A key that points to another primary key of a row (either in another table, or the same).

Question 11

Domain Integrity

Answer 11

Column data is restricted to allowed range of allowed type.