Question 2: For the following table find the relevant Functional Dependencies and resolve themtill third normal form.Course CodeCourse TitleLevelMode of AttendanceCourse FeeStart DateEnd DateStudentID Num.141111433214378StudentNameAlan BriggsSusanMcBrideDavid Adair23Business Accounting3Part Time£55.0020/08/201624/08/2016StudentAddress24 Abbey Park,Bangor, BT191RT19 BelmontRoad, Bangor,BT19 3TR14 Grange Park,Bangor, BT194TFStudentTelephone028 9146866507798754623DepartmentTutorDept HeadStudentDOB10/08/94BusinessTrevor AlbrightMr Alan Parkes028 91584630 06/11/8707891834277toEnrolmentDate10/06/16028 91488930 01/03/93 03/07/160789145423505/07/16Enrolled By:-Andrea GilchristDavid SmytheAndrea Gilchrist

Third normal form: The Third Normal Form (3NF) is a normal form used in the normalization process of…

Question 2: For the following table find the relevant Functional Dependencies and resolve them till third normal form. Course Code Course Title Level Mode of Attendance Course Fee Start Date End Date Student ID Num. 14111 14332 14378 Student Name Alan Briggs Susan McBride David Adair 23 Business Accounting 3 Part Time £55.00 20/08/2016 24/08/2016 Student Address 24 Abbey Park, Bangor, BT19 IRT 19 Belmont Road, Bangor, BT19 3TR 14 Grange Park, Bangor, BT19 4TF Student Telephone 028 91468665 07798754623 028 91488930 07891454235 Department Tutor Dept Head Student DOB 10/08/94 01/03/93 Business Trevor Albright Mr Alan Parkes Enrolment Date 10/06/16 03/07/16 028 91584630 06/11/87 05/07/16 07891834277 Enrolled By:- Andrea Gilchrist David Smythe Andrea Gilchrist

Question 2: For the following table find the relevant Functional Dependencies and resolve them till third normal form. Course Code Course Title Level Mode of Attendance Course Fee Start Date End Date Student ID Num. 14111 14332 14378 Student Name Alan Briggs Susan McBride David Adair 23 Business Accounting 3 Part Time £55.00 20/08/2016 24/08/2016 Student Address 24 Abbey Park, Bangor, BT19 IRT 19 Belmont Road, Bangor, BT19 3TR 14 Grange Park, Bangor, BT19 4TF Student Telephone 028 91468665 07798754623 028 91488930 07891454235 Department Tutor Dept Head Student DOB 10/08/94 01/03/93 Business Trevor Albright Mr Alan Parkes Enrolment Date 10/06/16 03/07/16 028 91584630 06/11/87 05/07/16 07891834277 Enrolled By:- Andrea Gilchrist David Smythe Andrea Gilchrist

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

Given the following relation that stores details of employees and their projects: If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. 1.ProjectID ➡ EmployeeName 2.ProjectID ➡ EmployeeSalary 3.ProjectID , EmployeeName ➡ EmployeeSalary 4.EmployeeName ➡ EmployeeSalary 5.EmployeeSalary ➡ ProjectID 6.EmployeeSalary ➡ EmployeeName , ProjectID
A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?
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) 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
Question 17 Which of the following is another term for a recursive relationship? Group of answer choices ternary relationship binary relationship supertype relationship subtype relationship unary relationship
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.
Convert the following Relation into INF, 2NF, and 3NF and show the functional dependencies. StudentID StudentName Major CourselD CourseTitle InstructorName InstructorLocation Grade D-Building A-Building C-Building C-Building A-Building D-Building A-Building 111 Kevin CS CS201 Bob Computer Marketing Accounting Accounting Jeff 111 Kevin CS МАЗ3 Jeff 111 Kevin CS АCC234 Sarah 222 Alex BA АСC234 Sarah B. 333 МАЗ33 Marketing Computer Marketing Noor MA 444 CS201 Bob Luay Adam BA A 555 AC МАЗ33 Jeff
Create an unnormalized relation using student and class entities.
1. The table shows a class list for the XYZ UNIVERSITY, convert this user view to a set of 3NF relations. Assume the following: a. An instructor has a unique code. b. Astudent has a unique course. C. A course has a unique description. XYZ UNIVERSITY First Semester, SY 2020-2021 Course No. : COE 412 Description : Operating Systems Instructor Code : 0001 Instructor Name : Mr. X ID NUMBER STUDENT NAME COURSE 38214 BRIGHT BSCPE 40875 CORTEZ BSECE 51893 EDWARD BSIT
In the attached diagram, which of the following statements are true? primary key for section is course_id, sec_id, semester, year primary key for section is equivalent to the primary key for course unioned with the discrimator section is a weak entity set whose existence depends on course the discrimator of section is sec_id, semester, year
Normalize the following table to 3NF. 4 PK StudentNo CourseID StudName | GradeReceived StudCity StudMajor Business rule A student takes more than one course. Each course takes more than one students. The PK of the table is a composite of StudentNo and CourseNo
Draw an ERD containing the Transaction and Item entities. When a transaction is made, the date (TransDate) and type (TransType) together with TransNo (primary key) must be recorded. For an item, add attributes of ItemNo (primary key), ItemType, and RawCost. A transaction may include multiple items and an item may be included in multiple transactions. When an item is included in a transaction, Quantity and TransPrice of the item must be recorded.