Data Base-ics

class: middle

# .eight[CSET 155:]
## .eight[Database Design]

---
class: middle

# Data Base-ics

---
class: middle, center

# What is .eight[data]?

---

# Colloquial Definitions:

- "Facts or information usually used to calculate, analyze, or plan something"
- "Facts or statistics collected together for reference or analysis"
- "Information or knowledge represented in a form suitable for processing"

---
class: middle, center

# Do you remember our definition of a .eight[computer] from last semester?

---
class: middle, center

# .eight[A device for storing and processing data.]

---
class: middle, center

# What about data .eight[types]?

---
class: middle, center

# .eight[The data's role, it defines how it is stored and how it can be processed.]

Let's list the JavaScript types we already know.

---
class: middle, center

# What is the basic .eight[storage] unit of data for the computer?

---
class: middle, center

# .eight[A file.]

Let's list some file types we know.

---
class: middle, center

# What are some of the operations we can perform on a file?

---
class: middle

# .eight[C]
# .eight[R]
# .eight[U]
# .eight[D]

---
class: middle
count: false

# .eight[C]reate
# .eight[R]ead
# .eight[U]pdate
# .eight[D]elete

---
class: middle, center

# .fourteen[How could we represent this classroom as data in a text file?]

---
class: middle, center

# This is called .eight[Data Modeling].

Although this is usually a more formal process...

---
class: middle, center

# What are some problems with storing data like this?

---
class: middle

- Inconsistent (Not Normalized)
- Repetitive
- Hard to interact with
- Non-Parallelizable

---
class: middle, center

# Are there any better file formats to store this data?

---
class: middle

# Database

# .eight[An organized collection of data.]

---
class: middle

# Database Management System

# .eight[Software that interacts with the database, applications, and users.]

# .eleven[DB != DBMS]

---
class: middle

# Other Terms We'll Learn:

- Relational DBMS
- SQL
- NoSQL
- CAP Theorem
- ACID

---
class: middle

# Overview:

- Data 
- Databases
- Database Management Systems
- CRUD
- Basic Modeling

---
class: middle

# .fourteen[Practice]

# Use a spreadsheet to capture and structure some data that might be found in the school portal.