University:
College
Course:
College Mathematics
Academic year:

2023
Views:

131

Pages:

3
Author:

Avaiya P.

PAGE NODATE:QStudent (Sid, Sname, Age)Counse( Cid, Cname, inst. )Enroll C SidCid grade)itFind Sid who enrolled every coursetaught by KorthII (Ensoll)II ( 6ccowse))SidCidcidinst="Korth"Except / Set Difference (-)FDEAB CR123S24J243L23,3563 6 77.9 88 98ABCR- S2A3356798FDFS-R 22a536 78 a 8Cardinality:-alin: O ( in case of same value)Man: n (: An diffn values) PAGE NO )DATE:19/8/21RDBSNFunctional Dependency (ED):-the known as set single valued dependencyr,y AttributoXy { for each value of 'x' attributethese should be single 'y' valuefunctionalely detarmines yExample:Sid }(Sname]S.AS12ASingle value of 'y' for S1S.,AS2BSingle value of 'y' for 52S2BS3)C"53S4D3"$4OtherWay:-x-y inplied in R only if t,, t2if tire t2.x then to y. toyQ.-Rxy371ye3,X1y23,X1y233X2Y424K34435Which is correct functionality PAGE NODATE:yX1:ye , n, yo ri:yz existsii)3YAll are unique 1. exists 31:11, $2: xz(iii3y-7-)crestsyaxAll 24 has dyb Notexusle(v)y->(vi)All y' has diff n 31.32.11x-3All K, has " 3, 3,VGate :-RABCa)BA411b) A-7B & B+D does not110functionally determine the C.2312c) B ) C2/3/2d) CA-BB $ BA-BBV $BACK)BAXCA2B XB-A C xX