Sign In
Create Account
This topic is locked
What was the correct answer for that, if arrows had been included?
I got:
D,E,F was text
G,H,I was animation
J,K was graphic
and for ©
I got:
(i) D,E
(ii)I,J
All of which were guesses!
How Did the Paper Go? How do you all think u did in the paper?
shiv
Posted 27 May 2004 - 04:28 PM
im sure the SQA will work somethin out but i agree, i couldnt understand the question at all. there should have been arrows. wot did ppl get for 12c? i didnt really know so i only wrote boolean operators. also 3a i didnt read the question rite. wot did ppl get for 3a? and 4a? xx
Ally
Posted 27 May 2004 - 04:34 PM
| QUOTE (shiv @ May 27 2004, 04:28 PM) |
| i didnt really know so i only wrote boolean operators. also 3a i didnt read the question rite. wot did ppl get for 3a? and 4a? xx |
I wrote about Boolan aswell.
For the other questions I wrote:
3(a) - Duplication of data
- related data is not grouped logically together
- no flexible reports/queries
4(a)????? - I guessed that question
What did everyone write for that?
Anavris_Mike
Posted 27 May 2004 - 04:40 PM
| QUOTE (ally @ May 27 2004, 04:31 PM) | ||
I think it was presentation specifications |
w00t thats wot i wrote for (e) lol, presentation specification.
Anavris_Mike
Posted 27 May 2004 - 04:51 PM
| QUOTE (ally @ May 27 2004, 04:34 PM) | ||
I wrote about Boolan aswell. For the other questions I wrote: 3(a) - Duplication of data - related data is not grouped logically together - no flexible reports/queries 4(a)????? - I guessed that question What did everyone write for that? |
I cant remember wot else i wrote apart from boolean operators. I think i wrote somethin like "if he knew the correct product number then he would be able to search and find that specific mini-disc player", was a shot in the dark tho.
3(a) i wrote (i think):
- time consuming
- need to create new records each day a book was late (was a shot in the dark there lol, but seemed logical at the time
"Any overdue book is charged at 20p per day up to a maximu of £5.00", so i guessed that they would need to make a new one to update the fine but thats wrong lol) - cant remember the 3rd one i done
4(a) i wrote (again, i think):
Hardware requirements
Network cards and a server would need to be in place in order to allow data to be transferred between the client and the server, where the database is located. (something like that i think)
Software requirements
Suitable database software must be available for use, compatible with the format of the database on the server, in order for staff to not only retrieve the database, but to also make changes to it. (somethin like that)
Communications requirements
ummmm wot did i write for this...cant actually remember.
Scott
Posted 27 May 2004 - 04:52 PM
| QUOTE (Anavris_Mike @ May 27 2004, 04:56 PM) |
| Q1 - how did peoples ER diagrams and primary/foreign keys turn out? Q2 - my mind blanked on Q2 but think i done it ok. Q3 - thought this was straight forward, a few niggly bits Q4 - wasnt too sure about the social implications so wrote a big answer and hoped for the best also wasnt TOO sure about the comm requirements but think that was kool.Hypermedia: Q11 - Totally forgot the defenition, which i had been looking at just before the exam ("") found © a bit of a bugger to answer cause they both link with each other imho. Q12 - the dodgy one which im sure has a mistake. apart from that bit then the rest of that was fine, cept i never knew what to put for (e)? anyone shed some light on that? lol Q13 - sailed it, my favourite kind of question lol. only bit was advanced feature but think i got it alright. (1 would be boolean search syntax no? AND, OR, etc?) |
1)
Intructors - teach - Class Details - in - Course Details
1 to M M to 1
Course Details - Course No. (Primary Key)
Instructor - Instructor ID (Primary key)
Class Details - Class ID (Primary key), Instructor ID (Foreign Key as it requires a link to instructor Table), Course No (Foreign Key, Keeps Course Info together in Class Details)
12d) Resolver Function, Accessor Function
12e) Presentation Specifications
13c) Boolean Operators (And, Or, Not) and Wildcard search
Edited by Scott, 27 May 2004 - 05:03 PM.
Ally
Posted 27 May 2004 - 04:57 PM
| QUOTE (Scott @ May 27 2004, 04:52 PM) |
| Course Details - Course No. (Primary Key) Instructor - Instructor ID (Primary key) Class Details - Class ID (Primary key, Instructor ID (Foreign Key), Course No (Foreign Key), Maximum Number (Foreign Key) |
Those weren't the foreign keys...
Anavris_Mike
Posted 27 May 2004 - 05:10 PM
| QUOTE (ally @ May 27 2004, 04:55 PM) |
| Ok what did everyone write for the following questions: 2(a) - what examples did you use? (b) - what examples did you use? 3© - this confused me quite a bit (d) 4(a) (b)(i) 11(d) |
2(a) and 2(b) i kinda guessed lol, im shit at those and mind blanked then so sure i got that wrong. cant remember my answers but here goes with the ones i do remember:
2(a) - cant remember
2(b) - Planning - Cant remember
Control - Term Average
3 - hated this one.
3© (i) - I wrote 4 attributes, those being "Member's Name", "Members Address", "Book Title" and "Date Due Back" (think thats wot i used).
3© (ii) - I said a report and gave a brief detail about it
3(d) - again wrote some speil about a report
4(a) - already said wot i wrote in a previous post
4(b) (i) - already talked about this one too, cept never said my answers. My only real answer i was able to give was that ethically they would need to request the permission of the student in order to be allowed to post their results.
11(d) - I chose Virtual Reality. cant remember my details at all but i'll try my best:
11(d)(i) - allows virtual learning where the user can take part of exercises
- allows training to be given out with no threat of injuries etc (for example firefighters)
11(d)(ii) - cant remember at all lol
11(d)(iii) - again, cant remember at all.
Scott
Posted 27 May 2004 - 06:47 PM
| QUOTE (Flash @ May 27 2004, 07:43 PM) |
| Overall I thought the paper was fair. What was everyone's reasons why the flat-file database was unsuitable? |
1 - It only supports one table
2 - No Relationship capability
3 - All displayed over one table on one page which makes it very long and much harder to navigate,
Scott
Posted 27 May 2004 - 06:58 PM
Yeah they should be fine, there was a whole load of possible answers for that one.
3c i
Borrowers Entity:
Member's Library No. (Required to link to Loans table)
Member's Name
Members' Address
Loans Entity:
Loan Number
Member's Library No.
Book ISBN
Date Due Back
That should be sufficient, I know some people chose the Books entity, which I'm sure would also be fine
3c i
Borrowers Entity:
Member's Library No. (Required to link to Loans table)
Member's Name
Members' Address
Loans Entity:
Loan Number
Member's Library No.
Book ISBN
Date Due Back
That should be sufficient, I know some people chose the Books entity, which I'm sure would also be fine
Scott
Posted 27 May 2004 - 07:09 PM
| QUOTE (Flash @ May 27 2004, 08:01 PM) |
Just history to go for me  We had never been taught the advanced features of a search engine - what were they? would refinement be one? |