Question: Write Five Super Keys but they are not keys from the tables given in figure 3.6. You have to explain clearly why they are not
Write Five Super Keys but they are not keys from the tables given in figure 3.6. You have to explain clearly why they are not Keys.
6 algebra_storage.ppt company database Figur One possible database state for the COMPANY relational database schema EMPLOYEE Fname Minit Lname Sex B Smith 123456780 1965-01-09 231 Fonden Houstons TX M 30000 333445555 5 Franklin T Wong 333445656 1955-108 638 oss,Houston TX M 40000 888665555 5 AliiaZelaya 999887777 1968-0119 3321 Castle, Speing TX F 25000 9876543214 S Wlace : 9ere 5432 119410620|201 Berry, Blar. T-F 8886655551 43000 4 Ramesh K Narayan 666884444 1962-09-15 976 Fire Ok, Humble, TX M 38000 3334455555 oyoA Enoish 453453453 1972-07-31 5631 Rice. Hovsion TX F 25000 33344565 5 Ahmad V bbr 987987987 1069032990Houaton, TX M 25000 07654321 lanes | E | Borg | 888665565 1937-11-101450 St re,Houston, TX | M | 55000|NULL DEPARTMENT DEPT LOCATIONS Oname Deumber MgnMoy star date 333445555 87654321 1988-05-22 19950101 981-08-10 Administration Bellaire WORKS ON PROJECT Esan 123456780 23456789 ho Hour Pname Bellaire 340.0 Product 453453453 20.0 210.0 3 10.0 Computeriation 10 Stalford 20 Houston 30 Stafford 333445555 00 DEPENDENT 333445555 2 10. 99988777730 999887777 8798798 987987907 101100 35.0 30 5.o 30 20.0 333445555 Aice 333445555 Thoodore 333445555J 87654321 Aner 23456789Michael F 1986-04-05 Daught M 1983-10-25 Son F 1958-05-03 Spouse M 1942-02-28 Spouse M | 1960-01-04 | Son 98765432 888665555 20 NULL 123456789 1234567 abeth 1988-12-30 Daughter 1967-05-0 Spous [EN] example Figure 6 Figure 6.5 The CARTESIAN PROOUCT (CROSS PRODUCT) operation FEMALE EMPS Fae Mot Lnane Sen Supersn 6 algebra_storage.ppt company database Figur One possible database state for the COMPANY relational database schema EMPLOYEE Fname Minit Lname Sex B Smith 123456780 1965-01-09 231 Fonden Houstons TX M 30000 333445555 5 Franklin T Wong 333445656 1955-108 638 oss,Houston TX M 40000 888665555 5 AliiaZelaya 999887777 1968-0119 3321 Castle, Speing TX F 25000 9876543214 S Wlace : 9ere 5432 119410620|201 Berry, Blar. T-F 8886655551 43000 4 Ramesh K Narayan 666884444 1962-09-15 976 Fire Ok, Humble, TX M 38000 3334455555 oyoA Enoish 453453453 1972-07-31 5631 Rice. Hovsion TX F 25000 33344565 5 Ahmad V bbr 987987987 1069032990Houaton, TX M 25000 07654321 lanes | E | Borg | 888665565 1937-11-101450 St re,Houston, TX | M | 55000|NULL DEPARTMENT DEPT LOCATIONS Oname Deumber MgnMoy star date 333445555 87654321 1988-05-22 19950101 981-08-10 Administration Bellaire WORKS ON PROJECT Esan 123456780 23456789 ho Hour Pname Bellaire 340.0 Product 453453453 20.0 210.0 3 10.0 Computeriation 10 Stalford 20 Houston 30 Stafford 333445555 00 DEPENDENT 333445555 2 10. 99988777730 999887777 8798798 987987907 101100 35.0 30 5.o 30 20.0 333445555 Aice 333445555 Thoodore 333445555J 87654321 Aner 23456789Michael F 1986-04-05 Daught M 1983-10-25 Son F 1958-05-03 Spouse M 1942-02-28 Spouse M | 1960-01-04 | Son 98765432 888665555 20 NULL 123456789 1234567 abeth 1988-12-30 Daughter 1967-05-0 Spous [EN] example Figure 6 Figure 6.5 The CARTESIAN PROOUCT (CROSS PRODUCT) operation FEMALE EMPS Fae Mot Lnane Sen Supersn
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
