Unit 9 Lesson 1

Unit 9
Databases

Coach Jett Davison
Digital Technology

Purpose of a Database

Usage of a Database

Flat File vs Database

Records

Storage

What is a Database?

Also known as a data store a database is a large index of digital information
that can be manipulated, searched, referenced, and/or compared with
optimal speed at minimal expense.

Ex.

Oracle Database

Microsoft SQL Server

Microsoft Access

MySQL

Four Major Features of a Database

Create

Input/Output

Query

Reports

Create

Input and Output

Query

Reports

Multiple Choice

First step in creating a database is to....

• Create its structure

• Input its data

• Import its data

• Compile its data

Multiple Choice

A Data structure that contains rows and columns a database can contain one or more of these...

• Table

• Bank

• Query

• Workbook

Multiple Choice

Data entry where user enters data manually

• Input

• Import

• Output

• Scribe

Multiple Choice

Bringing in Data from an existing file

• Input

• Import

• Scaling

• Querying

Multiple Choice

Requesting for data from a database

• Query

• Extracting

• Encrypting

• Distrbuting

Flatline vs Database

Multiple Concurrent Users

Scalability

Speed

Variety of Data

Multiple Choice

The ability to add or remove resources to handle changing demands

• Scalability

• Velocity

• Consistency

• Automation

Multiple Choice

Locking mechanisms should be placed on database to prevent data corruption due to....

• Multiple concurrent users

• Security Insurance

• Data Volume

• Data Carboning

Multiple Choice

A single excel spreadsheet with students grades is an example of a...

• Flat-File

• Relational Database

• Query Table

• Primary Key Table

Multiple Choice

Non-Relational Databases usually are faster that relational databases because

• Non-Relational Databases only use one table

• Rational Databases only use one table

• Non-relational databases arent faster

• relational databases are less functional

Multiple Choice

Which is not one of the 3Vs of Databases

• Variety

• Velocity

• Volume

• Viability

Records

Storage

ACID

Multiple Choice

Grouping of fields within a table

• Records

• Tables

• Queries

• Constraints

Multiple Choice

Which is not a part of the acronym ACID

• Atomicity

• Consistency

• Importability

• Durability

Various Structure Types

Structured vs. Semi-Structured vs Non-Structured

Relational Databases

Non-Relational Databases

Columns and Fields

In a standard table view, each column is a field.
Some columns are key fields

Structured Data

Structured database is divided into rows and columns

Ex. Microsoft Excel

Header Row is equivalent of fields in a structured database

Each row is equivalent to a record

Data Mining is used to find patterns in data, establish relationships and
forecast trends

Provides info needed for data analysis

Not suitable for everything

Semi-Structured Data

A form of structured data

Does not obey formal structure of data models associated with
relational databases

Contains tags or Markers to separate elements

Enforces hierarchies of records & fields within Data

Does not use rows instead uses elements and hierarchies

Examples: XML and JSON

JSON

Used to transfer between web servers and web apps.

Non-Structured Data

Does not have a pre-defined data model

Typically text heavy

Semantic Technology used to analyze text that
unstructured to search for correlation and meaning

Multiple Choice

A software that features structured databases is

• Excel

• Word

• Powerpoint

• Docs

Multiple Choice

Does not use rows instead uses elements and hierarchies. XML is an example of this type of data

• Semi-Structured

• Structured

• Data Mined

• Line

Multiple Choice

Used to transfer DB data between web servers and apps

• JSON

• XML

• SQL

• AOL

Multiple Choice

Semantic programs are often used to analyze data for correlation and meaning

• Non-Structure Data

• Structured Data

• Semi-Structured Data

• Data Mined Data

Relational Databases

Type of database that stores and provides access to data points that are
related to one another

Accessed typically by SQL

Essential Elements

●

Schema

●

Tables

●

Fields/column

●

Constraints

Schema

The overall structuring of a database

Must be carefully planned before beginning

Changing schema involves a lot of steps to insure data isn't lost.

Tables

A collection of related data held in a “Table” format with a DB

Consists of columns and rows

Each column has a label

Primary Key

Unique Value for each row. Such as a user ID.
Each table MUST have a primary key

Foreign Key

Links two database tables together

Can be more than one column

Foreign Key in one table must be the primary or candidate key in
another

Constraints

5:46 - 6:52

Multiple Choice

Describes data base were tables are in relationship with one another

• Relational

• Non-Relational

• Structural

• Flat-File

Multiple Choice

A User ID is an example of a _____ Key

• Primary

• Foreign

• Functional

• Composition

Multiple Choice

The overall structure of a database

• Schema

• Primary Key

• Foreign Key

• Tables

Multiple Choice

Properties assigned to a column set that define what type of data can be placed in a column. Promotes Data Integrity

• Constraits

• Schema

• Primary

• Foreign

Non-Structural Databases

6:54 - 7:46

Key/Value and Document Databases

747 - 927

Relational Methods

Refers to the manner in which databases are
created, used, and updated

2 Major Categories of Relational Methods are:

Data Manipulation

Data Definition

Data Manipulation

:33 - 1:23

Data Definition

1:24 - 2:06

Database Access Methods

2:50 - 3:25

Programmatic Access

3:36 - 4:44

Query/Report Builders

Queries are used to find specified Data in a DB by using the SELECT statement

Export/Import

5:03 - 5:21

Database Dump

5:24 - 6:02

Back-Up

6:03 - 6:45