Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Map the following ER diagrams into the most efficient relational database schema: (0, N) Employee (1,1) has Dependent ssn Ename frame Bdate Select a O

image text in transcribed

image text in transcribed

Map the following ER diagrams into the most efficient relational database schema: (0, N) Employee (1,1) has Dependent ssn Ename frame Bdate Select a O a. Employee (ssn, ename), Dependent (fname, Bdate) O b. Employee (ssn, ename), Dependent (fname, Bdate, employee_ssn) O c. Employee (ssn, ename), Dependent (fname, Bdate), has (employee_ssn, dependent fname) O d. Employee (ssn, ename, dependent_fname), Dependent (fname, Bdate) Given this table and the query: EMPLOYEE Fname Minit John Franklin 5 Alicia T J S Jennier Lname Bdate Address Sex | Salary | Super San Dno Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX 25000 987654321 Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000888665555 Narayan | 666884444 1962-09-15 975 Fire Oak. Humble, TX M 38000 933445555 5 English 453453453 1972-07-31 5831 Rice, Houston, TX 25000 333445555 TODOS 980 Dallas, Houston, TX M 25000 987654321 Borg 888665555 | 1937-11-10 450 Stone, Houston, TX M 55000 NULL Ramesh Joy 5 Aha I Sex, Salary (o Sex="F" (EMPLOYEE)) How many rows are returned? Select one: O a. 8 b. 10 c. 3 O d. 2

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

Relational Database Design A Practical Approach

Authors: Marilyn Campbell

1st Edition

1587193175, 978-1587193170

Students also viewed these Databases questions