Skip to content

Latest commit

 

History

History
25 lines (21 loc) · 560 Bytes

File metadata and controls

25 lines (21 loc) · 560 Bytes

SQL queries on Employee Database

Background

A series of SQL queries on the employee database to obtain information.

Queries Used

  • Data Definition Language Statements:
    • ALTER
    • DROP
    • CREATE VIEW
    • DROP VIEW
  • Data Manipulation Language Statements:
    • SELECT
    • APPEND
    • DELETE
    • UPDATE
    • JOIN
  • Aggregate Functions:
    • SUM
    • COUNT
    • GROUP BY
    • WHERE

Employees_Entity Relationship Diagram (UML Notation)