prior to answer number 2 to 5 SpecificationFunctional Dependency1. Consider the relational schemas given below and the respective sets offunctional dependencies valid in the schemas. For each one of the relationalschemas identify its highest normal form. Remember that the identification of anormal form requires analysis of the valid functional dependencies and theminimal keys. Provide justification of each answer. A solution with nocomprehensive justification scores no marks.i.R1(A, B, С, D, E, F, G, H) F%3D {CH — G,A — ВС, Е — А,F — EG}ii.R2 = (S,C,L, D)F = {(L,D) → S, (L, D) → C,L → D}R3(A,B,C,D,E)F = {ABC → D, D → A} 2. In a higher education institution, in a semester, students are allowed to enrollup to 2 running subjects, and each running subject may have many studentsenroll to it. The final grade the students receive for a subject, and the creditvalue of each subject are recorded in the following relational table.ENROLMENT(StdNum, SubNum, Grade, CreditValue)3. When a staff is required to undertake an inspection of properties, the staff isallocated a company car for the day. A staff may inspect several properties ona given date, and a property is only inspected once on a given date. Thisinformation of the inspection are stored in the following relational table:PropertyInspection(PropertyNum, IDate, ITime, Comments, StaffNum,CarRegNum)4. In a company, employees involved in many projects, and each project may havemany employees working on it. The number of hours each employee works ineach project, and the start date on which the employee starts working on theproject are capture in the following relational table.EmployeeProject (EmpeNum, ProjNum, HoursWork,DateStartWorkOnProj)5. Each student is assigned with a counselor who will act as an advisor to thestudents. The student is given the counselor email address so that the studentcan contact the counselor for advice. The information on the student andcounselor are stored in the following relational table.STUDENTCOUNSELOR (StdNum, StdName, CounselorName,CounselorEmail)

Functional Dependencies Functional dependency is define as the conditions that tells about the…

Answered: prior to answer number 2 to 5

prior to answer number 2 to 5

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

Similar questions

count : 5.2017 MOD83
is it a yes or no?
Using 10’s Compliment , Subtract 73252-3520 Subtract 3520-73252
y’ = sec^2 y
Let R be the relation R= ((a, c), (a, d), (b, a), (c, a), (c, b),.(d.b). What is the matrix representation of this relation, given that the labels on the matru rows and on the matrix columns are in alphabetical order? ATE 10 01 1 100 0 1 100 10 1 0 0 p VTE
Given the following notations,evaluate given Prefix notation : *-50 -* 2 +2 3 * 5 4 2
In what numbering system are all numeric values represented as a succession of 0s and 1s?
Higher Lower Guess a number between 1 and N Your guess: Guess
In what numbering system are all numbers represented by a string of zeroes and ones?
What numbering system represents each number as a string of zeros and ones?
In what numbering system are all numbers represented by a string of zeroes and ones?
Please help to answer this question!