Section 3: Basic Database Terminology

Question 1

2 Types of databases

Answer 1

1. Relational Databases

2. Non-relational Databases

Question 2

Relational Databases

Answer 2

1. Regards more complex Systems.

2. Mathematics and programming.

Question 3

Relational Datase Purpose

Answer 3

Organize huge amounts of data that can be quickly retrieved.

Question 4

What is relational Database

Answer 4

The smallest units in the entire system can carry integral logical meaning.

Question 5

RDMS (What is it)

Answer 5

Relational Database Management System.

When the database combined with its existing relations

Question 6

Spreadsheet

Answer 6

An electronic ledger.

An electronic version of paper accounting worksheets.

Question 7

Spreadsheet vs Databases (Similarities)

Answer 7

1. Can contain large amounts of tabular data.
2. Can use existing data to make calculations.
3. Are used by many users.

Question 8

Spreadsheet vs Databases (Differences)

Answer 8

Relational Databases.
- Retrieval of data
- Updating of data
- Efficiency
- Data consistency
- Data Integrity
- Speed
Spreadsheets.
- Extensive analysis

Question 9

Database designer

Answer 9

Plot the entire database system on a canvas using a visualization tool

Question 10

ER Diagram

Answer 10

Entity-Relation Diagram

- Different data entities and the relationship that exsists between the 2

Question 11

Relational Schema

Answer 11

An existing idea of how the database must be organized.

Question 12

Database creation

Answer 12

Use SQL to set up the database physically

Question 13

Database manipulation

Answer 13

Allows you to use your dataset to extract business insights to improve performance and efficiency

Question 14

Database Management

Answer 14

The steps that a business takes to: 
1. Database design
2. Creation
3. manipulation
Successfully

Question 15

Database Adminstration

Answer 15

The person providing daily care and maintenance of the database

Question 16

Relational Schema (Primary Key)

Answer 16

A column or set of columns whose value exists a
1. Each table can only have 1 primary Key
(Unique Identifiers)

Question 17

Primary Key Limitations

Answer 17

1. Each table can only have 1 Primary Key
2. Primary key cannot be blank
3. Not all tables will have a primary Key

Question 18

Relational Schemas (Foreign Key)

Answer 18

Identifies the relationships between tables and not the table itself
1. Identify

Question 19

Unique Key

Answer 19

Used whenever you would like to specify that you don’t want to see duplicate data in a given field

Question 20

Primary Key vs Unique Key

Answer 20

1. unique keys can contain null values (Unknown phone # of a business)
2. A table can have multiple unique keys but multiple Primary Keys.

Question 21

Relationships

Answer 21

Tell how much of the data from a foreign field can be seen in the primary key column of the table and the data is related to and vice versa.

Question 22

One-to-many type of relationship vs Many-to-one Relationship

Answer 22

For example, if one department can employ for several employees then, department to employee is a one to many relationship (1 department employs many employees), while employee to department relationship is many to one (many employees work in one department)

Question 23

Cardinality Constraints

Answer 23

Symbols showing relationship limitations.

I,>,M,N,O