Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
13 Cards in this Set
- Front
- Back
|
Pick out the likely entities from the following text. Students on full time courses at leeds beckett study a selection of modules. These modules have a title and a module code.
a) STUDENT,COURSE, Leeds Beckett, TITLE, MODULE CODE. b)STUDENT, COURSE, Leeds Beckett, MODULE. c)STUDENT, COURSE, MODULE. d)STUDENT, MODULE. |
STUDENT, COURSE, MODULE
|
|
|
If we are modelling a sustem from a description we can start by underlining nouns, then forming them into a list and eliminating those which: a)have only one occurance. b)are attributes of another entity. c)are alternative names for the same thing. d)are all of the above. |
are all of the above
|
|
|
During logical design a many to many relationship with optionality at both sides requires: a)two new relations to be created. b)no new relations to be created. c)one new relation to be created. d)none of the above |
one new relation to be created.
|
|
|
Which is most likely to be an example of an occurance of an entity type: a)Student Name b)John Brown c)University d)None of the above |
John Brown
|
|
|
Logical design maps the entity relationship diagram to a set of relations : a) True b)False |
True
|
|
|
The result of logical design on a many to many relationship will: a)Always result in a new relationship b)Always result in a new relation c)Never result in a new relationship d)Never result in a new relation |
Always result in a new relation
|
|
|
A relationship, VET treats SPECIES of animal is most likly to be: a)Many to Many without optionality b)One to many without optionality c)Many to Many with optionality d)One to many with optionality |
Many to Many with optionality
|
|
|
The result of logical design on the relationship ANIMAL has REFERRAL would be: a)The primary key of animal would become a foreign key of referral. b)The primary key of referral would become a foreign key of animal. c)A new relation would be needed because of the optionality d)None of the above |
The primary key of animal would become a foreign key of referral
|
|
|
During logical design optionality at the one end of a one to many relationship results in: a)A new relationship being required, b)A new foreign key at the many end, c)A new foreign key at the one end, d)None of the above |
A new relationship being required
|
|
|
Removing repeating groups must be completed prior to which normal form: a)1NF b)2NF c)3NF d)None of the above |
1NF
|
|
|
Which is the lowest Normal Form for which there should be no none key dependancies: a)1NF b)2NF c)3NF |
3NF |
|
|
The need for normalisation is more likely to arise where tables/relations have been derived from business documents rather than from an entity relationship diagran: a)True b)False |
True |
|
|
An un-normalised table for registered clients and animals is as follows. CLIENT(Clientno, ClientName, ClientAddress [Animalno, AnimalName, Animalsex]). Which are repeating groups: a)Clientno, clientName, clientAddress b)Animalno, AnimalName, AnimalSex c)Clientno, ClientName, ClientAddress Animalno, AnimalName, Animalsex d)There is no repeating groups |
Animalno, AnimalName, AnimalSex
|
