Start Here
A database is an organized system for storing, managing, protecting, searching, and updating information. This lab takes the PowerPoint concepts and turns them into hands-on decision-making.
Core idea: Hardware stores and processes data. Software lets people and systems use it. Databases organize it. AI depends on it.
Learning Objectives
Explain the value of data and information.
Describe what a database does and why organizations use one.
Compare spreadsheets and databases.
Classify structured, semi-structured, and unstructured data.
Compare relational and non-relational databases.
Use tables, fields, records, primary keys, and foreign keys correctly.
Connect databases to AI, cybersecurity, cloud, and job readiness.
Concept Explorer
Open each card. Read the explanation, connect it to hardware/software, and answer the reflection prompt.
Activity 1: Spreadsheet or Database?
Choose the better tool for each scenario. This reinforces the shoe store discussion from the deck.
Activity 2: Classify The Data
Choose whether each example is structured, semi-structured, or unstructured.
Activity 3: Build A Simple Ice Cream Shop Table
Use the scenario from the PowerPoint. Fill in sample records, then identify the primary key.
| FlavorID | FlavorName | QuantityOnHand | Cost | SalePrice | ReorderLevel |
|---|---|---|---|---|---|
Activity 4: Primary Key and Foreign Key Challenge
Imagine a school registration database with three tables: Students, Courses, and Enrollments.
| Table | Possible Fields | Your Key Decision |
|---|---|---|
| Students | StudentID, FirstName, LastName, Email | |
| Courses | CourseID, CourseName, Instructor | |
| Enrollments | EnrollmentID, StudentID, CourseID, DateEnrolled |
AI and New Technology Connection
AI Search: AI tools often search databases, documents, or indexes before answering.
Dashboards: Business dashboards turn database records into visual decisions.
Automation: Workflows trigger actions when database values change.
Cybersecurity: Logs and alerts are stored in databases so analysts can investigate threats.
Cloud: Cloud databases let organizations scale access, storage, backup, and recovery.
Data Governance: Good AI needs accurate, authorized, protected, and well-modeled data.
Zero-Trust mindset: A database should not be open to everyone. Access should be limited by identity, role, purpose, logging, and least privilege.
Quick Quiz
Answer each question. Feedback appears immediately.
Exit Ticket
Instructor 45-Minute Teaching Flow
| Time | Teaching Focus |
|---|---|
| 0-5 minutes | Open with the ice cream shop scenario and define database in plain language. |
| 5-15 minutes | Teach database characteristics and database vs spreadsheet. |
| 15-25 minutes | Classify structured, semi-structured, and unstructured data. |
| 25-35 minutes | Build the table and explain primary/foreign keys. |
| 35-45 minutes | Connect databases to AI, cybersecurity, cloud, and job readiness; complete exit ticket. |