Hey there! Sign in to join this conversationNew here? Join for free
    Offline

    0
    ReputationRep:
    (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.
    Offline

    0
    ReputationRep:
    (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
    Offline

    6
    ReputationRep:
    (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

    Posted from TSR Mobile
    Offline

    0
    ReputationRep:
    Has anyone got any notes for G063 which they are willing to share? :confused:
    Offline

    0
    ReputationRep:
    (Original post by alicejackson95)
    Has anyone got any notes for G063 which they are willing to share? :confused:
    http://word.office.live.com/wv/WordV...1-3+ICT+by+BDZ
    Offline

    0
    ReputationRep:
    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.
    Offline

    0
    ReputationRep:
    Do you have 4-6 too?
    • Thread Starter
    Offline

    2
    ReputationRep:
    Good luck everyone for tomorrow
    Offline

    0
    ReputationRep:
    Does anyone have any predictions about what the big 11 markers could be??
    Offline

    0
    ReputationRep:
    (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.
    Offline

    6
    ReputationRep:
    (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
    Offline

    0
    ReputationRep:
    (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.
    Offline

    0
    ReputationRep:
    (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 good luck!
    Offline

    0
    ReputationRep:
    (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!
    Offline

    1
    ReputationRep:
    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

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

    0
    ReputationRep:
    (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

    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
    Offline

    0
    ReputationRep:
    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

    good luck
    Offline

    0
    ReputationRep:
    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
    http://www.teach-ict.com/as_a2_ict_n..._syllabus.html
    Offline

    6
    ReputationRep:
    I didn't think there were disadvantages of a MIS? Apart from the cost...

    Posted from TSR Mobile
    Offline

    1
    ReputationRep:
    (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

    good luck
    Thank you!

    Good luck !!
 
 
 
Poll
Do you agree with the PM's proposal to cut tuition fees for some courses?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.