1. Given the followving relation that stores details about students' activities:ActivityFee AmountPaid65.00StudentID StudentNameActivityGolf100Jones65.00100JonesSkiingSkiing200.000.00200Davis200.000.00200DavisSwimmingSkiingSwimming 50.0050.0050.00300Garrett200.00100.00300Garrett50.00400JonesGolf65.0065.00400Swimming 50.00Jones50.00If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE.StudentID → StudentNameStudentID , StudentName → ActivityActivity > ActivityFeeActivity → StudentIDStudentID → ActivityStudentID → AmountPaid||

here have to determine functional dependencies with given relation.

1. Given the following relation that stores details about students' activities: StudentID StudentName ActivityFee AmountPaid Activity Golf 100 Jones 65.00 65.00 Skiing Skiing Swimming 50.00 100 Jones 200.00 0.00 200 Davis 200.00 0.00 200 Davis 50.00 300 Garrett Skiing Swimming 50.00 Golf 200.00 100.00 300 Garrett 50.00 400 Jones 65.00 65.00 Jones Swimming 50.00 400 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 888333

1. Given the following relation that stores details about students' activities: StudentID StudentName ActivityFee AmountPaid Activity Golf 100 Jones 65.00 65.00 Skiing Skiing Swimming 50.00 100 Jones 200.00 0.00 200 Davis 200.00 0.00 200 Davis 50.00 300 Garrett Skiing Swimming 50.00 Golf 200.00 100.00 300 Garrett 50.00 400 Jones 65.00 65.00 Jones Swimming 50.00 400 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 888333

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID EMP_HIRE_DATE STUDENT P ID STUDY ΜAIOR PK, FK1 PK, FK1 19. Which of the following statements is/are true? (1) A Person must be either a Student or an Employee. (2) A Person can neither be a Student nor an Employee. (3) A Person must be a Student or an Employee or both. a. (1) only b. (3) only c. (1) and (2) only d. (1), (2) and (3).
11. Foreign key is the one in which the ________ of one relation is referenced in another relation. a. Foreign key b. Primary key c. References d. Check constraint
In the NONCAT table, change the description of item ID DT12 to Dog Toy Gift Bonanza.
Look up student MAJOR and ROOM information based on the student NAME. Enter formula into B2. 1 NAME MAJOR ROOM 2 58 3 4 NAME MAJOR ROOM 5 $1 CIS DBH 6 S2 7 3 A/F DBH A/F DBH 8 $4 мом SCI 9 S5 мом DBH 10 56 CIS SCI 11 S7 CIS DBH 12 S8 A/F 13 S9 мом 14 S10 CIS Size Color Price Item T. 15 Size L T M 16 Color R. 17 Price 28 H. 29 30 XL R. 18
• Write a simple stored function that Takes a gender as an input ● Find the staff whose gender matches the input Return the results Write a simple stored procedure that Takes a gender as an input Find the staff whose gender matches the input • Print the results
q15- Please choose all that apply
q20- Choose ALL that apply.
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. What are the student ID, the names, and birthday of the female students who were born before the last day of 1992? 2. How many students are registered in the course “PHY210”? 3. How many courses are offered by the department of Computer Science (i.e. course codes CS***)? 4. Which course(s) (couseCode and courseName) of level G1 give 5 credits?
ABC department store keeps information on departments, products, and employees. For each department, the department ID, name and office phone extension are stored. For each employee, the employee ID, and name are stored. A department can have many employees and each employee can be assigned to multiple departments. Each department is managed by one employee. Each department sells many products and each product is sold by only one department. Products can be shoes, clothes, or other miscellaneous. The product ID and price are stored for each product. No additional data is stored for the miscellaneous products. For all shoes, shoe type, shoe color and shoe size are also stored. For all clothes, the season (one of: winter, spring, summer, year-round) is stored. Clothes can be shirts, pants or dresses. For shirts, collar size, sleeve size and type are stored. For pants, waist size, length and type are stored. For dresses, size, and type are stored. Draw the Crow’s foot ERD (including all…