Question
Delicious Urban Delights, Inc. A Database Project © 2016 G. P. Marquis Firm Background The Delicious Urban Delights (DUD) company caters a variety of events locally. They cater to corporate events, government events, charity events, and private events. Lately their good reputation has been compromised due to late arrival of the food and some tainted food. To counter this negative reputation the company has initiated a drive to have their employees volunteer at the charity activities of their choice. To manage this activity and reward their employees appropriately they need a database to keep track of the employees, the charitable organizations that they have been aided, and the volunteered hours each employee contributed to each charity by date Suggested tables for this project are: EMPLOYEE Emp-ID, Emp-Fname, Emp-Lname, Emp-Hire-Date) CHARITY (Char-ID, Char-Description, Char-Contact, Char-Phone) HOURS (Hr-ID. Hr-Emp-ID, Hr-Char-ID, Hr-Date, Hr-Hours) Management wants two reports Employee Hours Report (last name, first name, charity, hours) hours totaled for each charity for each employee and a grand total ariuport( charity, last name, fist name, hours) hours totaled for each employee for each charity and a grand total Current employees are: First Name Last Name Hire Date 5/8 /2013 3 /15/2014 harles Adams 3/15/2014 Adams Baker Charles David Current Charities supported are: harity Name ed Cross Blood Drive econd Harvest Food BankIra Feeder ntact Person Phone No. an Pyre (615) 789-1414 (615) 969-1234 Page 1 of 2 v2
Explanation / Answer
creation of employee table
create table Employee
(
Emp-Id int,
Emp-Fname varchar2(20),
Emp-Lname varchar2(20),
Emp-Hire-Date date
);
Insertion of data into employee table
insert into Employee values('Amy','Adams','5/8/2013');
insert into Employee values('Boris','Baker','3/15/2014');
insert the remaining data by using above syntax
create the other two tables as Employee table and insert the data into respected tables
to update the details of the employees use below syntax
UPDATE Employees //table name
SET Emp-Fname='Ammy' //what do you want to change
WHERE Emp-Fname='Amy' ;//the respected column or row you want to update
