DATABASE SQL

DO NOT COPY AND PASTE PREVIOUS CHEGG ANSWERS PLEASE I'VE CHECKED THEM ALL

for the department type it should be four specific types

Write SQL statements for the following (Show snapshots from implementing your sentences)

a. Creating relations in your database, with specifying all constraints and data types. b. Inserting records into each relation. (5 records in each table) c. Modifying a record based on a condition (based on your application needs) d. Deleting a record based on a condition. (based on your application needs)

e. Retrieving records from two different relations based on f. Retrieving records from two different relations based on specific condition. (Use join) specific condition. (Use join and aggregate functions

Build a database on SQL based on this Relational Database