Intro to Database Management Systems

Overview

• What is a Data Set?
• What is a Data Set Collection?
• What is a Database Engine?
• What is a Database?

What is a Data Set?

• A dataset is representative of a collection of like-records.
  • A dataset has many rows.
• A row is representative of a single record within a dataset.
  • A row has many columns.
• A column is representative of a field (or property) of a record.
  • A column within a row is a cell of data.
• In SQL, datasets are called Tables.
• In Spreadsheet Applications, (like Excel of Google Sheets), datasets are called Worksheets.

First Name	Last Name	Age	Gender
Leon	Hunter	24	Male
Wilhem	Alcivar	23	NULL
Nhu	Nguyen	NULL	Female

What is a Data Set Collection?

• In SQL, collections of datasets are called databases.
• In Spreadsheet Applications, collections of datasets are called workbooks.

What is a Database Engine?

• the software component that the Database Management System uses to perform relational CRUD operations on a Database
  • Create records
  • Read records
  • Update records
  • Delete records

What is a Database?

• A query is an inquiry: a request for information
• Unlike workbooks, a database has an api to query the data, referred to as Structured Query Language (SQL).
• Well-designed databases respond to queries with relevent information quickly without redundancies.
• Well-designed databases allow querying related data across several tables.