Normalization

“——————————————————————————————————————————————————



Support translation: http://amzn.to/1Z7d5oc
——————————————————————————————————————————————————

Normalization

Home > Practice Quizzes > Normalization
Normalization
Please answer the questions to the best of your ability. Questions with checkboxes have multiple correct answers.

1.
The primary key of a relation determines the values of all other attributes
True

False

2.
Functional dependencies can be determined by examining the extensions (states)
of tables in a database.
True 11. Not The closure of a given set of attributes under a given set of

Answered functional dependencies is The Correct Answer: the set of all attributes that are determined by the given attributes
12. Not Answered
Relation R(A,B,C,D,E) and a set of functional dependencies are given: F={AB->C, CD->E, C->A, E->D} are given. The closure of {A, B, E} under F is: The Correct Answers: {A, B, E, D, C}, {A, B, C, D, E}
13. Not Answered
Two sets of functional dependencies F and E are equivalent if The Correct Answers: F covers E and E covers F, F+ = E+
14. Not Answered
A table is in 1NF if every value in the tables is: The Correct Answer: single-valued and atomic
15. Not Answered
A table is not in 2NF if: The Correct Answer: it contains partial functional dependencies
16. Not Answered
A table is in 3NF if: The Correct Answers: there are no transitive functional dependencies, each functional dependency either has a superkey on its left-hand side, or has a prime attribute on the right-hand side
17. Not Answered
A table is in BCNF if: The Correct Answer: every functional dependency has a superkey on its left-hand side
18. Not Answered
A functional dependency violates BCNF if it does not have: The Correct Answer: a superkey on its left-hand side

19. Not A functional dependency is partial if:
Answered The Correct Answer: its left-hand side contains a part of a candidate key
2 Not Under what condition(s) is a relation always in 2NF?


“————————————————– ————————————————– ————————————————–

Appoġġ traduzzjoni: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–

normalizzazzjoni

Home> Kwiżżijiet Prattika> Normalizzazzjoni
normalizzazzjoni
Jekk jogħġbok wieġeb il-mistoqsijiet lill-aħjar ħila tiegħek. Mistoqsijiet bil checkboxes jkollhom tweġibiet korretti multipli.

1.
Iċ-ċavetta prinċipali ta ‘relazzjoni jiddetermina l-valuri ta’ kull attributi oħra
veru

falza

2..
dipendenzi funzjonali tista ‘tiġi ddeterminata billi teżamina l-estensjonijiet (istati)
ta ‘tabelli fil-database.
Veru 11. Mhux L-għeluq ta ‘sett partikolari ta’ attributi taħt sett partikolari ta ‘

dipendenzi funzjonali imwieġba hija l-risposta korretta: is-sett ta ‘attributi kollha li huma determinati mill-attributi mogħtija
12. Mhux Wieġeb
Relazzjoni R (A, B, Ċ, D, E) u sett ta ‘dipendenzi funzjonali huma mogħtija: F = {ab-> Ċ, CD> E, C-> A, E> D} jingħataw. L-għeluq ta ‘{A, B, E} taħt F huwa: Il Tweġibiet korretta: {A, B, E, D, C}, {A, B, Ċ, D, E}
13. Mhux Wieġeb
Żewġ settijiet ta ‘dipendenzi funzjonali F u E huma ekwivalenti jekk il-Tweġibiet korretta: F ikopri E u E tkopri F, F + = E +
14. Mhux Wieġeb
Tabella hija fil 1NF jekk kull valur fit-tabelli hi: l-risposta korretta: wieħed vvalutati u atomika
15. Mhux Wieġeb
Tabella mhuwiex 2NF jekk: l-risposta korretta: fih dipendenzi funzjonali parzjali
16. Mhux Wieġeb
Tabella hija fil 3NF jekk: Il Tweġibiet korretta: m’hemmx transittivi dipendenzi funzjonali, kull dipendenza funzjonali jew ikollu superkey fuq in-naħa tax-xellug tiegħu, jew ikollu attribut ewlieni fuq in-naħa tal-lemin
17. Mhux Wieġeb
Tabella hija fil BCNF jekk: l-risposta korretta: kull dipendenza funzjonali għandha superkey fuq in-naħa tax-xellug tagħha
18. Mhux Wieġeb
A dipendenza funzjonali tikser BCNF jekk ma jkollux: l-risposta korretta: a superkey fuq in-naħa tax-xellug tagħha

19. Mhux A dipendenza funzjonali hija parzjali jekk:
Wieġeb l-risposta korretta: in-naħa tax-xellug tiegħu jkun fiha parti ta ‘ċavetta kandidat
2. Mhux Taħt liema kundizzjoni (jiet) hija relazzjoni dejjem fil 2NF?


“————————————————– ————————————————– ————————————————–

Ondersteuning vertaling: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–

normalisering

Home> Practice Quizzes> Normalisering
normalisering
Beantwoord asseblief die vrae na die beste van jou vermoë. Vrae met blok het verskeie korrekte antwoorde.

1.
Die primêre sleutel van ‘n verhouding bepaal die waardes van al die ander eienskappe
True

onwaar

2.
Funksionele afhanklikhede kan bepaal word deur die ondersoek van die uitbreidings (state)
van tafels in ‘n databasis.
Ware 11. Nie Die sluiting van ‘n gegewe stel eienskappe onder ‘n gegewe stel

Beantwoord funksionele afhanklikhede is die korrekte antwoord: die versameling van alle eienskappe wat bepaal word deur die gegewe eienskappe
12. Nie beantwoord
Betrokkenheid R (A, B, C, D, E) en ‘n stel van funksionele afhanklikhede word: F = {mis-> C, CD-> E, C> A, E> D} gegee. Die sluiting van {A, B, E} onder F is: die korrekte antwoorde: {A, B, E, D, C}, {A, B, C, D, E}
13. Nie beantwoord
Twee stelle van funksionele afhanklikhede F en E is ekwivalent indien die korrekte antwoorde: F dek E en E dek F, F + = E +
14. Nie beantwoord
‘N Tabel is in 1NF as elke waarde in die tafels is: die korrekte antwoord: enkel-gewaardeer en atoom
15. Nie beantwoord
‘N Tabel is nie in 2NF as: die korrekte antwoord: dit bevat gedeeltelike funksionele afhanklikhede
16. Nie beantwoord
‘N Tabel is in 3NF as: Die korrekte antwoorde: daar is geen oorganklike funksionele afhanklikhede, elke funksionele afhanklikheid óf ‘n superkey op sy linkerkant, of het ‘n prima kenmerk op die regterkant
17. Nie beantwoord
‘N Tabel is in BCNF as: die korrekte antwoord: elke funksionele afhanklikheid het ‘n superkey op sy linkerkant
18. Nie beantwoord
‘N funksionele afhanklikheid stryd BCNF as dit nie: die korrekte antwoord: ‘n superkey op sy linkerkant

19. Nie ‘n funksionele afhanklikheid is gedeeltelike indien:
Antwoord die korrekte antwoord: sy linkerkant bevat ‘n deel van ‘n kandidaat sleutel
2 Nie Onder watter voorwaarde (s) is ‘n verhouding altyd 2NF?


“————————————————– ————————————————– ————————————————–

përkthim Support: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–

normalizim

Home> Praktika Quizzes> Normalizimi
normalizim
Ju lutemi përgjigjuni pyetjeve të mirë të aftësisë tuaj. Pyetje me kutitë kanë përgjigje të shumëfishta të sakta.

1.
Çelësi kryesor i një lidhje përcakton vlerat e të gjitha atributet e tjera
i vërtetë

I rremë

2.
varësi funksionale mund të përcaktohet duke shqyrtuar extensions (shtetet)
e tabelave në një bazë të dhënash.
True 11. Jo Mbyllja e një grupi të caktuar të atributeve nën një grup të caktuar të