a) Put the following relation in BCNF:STUDENT_ACTIVITYSTUDENT_ACTIVITY (StudentID, StudentName, Activity, ActivityFee,AmountPaid)StudentID StudentName ActivityActivityFee AmountPaid1100JonesGolf65.0065.002100JonesSkiing200.000.003200DavisSkiing200.000.004200DavisSwimming 50.0050.005300GarretSkiing200.00100.006300GarrettSwimming 50.0050.007400JonesGolf65.0065.00400JonesSwimming 50.0050.00b) 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

please see the next step for solution

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 100 Jones Skiing 200.00 0.00 3 200 Davis Skiing 200.00 0.00 4 200 Davis Swimming 50.00 50.00 300 Garrett Skiing 200.00 100.00 6 300 Garrett Swimming 50.00 50.00 7 400 Jones Golf 65.00 65.00 8 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

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 100 Jones Skiing 200.00 0.00 3 200 Davis Skiing 200.00 0.00 4 200 Davis Swimming 50.00 50.00 300 Garrett Skiing 200.00 100.00 6 300 Garrett Swimming 50.00 50.00 7 400 Jones Golf 65.00 65.00 8 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

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

q15
What three situations make it necessary to make a substitute key instead of the main key of a relation?
Which of the following is true? BCNF and 3NF are same. A relation in BCNF is always in ONF A relation in BCNF is not in 3NE A relation in 3NF is always in BCNF.
In the figure below, STUDENT relation has a composite primary key contains Stud_ID and Course_ID. This relation is STUDENT Stud ID Name Course ID Units 101 Lennon MSI 250 3.00 101 Lennon MSI 415 3.00 125 Johnson MSI 331 3.00
convert it to relations that are normalization
None
Name of subject: Database Programming Display the name of supplier(s) that supplied the most expensive computer? Note: Use Subqueries
Write the relations clearly showing the Primary key bolded and underlined (e.g., CustomerId). Foreign key shown in italics (e.g., OrderNumber) and separately defined beneath the relation (e.g., ShoppingCart OrderNumber FK to Order OrderNumber)
Consider the following relational schema. titles employees emp_ne NUMERICE 0) emp ne NUMERICEO) title CHARACTER VARYING) from date DATE to date DATE birth date DATE first mame CHARACTER VARYING(14 last name CHARACTER VARYING(16) gender CHARACTER) hire date DATE salaries emp ne NUMERICE0) salary NUMERIC6.0) from_date DATE te date DATE dept_manager dept_no CHARACTERIA emp no ERICISO from date DATE to date DATE departments dept ne CHARACTERIA) dept_name CHARACTER VARYINOJAO) dept_emp emp ne NUMERICS dept ne CHARACTER() from date DATE date DATE The salaries table has the primary key named emp_no. The titles table has the primary key named emp_no. • The employees table has the primary key named emp_no. The dept_manager table has the composite primary key named (dept_no, emp_no). The dept_emp table has the composite primary key named (emp_no, dept_no). The departments table has the primary key named dept_no. The salaries table has a foreign key column named emp_no that references the…
The process of decomposing a relations into two relations is called: Select one: O Denormalization O Nested relation Normalization Values in a tuple are not considered atomic. Select one: O True O False Which of the following SQL statements drop the HOAPITAL schema? Select one: O DROP SCHEMA COMPANY AUTHORIZATION "SAM"; O DROP HOAPITAL CASCADE; O DROP SCHEMA HOAPITAL CASACDE; O DROP HOAPITAL AUTHORIZATION 'Ali"; None
Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-31 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary)