Alert dont submit AI generated answer. Given the two following relations, what attribute of PROJECT could have a foreign keyconstraint referring to the DEPARTMENT table?DEPARTMENTDnameResearchAdministrationHeadquartersPROJECTPnameProductXProductYProductZComputerizationReorganizationNewbenefitsPlocationOPnumberO DnumOPnameDnumber541Pnumber Plocation1Bellaire2Sugarland3Houston102030StaffordHoustonStaffordDnum555514Mgr_ssn333445555987654321888665555Mgr_start_date1988-05-221995-01-011981-06-19J

Resources must be efficiently managed and coordinated for organizations to fulfill their goals and…

Given the two following relations, what attribute of PROJECT could have a foreign key constraint referring to the DEPARTMENT table? DEPARTMENT Dname Research Administration Headquarters PROJECT Pname ProductX ProductY ProductZ Pnumber Plocation 1 Bellaire 2 Sugarland 3 Houston Computerization 10 20 Reorganization Newbenefits 30 O Plocation O Pnumber O Dnum Dnumber OPname 5.M 1 Stafford Houston Stafford Dnum 5 5 5 4 1 4 Mgr_ssn 333445555 987654321 888665555 Mgr_start_date 1988-05-22 1995-01-01 1981-06-19

Given the two following relations, what attribute of PROJECT could have a foreign key constraint referring to the DEPARTMENT table? DEPARTMENT Dname Research Administration Headquarters PROJECT Pname ProductX ProductY ProductZ Pnumber Plocation 1 Bellaire 2 Sugarland 3 Houston Computerization 10 20 Reorganization Newbenefits 30 O Plocation O Pnumber O Dnum Dnumber OPname 5.M 1 Stafford Houston Stafford Dnum 5 5 5 4 1 4 Mgr_ssn 333445555 987654321 888665555 Mgr_start_date 1988-05-22 1995-01-01 1981-06-19

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 16RQ

See similar textbooks

Similar questions

PRACTICE ACTIVITY FOR JOINS (using APEX) Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad Tamil A105 A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 D103 IT BSD D104 ENG Table name: STUDENTS | STUDENTID GENDER STUDENTNAME DOB ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE S103 6/1/1999 Male 90 D102 A102 Level 1 Hisham 22 S102 Sara 12/30/1994 Female 45 D103 A104 Diploma 27 6/1/1999 Male 5/6/1995 Male S101 Salim 45 D103 A104 Diploma 22 S107 Khalil 45 D101 A101 BTech 26 S109 Said 10/15/1992 Male 45 D104 A101 Advanced Diploma 29 S100 Ahmad 5/1/1995 Male 45 D101 A103 BTech 26 4/5/1998 Male 2/23/1992 Female S104 Faisal 90 D104 A101 Advanced Diploma 23 S105 Fatima 90 D102 A102 Level 2 29 S106 Arwa 9/12/1999 Female 45 D102 A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 0103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student…
a) Put the following relation in BCNF: STUDENT_ACTIVITY STUDENT_ACTIVITY (StudentID, StudentName, Activity, ActivityFee, AmountPaid) StudentID StudentName Activity ActivityFee AmountPaid 1 100 Jones Golf 65.00 65.00 2 100 Jones Skiing 200.00 0.00 3 200 Davis Skiing 200.00 0.00 4 200 Davis Swimming 50.00 50.00 5 300 Garret Skiing 200.00 100.00 6 300 Garrett Swimming 50.00 50.00 7 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00 b) Put the following relation in BCNF: Student(SSN, sName, address, HScode, HSname, HScity,GPA, priority) Assuming a student can attend more than one high school, and priority is determined by GPA
Task Description: consider the following relations for a university: Student (sid: integer, sname: string, GPA: real, dateOfBirth: date) Department (did: integer, dname: string, capacity: integer) Course (cid: integer, cname: string, credit: integer) Enroll (studentID: integer, courselD: integer, departmentID: Integer, enrollmentDate: date) studentlD, courselD, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively.
A relation FarmVisit is defined below with attributes in the table headings. FarmVisit visitorID visitorName date farmID farmName t1 H001 John 1 Feb 2021 A10 Green Field t2 Н005 Ashley 1 Jan 2021 A10 Green Field t3 но05 Ashley 1 Feb 2021 A10 Green Field t4 H005 Ashley 15 Apr 2021 H02 Есо t5 Но06 Ashley 15 Apr 2021 A11 Green Field a) Write down examples of tuples (i.e., tl, t2) to show neither of the following is a functional dependency: (i) visitorID -> date (ii) date -> farmID b) Write down the functional dependency (FDs) using the above data, which can represent all possible data. The FDs should be non-trivial and the determinants of the FDs should contain minimal number of attributes required. c) Using the tuples given, can (visitorID, farmID) be the primary key of FarmVisit? Explain why. d) What the highest normal form by which the FarmVisit relation can be classified? Explain why.
1. Given the followving relation that stores details about students' activities: ActivityFee AmountPaid 65.00 StudentID StudentName Activity Golf 100 Jones 65.00 100 Jones Skiing Skiing 200.00 0.00 200 Davis 200.00 0.00 200 Davis Swimming Skiing Swimming 50.00 50.00 50.00 300 Garrett 200.00 100.00 300 Garrett 50.00 400 Jones Golf 65.00 65.00 400 Swimming 50.00 Jones 50.00 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. StudentID → StudentName StudentID , StudentName → Activity Activity > ActivityFee Activity → StudentID StudentID → Activity StudentID → AmountPaid ||
Given the following relation that stores details of employees and their projects: ProjectID EmployeeName EmployeeSalary 100-A Salim Housni 2000 100-A Taleb Maashani 1800 100-B Taleb Maashani 1800 200-A Salmi Alrisi 2000 200-B Salmi Alrisi 2000 200-C Salmi Alrisi 1350 200-C Taleb Maashani 1800 200-D Salim Housni 1350 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. ProjectID > EmployeeName | ProjectID > EmployeeSalary| ProjectID, EmployeeName > EmployeeSalary | EmployeeName > EmployeeSalary | EmployeeSalary > ProjectID EmployeeSalary → EmployeeName , ProjectID
.Here it isstudent Relation Student_ID Student_Name Dept_Name 0000 AAAAA Computer Science 1111 BBBBB Computer Science 2222 CCCCC Business Administration 3333 DDDDD Education 4444 EEEEE Physics 5555 FFFFF History Student_Courses Relation Student_ID Course_ID Section Year Grade 0000 CS 2203 2 2020 A 0000 CS 1101 1 2019 A 1111 CS 1101 5 2019 B 1111 CS 1102 1 2019 B 1111 CS 2204 1 2020 A 1111 CS 2401 1 2020 A 2222 BUS 1101 3 2019 C 2222 BUS 2201 1 2020 B 2222 BUS 3302 1 2020 B 3333 EDUC 5010 1 2019 A 3333 EDUC 5210 1 2020 B 4444 PHY 1101 4 2019 A 4444 PHY 2202 1 2020 C 4444 PHY 3304 1 2020 A Considering Student and Student_Courses relations shown above, discuss when Union, Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join should be used and provide examples using the above relations. I AM GETTING USED TO MYSQL WORKBENCH. (Kindly take me through the path)?
5. Given the following Relations in a DBMS write the output of the queries, in tuple form with attribute labels. EMPLOYEE Fname Minit Lname Ssn Sex Salary Super_ssn Dno 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 M 40000 888665555 J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 F 43000 888665555 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 A English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 v Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL Bdate Address John в Smith Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX Alicia 4 Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Jennifer 4 Ramesh K Joyce 5 Ahmad 4 James E Borg DEPARTMENT DEPT LOCATIONS Dname Dnumber Mgr_ssn Mgr_start_date Dnumber Dlocation Research 5 333445555 1988-05-22 Houston Administration 4 987654321 1995-01-01 4 Stafford Headquarters…
Observe the table ENROLLMENT: ENROLLMENT StudentID StudentName MajorID MajorName 111 Joe E English 222 Bob H History 333 Lisa H History Which of the following (regarding the relation ENROLLMENT) represents the deletion anomaly? O Deleting a major ID may delete the major name O Deleting a major may delete all information about a student O None of the answers O Deleting a student ID may delete a student name O Deleting a student may delete all information about a major
Given the following relation that stores details of employees and their projects: ProjectID EmployeeName EmployeeSalary 100-A Salim Housni 2000 100-A Taleb Maashani 1800 100-B Taleb Maashani 1800 200-A Salim Housni 2000 200-B Salim Housni 2000 200-C Salim Housni 1350 200-C Taleb Maashani 1800 200-D Salim Housni 1350 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE ProjectID --> EmployeeName (....) ProjectID --> EmployeeSalary (....) ProjectID , EmployeeName -->EmployeeSalary (....) EmployeeName --> EmployeeSalary (....) EmployeeSalary --> ProjectID (....) EmployeeSalary --> EmployeeName , ProjectID (....)
A candidate key is a characteristic that is included in a composite primary key.
Task Description: consider the following relations for a university: Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer) Department (did: integer, dname: string(30 chars), capacity: integer) Course (cid: integer, cname: string(50 chars), credit: integer) Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. Using SQL, develop and execute the following queries: 1- For each student with GPA between 2.5 (included) and 3.5 (included), display the student’s name, GPA,and his/her department ID. Sort the results by the students’ IDs in descending order. 2- For each student who joined the Computer Science department between 2018…