Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Model the following scenario: Each employee has a unique employeeid, employee name and an address. Each employee is either a full time employee or a

Model the following scenario: Each employee has a unique employeeid, employee name and an address. Each employee is either a full time employee or a part time employees. Only full time employees are enrolled in a benefits package. A benefits package includes benefits package id, health-plan name and retirement plan name. Only Part-time employees submit time-sheets. A time sheet includes time sheet id, begin date, end date and hours worked.

Create a relational model for the following ERD

image text in transcribed

Consider the following tables. Write an SQL query that lists the department name and the total salary for that department when the department has more than 1 employee.

EmpID

Name

Salary

DeptID

1

Sharona

70245

1

2

Jeanne

68456

2

3

Harv

98334

5

4

Aguie

66956

1

5

Nessie

98234

3

6

Lesley

84555

2

7

Alexis

90490

5

8

Alaster

58903

3

9

Margarette

77880

2

10

Rickert

56768

4

DeptID

DeptName

1

Training

2

Business Development

3

Marketing

4

Accounting

5

Product Management

2. Create a relational model for the following ERD AlphaOne RelA RelB BetaOne BetaTwo A EntityBeta EntbylphalatonshoAEnthyeta elationshipA AlphaTwo BetaThree

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_2

Step: 3

blur-text-image_3

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

AWS Certified Database Study Guide Specialty DBS-C01 Exam

Authors: Matheus Arrais, Rene Martinez Bravet, Leonardo Ciccone, Angie Nobre Cocharero, Erika Kurauchi, Hugo Rozestraten

1st Edition

1119778956, 978-1119778950

More Books

Students also viewed these Databases questions

Question

=+1. How do psychologists define memory?

Answered: 1 week ago

Question

Identify global safety and health issues.

Answered: 1 week ago

Question

Discuss health care in the global environment.

Answered: 1 week ago