DROP TABLE Vendors CASCADE CONSTRAINTS
Table dropped.
DROP TABLE Equipment CASCADE CONSTRAINTS
Table dropped.
DROP TABLE Employees CASCADE CONSTRAINTS
Table dropped.
CREATE TABLE Employees (
Employee_ID NUMBER PRIMARY KEY,
First_Name VARCHAR2(50),
Last_Name VARCHAR2(50),
Department VARCHAR2(100),
Role_Title VARCHAR2(100)
)
Table created.
CREATE TABLE Equipment (
Equipment_ID NUMBER PRIMARY KEY,
Equipment_Name VARCHAR2(100),
Equipment_Type VARCHAR2(50),
Purchase_Date DATE,
Condition_Status VARCHAR2(50)
)
Table created.
CREATE TABLE Assignments (
Assignment_ID NUMBER PRIMARY KEY,
Employee_ID NUMBER REFERENCES Employees(Employee_ID),
Equipment_ID NUMBER REFERENCES Equipment(Equipment_ID),
Issue_Date DATE,
Return_Date DATE
)
Table created.
CREATE TABLE Maintenance (
Maintenance_ID NUMBER PRIMARY KEY,
Equipment_ID NUMBER REFERENCES Equipment(Equipment_ID),
Maintenance_Date DATE,
Description VARCHAR2(100),
Cost NUMBER
)
Table created.
CREATE TABLE Vendors (
Vendor_ID NUMBER PRIMARY KEY,
Vendor_Name VARCHAR2(100),
Contact_Info VARCHAR2(100)
)
Table created.
INSERT INTO Employees VALUES (1, 'Jason', 'Ball', 'OIT Leadership', 'Associate Provost & CIO')
1 row(s) inserted.
INSERT INTO Employees VALUES (2, 'Christian', 'Block', 'Infrastructure', 'Deputy CIO')
1 row(s) inserted.
INSERT INTO Employees VALUES (3, 'Ying', 'Liu', 'Academic Tech', 'Assistant Provost')
1 row(s) inserted.
INSERT INTO Employees VALUES (4, 'Lucy', 'Martucci', 'Fiscal Management', 'Director')
1 row(s) inserted.
INSERT INTO Employees VALUES (5, 'Zachary', 'Macdonald', 'Client Support', 'Manager')
1 row(s) inserted.
INSERT INTO Employees VALUES (6, 'Jennifer', 'Turner', 'Enterprise Support', 'Associate Director')
1 row(s) inserted.
INSERT INTO Equipment VALUES (1, 'HP Monitor', 'Laptop', DATE '2024-05-10', 'Good')
1 row(s) inserted.
INSERT INTO Equipment VALUES (2, 'Dell Laptop', 'Peripheral', DATE '2024-01-05', 'Good')
1 row(s) inserted.
INSERT INTO Equipment VALUES (3, 'Xfinity Router', 'Network', DATE '2024-03-15', 'Needs Repair')
1 row(s) inserted.
INSERT INTO Equipment VALUES (4, 'MacBook Pro', 'Computer', DATE '2024-06-25', 'Excellent')
1 row(s) inserted.
INSERT INTO Equipment VALUES (5, 'Logitech Mouse', 'Peripheral', DATE '2024-07-12', 'Good')
1 row(s) inserted.
INSERT INTO Assignments VALUES (1, 2, 1, DATE '2024-08-17', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (2, 4, 2, DATE '2024-09-01', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (3, 5, 4, DATE '2024-10-15', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (4, 6, 5, DATE '2024-10-20', NULL)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (1, 2, DATE '2024-09-15', 'Battery Replacement', 120)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (2, 4, DATE '2024-10-10', 'Firmware Update', 50)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (3, 5, DATE '2024-10-22', 'Lens Cleansing', 25)
1 row(s) inserted.
INSERT INTO Vendors VALUES (1, 'Tech Supply', 'techsupply@email.com')
1 row(s) inserted.
INSERT INTO Vendors VALUES (2, 'Digital Works', 'support@digitalworks.com')
1 row(s) inserted.
INSERT INTO Vendors VALUES (3, 'Office Gear Solutions', 'officegear@fau.edu')
1 row(s) inserted.
CREATE TABLE Employees (
Employee_ID NUMBER PRIMARY KEY,
First_Name VARCHAR2(50),
Last_Name VARCHAR2(50),
Department VARCHAR2(100),
Role_Title VARCHAR2(100)
)
Table created.
CREATE TABLE Equipment (
Equipment_ID NUMBER PRIMARY KEY,
Equipment_Name VARCHAR2(100),
Equipment_Type VARCHAR2(50),
Purchase_Date DATE,
Condition_Status VARCHAR2(50)
)
Table created.
CREATE TABLE Assignments (
Assignment_ID NUMBER PRIMARY KEY,
Employee_ID NUMBER REFERENCES Employees(Employee_ID),
Equipment_ID NUMBER REFERENCES Equipment(Equipment_ID),
Issue_Date DATE,
Return_Date DATE
)
Table created.
CREATE TABLE Maintenance (
Maintenance_ID NUMBER PRIMARY KEY,
Equipment_ID NUMBER REFERENCES Equipment(Equipment_ID),
Maintenance_Date DATE,
Description VARCHAR2(100),
Cost NUMBER
)
Table created.
CREATE TABLE Vendors (
Vendor_ID NUMBER PRIMARY KEY,
Vendor_Name VARCHAR2(100),
Contact_Info VARCHAR2(100)
)
Table created.
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE Assignments CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Maintenance CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Vendors CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Equipment CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Employees CASCADE CONSTRAINTS';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
Statement processed.
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE Assignments CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Maintenance CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Vendors CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Equipment CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Employees CASCADE CONSTRAINTS';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
Statement processed.
CREATE TABLE Employees (
Employee_ID NUMBER PRIMARY KEY,
First_Name VARCHAR2(50),
Last_Name VARCHAR2(50),
Department VARCHAR2(100),
Role_Title VARCHAR2(100)
)
Table created.
CREATE TABLE Equipment (
Equipment_ID NUMBER PRIMARY KEY,
Equipment_Name VARCHAR2(100),
Equipment_Type VARCHAR2(50),
Purchase_Date DATE,
Condition_Status VARCHAR2(50)
)
Table created.
CREATE TABLE Assignments (
Assignment_ID NUMBER PRIMARY KEY,
Employee_ID NUMBER REFERENCES Employees(Employee_ID),
Equipment_ID NUMBER REFERENCES Equipment(Equipment_ID),
Issue_Date DATE,
Return_Date DATE
)
Table created.
CREATE TABLE Maintenance (
Maintenance_ID NUMBER PRIMARY KEY,
Equipment_ID NUMBER REFERENCES Equipment(Equipment_ID),
Maintenance_Date DATE,
Description VARCHAR2(100),
Cost NUMBER
)
Table created.
CREATE TABLE Vendors (
Vendor_ID NUMBER PRIMARY KEY,
Vendor_Name VARCHAR2(100),
Contact_Info VARCHAR2(100)
)
Table created.
INSERT INTO Employees VALUES (1, 'Jason', 'Ball', 'OIT Leadership', 'Associate Provost & CIO')
1 row(s) inserted.
INSERT INTO Employees VALUES (2, 'Christian', 'Block', 'Infrastructure', 'Deputy CIO')
1 row(s) inserted.
INSERT INTO Employees VALUES (3, 'Ying', 'Liu', 'Academic Tech', 'Assistant Provost')
1 row(s) inserted.
INSERT INTO Employees VALUES (4, 'Lucy', 'Martucci', 'Fiscal Management', 'Director')
1 row(s) inserted.
INSERT INTO Employees VALUES (5, 'Zachary', 'Macdonald', 'Client Support', 'Manager')
1 row(s) inserted.
INSERT INTO Employees VALUES (6, 'Jennifer', 'Turner', 'Enterprise Support', 'Associate Director')
1 row(s) inserted.
INSERT INTO Equipment VALUES (1, 'HP Monitor', 'Laptop', DATE '2024-05-10', 'Good')
1 row(s) inserted.
INSERT INTO Equipment VALUES (2, 'Dell Laptop', 'Peripheral', DATE '2024-01-05', 'Good')
1 row(s) inserted.
INSERT INTO Equipment VALUES (3, 'Xfinity Router', 'Network', DATE '2024-03-15', 'Needs Repair')
1 row(s) inserted.
INSERT INTO Equipment VALUES (4, 'MacBook Pro', 'Computer', DATE '2024-06-25', 'Excellent')
1 row(s) inserted.
INSERT INTO Equipment VALUES (5, 'Logitech Mouse', 'Peripheral', DATE '2024-07-12', 'Good')
1 row(s) inserted.
INSERT INTO Assignments VALUES (1, 2, 1, DATE '2024-08-17', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (2, 4, 2, DATE '2024-09-01', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (3, 5, 4, DATE '2024-10-15', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (4, 6, 5, DATE '2024-10-20', NULL)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (1, 2, DATE '2024-09-15', 'Battery Replacement', 120)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (2, 4, DATE '2024-10-10', 'Firmware Update', 50)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (3, 5, DATE '2024-10-22', 'Lens Cleansing', 25)
1 row(s) inserted.
INSERT INTO Vendors VALUES (1, 'Tech Supply', 'techsupply@email.com')
1 row(s) inserted.
INSERT INTO Vendors VALUES (2, 'Digital Works', 'support@digitalworks.com')
1 row(s) inserted.
INSERT INTO Vendors VALUES (3, 'Office Gear Solutions', 'officegear@fau.edu')
1 row(s) inserted.
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE Assignments CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Maintenance CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Vendors CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Equipment CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Employees CASCADE CONSTRAINTS';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
Statement processed.
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE Assignments CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Maintenance CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Vendors CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Equipment CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Employees CASCADE CONSTRAINTS';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
Statement processed.
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE Assignments CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Maintenance CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Vendors CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Equipment CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Employees CASCADE CONSTRAINTS';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
Statement processed.
CREATE TABLE Employees (
Employee_ID NUMBER PRIMARY KEY,
First_Name VARCHAR2(50),
Last_Name VARCHAR2(50),
Department VARCHAR2(100),
Role_Title VARCHAR2(100)
)
Table created.
CREATE TABLE Equipment (
Equipment_ID NUMBER PRIMARY KEY,
Equipment_Name VARCHAR2(100),
Equipment_Type VARCHAR2(50),
Purchase_Date DATE,
Condition_Status VARCHAR2(50)
)
Table created.
CREATE TABLE Assignments (
Assignment_ID NUMBER PRIMARY KEY,
Employee_ID NUMBER REFERENCES Employees(Employee_ID),
Equipment_ID NUMBER REFERENCES Equipment(Equipment_ID),
Issue_Date DATE,
Return_Date DATE
)
Table created.
CREATE TABLE Maintenance (
Maintenance_ID NUMBER PRIMARY KEY,
Equipment_ID NUMBER REFERENCES Equipment(Equipment_ID),
Maintenance_Date DATE,
Description VARCHAR2(100),
Cost NUMBER
)
Table created.
CREATE TABLE Vendors (
Vendor_ID NUMBER PRIMARY KEY,
Vendor_Name VARCHAR2(100),
Contact_Info VARCHAR2(100)
)
Table created.
INSERT INTO Employees VALUES (1, 'Jason', 'Ball', 'OIT Leadership', 'Associate Provost & CIO')
1 row(s) inserted.
INSERT INTO Employees VALUES (2, 'Christian', 'Block', 'Infrastructure', 'Deputy CIO')
1 row(s) inserted.
INSERT INTO Employees VALUES (3, 'Ying', 'Liu', 'Academic Tech', 'Assistant Provost')
1 row(s) inserted.
INSERT INTO Employees VALUES (4, 'Lucy', 'Martucci', 'Fiscal Management', 'Director')
1 row(s) inserted.
INSERT INTO Employees VALUES (5, 'Zachary', 'Macdonald', 'Client Support', 'Manager')
1 row(s) inserted.
INSERT INTO Employees VALUES (6, 'Jennifer', 'Turner', 'Enterprise Support', 'Associate Director')
1 row(s) inserted.
INSERT INTO Equipment VALUES (1, 'HP Monitor', 'Laptop', DATE '2024-05-10', 'Good')
1 row(s) inserted.
INSERT INTO Equipment VALUES (2, 'Dell Laptop', 'Peripheral', DATE '2024-01-05', 'Good')
1 row(s) inserted.
INSERT INTO Equipment VALUES (3, 'Xfinity Router', 'Network', DATE '2024-03-15', 'Needs Repair')
1 row(s) inserted.
INSERT INTO Equipment VALUES (4, 'MacBook Pro', 'Computer', DATE '2024-06-25', 'Excellent')
1 row(s) inserted.
INSERT INTO Equipment VALUES (5, 'Logitech Mouse', 'Peripheral', DATE '2024-07-12', 'Good')
1 row(s) inserted.
INSERT INTO Assignments VALUES (1, 2, 1, DATE '2024-08-17', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (2, 4, 2, DATE '2024-09-01', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (3, 5, 4, DATE '2024-10-15', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (4, 6, 5, DATE '2024-10-20', NULL)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (1, 2, DATE '2024-09-15', 'Battery Replacement', 120)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (2, 4, DATE '2024-10-10', 'Firmware Update', 50)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (3, 5, DATE '2024-10-22', 'Lens Cleansing', 25)
1 row(s) inserted.
INSERT INTO Vendors VALUES (1, 'Tech Supply', 'techsupply@email.com')
1 row(s) inserted.
INSERT INTO Vendors VALUES (2, 'Digital Works', 'support@digitalworks.com')
1 row(s) inserted.
INSERT INTO Vendors VALUES (3, 'Office Gear Solutions', 'officegear@fau.edu')
1 row(s) inserted.
SELECT * FROM Employees
| EMPLOYEE_ID | FIRST_NAME | LAST_NAME | DEPARTMENT | ROLE_TITLE | 1 | Jason | Ball | OIT Leadership | Associate Provost & CIO | 2 | Christian | Block | Infrastructure | Deputy CIO | 3 | Ying | Liu | Academic Tech | Assistant Provost | 4 | Lucy | Martucci | Fiscal Management | Director | 5 | Zachary | Macdonald | Client Support | Manager | 6 | Jennifer | Turner | Enterprise Support | Associate Director |
|---|
SELECT * FROM Equipment
| EQUIPMENT_ID | EQUIPMENT_NAME | EQUIPMENT_TYPE | PURCHASE_DATE | CONDITION_STATUS | 1 | HP Monitor | Laptop | 10-MAY-24 | Good | 2 | Dell Laptop | Peripheral | 05-JAN-24 | Good | 3 | Xfinity Router | Network | 15-MAR-24 | Needs Repair | 4 | MacBook Pro | Computer | 25-JUN-24 | Excellent | 5 | Logitech Mouse | Peripheral | 12-JUL-24 | Good |
|---|
SELECT * FROM Assignments
| ASSIGNMENT_ID | EMPLOYEE_ID | EQUIPMENT_ID | ISSUE_DATE | RETURN_DATE | 1 | 2 | 1 | 17-AUG-24 | - | 2 | 4 | 2 | 01-SEP-24 | - | 3 | 5 | 4 | 15-OCT-24 | - | 4 | 6 | 5 | 20-OCT-24 | - |
|---|
SELECT * FROM Maintenance
| MAINTENANCE_ID | EQUIPMENT_ID | MAINTENANCE_DATE | DESCRIPTION | COST | 1 | 2 | 15-SEP-24 | Battery Replacement | 120 | 2 | 4 | 10-OCT-24 | Firmware Update | 50 | 3 | 5 | 22-OCT-24 | Lens Cleansing | 25 |
|---|
SELECT * FROM Vendors
| VENDOR_ID | VENDOR_NAME | CONTACT_INFO | 1 | Tech Supply | techsupply@email.com | 2 | Digital Works | support@digitalworks.com | 3 | Office Gear Solutions | officegear@fau.edu |
|---|
SELECT
e.First_Name || ' ' || e.Last_Name AS Employee_Name,
e.Department,
eq.Equipment_Name,
eq.Equipment_Type,
eq.Condition_Status,
a.Issue_Date
FROM Employees e
JOIN Assignments a ON e.Employee_ID = a.Employee_ID
JOIN Equipment eq ON a.Equipment_ID = eq.Equipment_ID
| EMPLOYEE_NAME | DEPARTMENT | EQUIPMENT_NAME | EQUIPMENT_TYPE | CONDITION_STATUS | ISSUE_DATE | Christian Block | Infrastructure | HP Monitor | Laptop | Good | 17-AUG-24 | Lucy Martucci | Fiscal Management | Dell Laptop | Peripheral | Good | 01-SEP-24 | Zachary Macdonald | Client Support | MacBook Pro | Computer | Excellent | 15-OCT-24 | Jennifer Turner | Enterprise Support | Logitech Mouse | Peripheral | Good | 20-OCT-24 |
|---|
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE Assignments CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Maintenance CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Vendors CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Equipment CASCADE CONSTRAINTS';
EXECUTE IMMEDIATE 'DROP TABLE Employees CASCADE CONSTRAINTS';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
Statement processed.
CREATE TABLE Employees (
Employee_ID NUMBER PRIMARY KEY,
First_Name VARCHAR2(50),
Last_Name VARCHAR2(50),
Department VARCHAR2(100),
Role_Title VARCHAR2(100)
)
Table created.
CREATE TABLE Equipment (
Equipment_ID NUMBER PRIMARY KEY,
Equipment_Name VARCHAR2(100),
Equipment_Type VARCHAR2(50),
Purchase_Date DATE,
Condition_Status VARCHAR2(50)
)
Table created.
CREATE TABLE Assignments (
Assignment_ID NUMBER PRIMARY KEY,
Employee_ID NUMBER REFERENCES Employees(Employee_ID),
Equipment_ID NUMBER REFERENCES Equipment(Equipment_ID),
Issue_Date DATE,
Return_Date DATE
)
Table created.
CREATE TABLE Maintenance (
Maintenance_ID NUMBER PRIMARY KEY,
Equipment_ID NUMBER REFERENCES Equipment(Equipment_ID),
Maintenance_Date DATE,
Description VARCHAR2(100),
Cost NUMBER
)
Table created.
CREATE TABLE Vendors (
Vendor_ID NUMBER PRIMARY KEY,
Vendor_Name VARCHAR2(100),
Contact_Info VARCHAR2(100)
)
Table created.
INSERT INTO Employees VALUES (1, 'Jason', 'Ball', 'OIT Leadership', 'Associate Provost & CIO')
1 row(s) inserted.
INSERT INTO Employees VALUES (2, 'Christian', 'Block', 'Infrastructure', 'Deputy CIO')
1 row(s) inserted.
INSERT INTO Employees VALUES (3, 'Ying', 'Liu', 'Academic Tech', 'Assistant Provost')
1 row(s) inserted.
INSERT INTO Employees VALUES (4, 'Lucy', 'Martucci', 'Fiscal Management', 'Director')
1 row(s) inserted.
INSERT INTO Employees VALUES (5, 'Zachary', 'Macdonald', 'Client Support', 'Manager')
1 row(s) inserted.
INSERT INTO Employees VALUES (6, 'Jennifer', 'Turner', 'Enterprise Support', 'Associate Director')
1 row(s) inserted.
INSERT INTO Equipment VALUES (1, 'HP Monitor', 'Laptop', DATE '2024-05-10', 'Good')
1 row(s) inserted.
INSERT INTO Equipment VALUES (2, 'Dell Laptop', 'Peripheral', DATE '2024-01-05', 'Good')
1 row(s) inserted.
INSERT INTO Equipment VALUES (3, 'Xfinity Router', 'Network', DATE '2024-03-15', 'Needs Repair')
1 row(s) inserted.
INSERT INTO Equipment VALUES (4, 'MacBook Pro', 'Computer', DATE '2024-06-25', 'Excellent')
1 row(s) inserted.
INSERT INTO Equipment VALUES (5, 'Logitech Mouse', 'Peripheral', DATE '2024-07-12', 'Good')
1 row(s) inserted.
INSERT INTO Assignments VALUES (1, 2, 1, DATE '2024-08-17', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (2, 4, 2, DATE '2024-09-01', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (3, 5, 4, DATE '2024-10-15', NULL)
1 row(s) inserted.
INSERT INTO Assignments VALUES (4, 6, 5, DATE '2024-10-20', NULL)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (1, 2, DATE '2024-09-15', 'Battery Replacement', 120)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (2, 4, DATE '2024-10-10', 'Firmware Update', 50)
1 row(s) inserted.
INSERT INTO Maintenance VALUES (3, 5, DATE '2024-10-22', 'Lens Cleansing', 25)
1 row(s) inserted.
INSERT INTO Vendors VALUES (1, 'Tech Supply', 'techsupply@email.com')
1 row(s) inserted.
INSERT INTO Vendors VALUES (2, 'Digital Works', 'support@digitalworks.com')
1 row(s) inserted.
INSERT INTO Vendors VALUES (3, 'Office Gear Solutions', 'officegear@fau.edu')
1 row(s) inserted.
SELECT * FROM Employees
| EMPLOYEE_ID | FIRST_NAME | LAST_NAME | DEPARTMENT | ROLE_TITLE | 1 | Jason | Ball | OIT Leadership | Associate Provost & CIO | 2 | Christian | Block | Infrastructure | Deputy CIO | 3 | Ying | Liu | Academic Tech | Assistant Provost | 4 | Lucy | Martucci | Fiscal Management | Director | 5 | Zachary | Macdonald | Client Support | Manager | 6 | Jennifer | Turner | Enterprise Support | Associate Director |
|---|
SELECT * FROM Equipment
| EQUIPMENT_ID | EQUIPMENT_NAME | EQUIPMENT_TYPE | PURCHASE_DATE | CONDITION_STATUS | 1 | HP Monitor | Laptop | 10-MAY-24 | Good | 2 | Dell Laptop | Peripheral | 05-JAN-24 | Good | 3 | Xfinity Router | Network | 15-MAR-24 | Needs Repair | 4 | MacBook Pro | Computer | 25-JUN-24 | Excellent | 5 | Logitech Mouse | Peripheral | 12-JUL-24 | Good |
|---|
SELECT * FROM Assignments
| ASSIGNMENT_ID | EMPLOYEE_ID | EQUIPMENT_ID | ISSUE_DATE | RETURN_DATE | 1 | 2 | 1 | 17-AUG-24 | - | 2 | 4 | 2 | 01-SEP-24 | - | 3 | 5 | 4 | 15-OCT-24 | - | 4 | 6 | 5 | 20-OCT-24 | - |
|---|
SELECT * FROM Maintenance
| MAINTENANCE_ID | EQUIPMENT_ID | MAINTENANCE_DATE | DESCRIPTION | COST | 1 | 2 | 15-SEP-24 | Battery Replacement | 120 | 2 | 4 | 10-OCT-24 | Firmware Update | 50 | 3 | 5 | 22-OCT-24 | Lens Cleansing | 25 |
|---|
SELECT * FROM Vendors
| VENDOR_ID | VENDOR_NAME | CONTACT_INFO | 1 | Tech Supply | techsupply@email.com | 2 | Digital Works | support@digitalworks.com | 3 | Office Gear Solutions | officegear@fau.edu |
|---|
SELECT
e.First_Name || ' ' || e.Last_Name AS Employee_Name,
e.Department,
eq.Equipment_Name,
eq.Equipment_Type,
eq.Condition_Status,
a.Issue_Date
FROM Employees e
JOIN Assignments a ON e.Employee_ID = a.Employee_ID
JOIN Equipment eq ON a.Equipment_ID = eq.Equipment_ID
| EMPLOYEE_NAME | DEPARTMENT | EQUIPMENT_NAME | EQUIPMENT_TYPE | CONDITION_STATUS | ISSUE_DATE | Christian Block | Infrastructure | HP Monitor | Laptop | Good | 17-AUG-24 | Lucy Martucci | Fiscal Management | Dell Laptop | Peripheral | Good | 01-SEP-24 | Zachary Macdonald | Client Support | MacBook Pro | Computer | Excellent | 15-OCT-24 | Jennifer Turner | Enterprise Support | Logitech Mouse | Peripheral | Good | 20-OCT-24 |
|---|
SELECT * FROM Employees
| EMPLOYEE_ID | FIRST_NAME | LAST_NAME | DEPARTMENT | ROLE_TITLE | 1 | Jason | Ball | OIT Leadership | Associate Provost & CIO | 2 | Christian | Block | Infrastructure | Deputy CIO | 3 | Ying | Liu | Academic Tech | Assistant Provost | 4 | Lucy | Martucci | Fiscal Management | Director | 5 | Zachary | Macdonald | Client Support | Manager | 6 | Jennifer | Turner | Enterprise Support | Associate Director |
|---|
SELECT * FROM Equipment
| EQUIPMENT_ID | EQUIPMENT_NAME | EQUIPMENT_TYPE | PURCHASE_DATE | CONDITION_STATUS | 1 | HP Monitor | Laptop | 10-MAY-24 | Good | 2 | Dell Laptop | Peripheral | 05-JAN-24 | Good | 3 | Xfinity Router | Network | 15-MAR-24 | Needs Repair | 4 | MacBook Pro | Computer | 25-JUN-24 | Excellent | 5 | Logitech Mouse | Peripheral | 12-JUL-24 | Good |
|---|
SELECT * FROM Assignments
| ASSIGNMENT_ID | EMPLOYEE_ID | EQUIPMENT_ID | ISSUE_DATE | RETURN_DATE | 1 | 2 | 1 | 17-AUG-24 | - | 2 | 4 | 2 | 01-SEP-24 | - | 3 | 5 | 4 | 15-OCT-24 | - | 4 | 6 | 5 | 20-OCT-24 | - |
|---|
SELECT * FROM Maintenance
| MAINTENANCE_ID | EQUIPMENT_ID | MAINTENANCE_DATE | DESCRIPTION | COST | 1 | 2 | 15-SEP-24 | Battery Replacement | 120 | 2 | 4 | 10-OCT-24 | Firmware Update | 50 | 3 | 5 | 22-OCT-24 | Lens Cleansing | 25 |
|---|
SELECT * FROM Vendors
| VENDOR_ID | VENDOR_NAME | CONTACT_INFO | 1 | Tech Supply | techsupply@email.com | 2 | Digital Works | support@digitalworks.com | 3 | Office Gear Solutions | officegear@fau.edu |
|---|