module 3

A database that organizes data into tables related by common fields

A database that stores data in a single file

A database that only stores unstructured data

A database that does not allow relationships between data

Database Engine

Query Processor

Storage Manager

Data Visualizer

MySQL

Oracle Database

SQLite

Microsoft SQL Server

PRIMARY KEY

FOREIGN KEY

UNIQUE

CHECK

First Normal Form (1NF)

Third Normal Form (3NF)

Fourth Normal Form (4NF)

Fifth Normal Form (5NF)

SELECT * FROM Customers WHERE City = 'New York';

SELECT FirstName, LastName FROM Customers WHERE City = 'New York';

SELECT FirstName, LastName FROM Customers;

SELECT City FROM Customers WHERE FirstName = 'New York';

WHERE

HAVING

GROUP BY

ORDER BY

They filter rows based on a condition.

They combine data from multiple tables.

They perform calculations across a set of rows related to the current row.

They insert new records into a table.

With

Where

From

And

Insert a single record

Insert multiple records

Insert data from another table

Insert using a DELETE statement

Identify and describe the basic components of SQL

Construct and execute fundamental SQL queries

Create relational database tables with appropriate data types

Design a web application interface