Database Management & Applications Speadsheet

Create a sheet in excel or sheets to identify tables that you would create to break down a seperation of what the tables should be, including the table name, data type. Just like in our sample …

Database Management &
Applications
Author: Jeff Seaman
Databases
5/30/2022
Development Process| Point Park University
3
What is a database?
Organized collection of data, generally stored and accessed electronically
From a computer system. Where databases are more complex, they are often
Developed using formal design and modeling techniques.
5/30/2022
Databases| Point Park University
4
What is this?
5/30/2022
Databases| Point Park University
5
Different Databases
❑SQL Server
❑Oracle
❑MySQL
❑SQLite
❑Db2
❑MongoDB
❑PostgreSQL
5/30/2022
Databases| Point Park University
6
Flat Table
5/30/2022
Databases| Point Park University
7
Relational Database
5/30/2022
Databases| Point Park University
8
Data Types
The format of data storage that can hold a distinct type or range of values.
Common Database Data Types
o Integer
o Character
o String
o Varchar
o Boolean
o Date
5/30/2022
Databases| Point Park University
9
Development Process?
5/30/2022
Development Process| Point Park University
10
5/30/2022
Database Management| Point Park University
11
Create a mockup design
5/30/2022
Database Management| Point Park University
12
Applications
5/30/2022
Development Process| Point Park University
13
Applications
Some applications connect to databases in order to operate
5/30/2022
Databases| Point Park University
14
Thank You!
5/30/2022
Database Management| Point Park University
15
QUESTIONS
5/30/2022
Database Management| Point Park University
16