Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Wireless and Mobile Systems

Authors: Dharma P. Agrawal, Qing An Zeng

4th edition

1305087135, 978-1305087132, 9781305259621, 1305259629, 9781305537910 , 978-130508713

More Books

Students also viewed these Programming questions

Question

Solve the integral:

Answered: 1 week ago

Question

What is meant by Non-programmed decision?

Answered: 1 week ago

Question

What are the different techniques used in decision making?

Answered: 1 week ago

Question

How to refer textbook solutions on chegg mobile app

Answered: 1 week ago

Question

=+b. Using s 5 0.0125, a 5 .05, and Appendix Table 5,

Answered: 1 week ago