The Student Room Group
Competition - post a photo you've taken of nature >>
Competition - post a photo you've taken of nature >>
Competition - post a photo you've taken of nature >>

OCR A2 ICT G063 exam - 11 June 2013

Scroll to see replies

Reply 60
Avatar for MrBobb
MrBobb
Original post by hvanheerden1
Can anyone help me with 'resolving many to many relationships'?! I have come across it twice now in past exams and I haven't a clue what it means!


Haven't you checked the specification. if not i got a good news. the Entity relationship diagram and state transition diagrams are removed from the specification.
Original post by MrBobb
Haven't you checked the specification. if not i got a good news. the Entity relationship diagram and state transition diagrams are removed from the specification.
thats true but just thought i should let you no they can still ask about ERD diagrams under the Synoptic Elements (AS spec) so it still might come up
Original post by MrBobb
Haven't you checked the specification. if not i got a good news. the Entity relationship diagram and state transition diagrams are removed from the specification.


Thanks for that, but as sophielee123 said, there is the possibility of it coming up and I don't want any nasty surprises haha :smile:

Posted from TSR Mobile
Has anyone got any notes for G063 which they are willing to share? :confused:
Reply 64
Avatar for MrBobb
MrBobb
Original post by alicejackson95
Has anyone got any notes for G063 which they are willing to share? :confused:


http://word.office.live.com/wv/WordView.aspx?FBsrc=https%3A%2F%2Fapps.facebook.com%2Fattachments%2Fdoc_preview.php%3Fmid%3Dmid.1370792521674%253A7f106e2cfe48d32218%26id%3D5653c7121fac4cd722fc74012e36dfcd%26metadata&access_token=100000049004807%3AAQDZy3nDce__DXhH&title=ch+1-3+ICT+by+BDZ
Reply 65
Avatar for akspop
akspop
Anybody here able to explain distributed databased to me?
Probably going to be one of those 6 markers and would appreciate if someone could help me understand it.
thanks.
Reply 66
Avatar for Afz
Afz
Original post by MrBobb


Do you have 4-6 too?
Reply 67
Avatar for Anon217
Anon217
OP
11
Good luck everyone for tomorrow :smile:
Does anyone have any predictions about what the big 11 markers could be??
Reply 69
Avatar for lakhs
lakhs
Original post by alicejackson95
Does anyone have any predictions about what the big 11 markers could be??


There's usually a question about hardware and software developments every year and not sure about the other question could be anything.
Original post by akspop
Anybody here able to explain distributed databased to me?
Probably going to be one of those 6 markers and would appreciate if someone could help me understand it.
thanks.


What is it you don't understand?

Posted from TSR Mobile
Reply 71
Avatar for Kieran20
Kieran20
Original post by alicejackson95
Does anyone have any predictions about what the big 11 markers could be??


I think we'll get one about hardware & software developments and another about Consultation, Participation and Communication.
Original post by akspop
Anybody here able to explain distributed databased to me?
Probably going to be one of those 6 markers and would appreciate if someone could help me understand it.
thanks.

There are 4 types you have Entire databases duplicated at each site (replicated) This is a database copied in entirety at each site. So each site has a copy of the database.
Advantages
+Staff have access to the whole database at each site
+ each site is independent therefore problems in one store do not affect the other.
+ All data is stored in at the loacal site so queries will work quicker

Disadvantages
- Whole database requires more storage space at each location
-Difficult to keep copies of each database in sync.
-each database has to be backed up seperately.

Then you have Vertically partitioned database. This is when the database it partitioned on individual fields.

Advantages
+ each site is independent problems in one store do not affect another
+staff only have access to what they need
+ less storage space required.

Disadvantages
-more complex to set up and maintain need a specialist.
-central backup cannot be made, Each site has to be backed up individually.
-Not useful if branch needs information from another branch.

Next, Horizontally paritioned database. This is when the database is partitioned on individual records.
It has the same advantages and disadvantages as vertical partitioned database.

Finally, central databases with remote local indexes.
A central database is only stored in one single location. Each site sotres a local index to allow data to be searched for faster.( one database is soted in one location but other sites have access to it)
Advantages
+ Large storage is only needed in central database
+back ups are easier they are managed centrally
+Can affectively access remote records by using an index rather than a query

Disadvantages
-The system must keep all indexes up to date
-local sites can not customise the database to meet their needs
-Storage will be expensive as it will need to allow multi user access.

Hope this helps you, it took a while to get my head round it but just learn this and you should be ok :smile: good luck!
Original post by alicejackson95
Does anyone have any predictions about what the big 11 markers could be??

There is a few that could pop up, impact of external change ( i think this one will come up) Consultation participation and communication (chapter 6) Hardware and software developments very popular. I also think that because this is new to the spec they may throw Discuss implications of being able to communicate from anywhere in the world using mobile technology. Basically anything with a "discuss" in the specifcation can be asked as an essay question. Hope this helps!
Can someone please help me with the structure for the 11 markers please. I know It will be a discuss question but I need to know how to approach it to get full marks....... limited time left :frown:

Oh and if anyone's feeling kind lol could someone explain disadvantages of MIS, cant find any anywhere and scared MIS will come up
Original post by homousandfalafel
Can someone please help me with the structure for the 11 markers please. I know It will be a discuss question but I need to know how to approach it to get full marks....... limited time left :frown:

Oh and if anyone's feeling kind lol could someone explain disadvantages of MIS, cant find any anywhere and scared MIS will come up


I neeed help with this toooo
Reply 76
Avatar for jj95_
jj95_
hey, for information on any of the topic google teach ict and then navigate this website to the A2 ocr ICT section and it has notes for every topic.

For the 11 mark questions make a point--add an advantage and disadvantage and then implications and impacts of the point you have made. do this for at least 2 points (preferably 3) and add a summary at the end. If you do all of this and use subject specific terminology then you are in the top mark boundry for the question (9-11marks)

douing these two things i have consistantly got 95+ marks on the past papers i have done.

hope this helps :smile:

good luck
Reply 77
Avatar for jj95_
jj95_
check out this website it has notes for every part of every chapter in the specification. i have used it alot this year and found it really helpful.
hope this helps :smile:
http://www.teach-ict.com/as_a2_ict_new/ocr/A2_G063/A2_G063_syllabus.html
I didn't think there were disadvantages of a MIS? Apart from the cost...

Posted from TSR Mobile
Original post by jj95_
hey, for information on any of the topic google teach ict and then navigate this website to the A2 ocr ICT section and it has notes for every topic.

For the 11 mark questions make a point--add an advantage and disadvantage and then implications and impacts of the point you have made. do this for at least 2 points (preferably 3) and add a summary at the end. If you do all of this and use subject specific terminology then you are in the top mark boundry for the question (9-11marks)

douing these two things i have consistantly got 95+ marks on the past papers i have done.

hope this helps :smile:

good luck


Thank you!

Good luck !!

Quick Reply

Related discussions

Latest

Trending

Trending

Articles for you