Question
The database is the employee database slightly revised from textbook with an attribute start-date added for the manages relation. Purpose of this change is to
The database is the employee database slightly revised from textbook with an attribute start-date added for the manages relation. Purpose of this change is to practice the date data type. Start-date indicates the date from which the employee is supervised by his or her manger. Employee (Lastname, FirstName, MidInitial, gender, street, city) Works (Lastname, FirstName, MidInitial, company-name, salary) company (company-name, city) Manages(Lastname, FirstName, MidInitial, ManagerLastname, MFirstName, MMidInitial, start-date) (Note: Start-date indicates the starting date on which a manager starts supervising a particular employee; so different employees under the same manager may have different starting dates.) Employee (you should define three attributes for employee and manager names) Name street city gender Anderson, Susan L 108th Omaha F Brady, Dan L P street Lincoln M Chen, Peter K 124th Omaha M Clemson, Ann M O Lincoln F Dale, Mary K 132th Omaha F Gill, Mary L P street Lincoln F Harrison, Susan M Old Mill Omaha F Jackson, Kim A 178th Omaha F Jason, Pat M 8th C.Bluffs M Kumar, Paul T Dodge Omaha M Orr, Susanne S Q Omaha F Peterson, Mike E Blondo Omaha M Powell, Tom E Broadway C.Bluffs M Quinn, Jacky M 168st Omaha F Rand, Pam R 13st Omaha F Schreck, Ann P 214st Elkhorn F Simon, Eric K 77th Lincoln M Smith, John A 8th C.Bluffs M Thomson, Ron F Farnam Omaha M Young, Don R Wong, Carole s Dodge Broadway Omaha M C.Bluffs F Works: (Again, you should define three attributes for employee name) employee_name company_name salary Anderson, Susan L Mutual of Omaha 48000 Brady, Dan L FDR 42000 Chen, Peter K FDR 53000 Clemson, Ann M First Bank 39000 Dale, Mary K Mutual of Omaha 58000 Gill, Mary L Union Pacific 48700 Harrison, Susan M Union Pacific 54320 Jackson, Kim A FDR 68000 Jason, Pat M FDR 83000 Kumar, Paul T FDR 44000 Orr, Susanne S Lincoln Star 32000 Peterson, Mike E First Bank 37000 Powell, Tom E First Bank 54000 Quinn, Jacky M First Bank 85000 Rand, Pam R FDR 37000 Schreck, Ann P First Bank 36000 Simon, Eric K Mutual of Omaha 45000 Smith, John A FDR 55000 Thomson, Ron F First Bank 39000 Young, Don R Mutual of Omaha 27000 Wong, Carole S First Bank 44000 Company: company_name city First Bank FDR Lincoln Star Mutual of Omaha Union Pacific Omaha Omaha Lincoln Omaha Omaha Manages (Note: both employee and manager names should include three attributes): employee_name manager_name start date Anderson, Susan L Dale, Mary K 15-SEP-2002 Brady, Dan L Jason, Pat M 05-MAR-2004 Chen, Peter K Jason, Pat M 12-JUNE-2003 Clemson, Ann M Powell, Tom E 30-AUG-2001 Gill, Mary L Harrison, Susan M 25-JAN-2003 Jackson, Kim A Kumar, Paul T Rand, Pam R Peterson, Mike E Schreck, Ann P Simon, Eric K Smith, John A Thomson, Ron F Wong, Carole S Young, Don R Jason, Pat M 09-MAY-2008 Jason, Pat M 09-MAY-2001 Smith, John A 15-JAN-2004 Powell, Tom E 30-AUG-2006 Quinn, Jacky M 28-FEB-1996 Anderson, Susan L 22-FEB-2004 Jason, Pat M 05-MAR-2003 Powell, Tom E 30-AUG-1998 Quinn, Jacky M 28-FEB-2001 Dale, Mary K 15-SEP-2007
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started