Groups

    Unit 7:Bronco Brian database exam

    Banned
    Hi just wanted to know is anybody doing the applied ict unit 7 database exam? which is based on "bronco brian" this year. if anyone is, advice would be a great deal of help to me.
    thanks

    31 Comments

    I am =D
    I need help too.

    Can't believe its 10hours. God knows what i'll do =/

    Yea, I`ve gotta do it too

    What are you guys doing to study/prepare for it at the moment??

    well, my macbook was stolen, so won't be doing a lot thanks to that. But we we're given a textbook luckily.

    I've looked at which tables and fields i'll be making, plus their types. I really need to look at the switchboard manager part though. And how to calculate the ride points etc.
    What about you?

    What fields have people come up, tbh lol this exam is doing my nut in. Also has anyone had access to the data files as of yet??

    Stormstar;1431763

    What fields have people come up, tbh lol this exam is doing my nut in. … What fields have people come up, tbh lol this exam is doing my nut in. Also has anyone had access to the data files as of yet??



    I can't remember as they were all on my laptop, d'oh. Its doing mine in too. And some people have already begun the exam in some schools, so they would have seen it i'm guessing. Doubt anyone would have access to it though.

    O.O argh.

    So what tables have you come up with then?

    mate your a genius, my teacher was hinting at something like a student thing coming up, right so all we need is access to the data files which unless someone can get them we can be sorted lol, I suggest as well MSN it people, then your safe.

    Ooo :-D
    It's just the calculations of the sessions and points per member, which will the pain in my opinion. eek

    Wow! Nice one!

    I really need as much help with this as possible... Databases are my weakest point :-(

    gman213;1432108

    Hi, me too. i got a friend who started already an suggested the following … Hi, me too. i got a friend who started already an suggested the following tables. * being the primary key. Spoken to my teacher about this an he seems to think its right so far. This was a file split up into 5 tables.If anyone can get the data files post em up here.Customer Table:1. Customer ID* 2. Customer Last3. Customer First4. Customer Address5. Customer Town6. Customer County7. Customer PostcodeSession:1. Session Number*2. Session Time3. Session Date4. Number Reserved5. Reserved Places AvailableRide:1. Ride Code*2. Ride Name3. Ride Value4. Ride PriceCard:1. Card Number*2. Customer ID3. Points Outstanding4. Print Card5. StudentReservation/Booking: (This tabel has to be created yourself)1. Reservation Number*2. Card Number3. Session NumberHope this helps.



    Anyone have any idea what data types each of these atributes will have?
    Especially the card number as thats the one i'm having trouble with.

    im in the exam now.. :oops: and i dont have a clue what im doing to be honest

    hi there has anyone got the bronco brian gunn's wild west theme park reservation text files please its urgent if you have send it please urgently plz thanx Ali

    Thats brilliant help :-D
    Do you know what the 'print card' and 'student' is for at all?

    Edit: Nevermind, saw your Student Room post.
    It's a small world!

    lewis t;1434499

    im in the exam now.. :oops: and i dont have a clue what im doing to be … im in the exam now.. :oops: and i dont have a clue what im doing to be honest



    & ouch. Hope it went well. At least you have another 4 2hour exam slots to go and make changes!

    your in the exam now! whats it like? ...is the data tricky, or more or less strait forward?



    From the case study that we`ve been given I was only planning on using 3 tables:

    Member:
    MemberID
    NamE
    Town
    No. of Points
    Payment Type

    Ride:
    RideID
    Number of Points
    Description


    Session:
    SessionID
    RideID
    Date
    MembershipID
    Member Allowance


    Thoughts?

    Peace, Mike.

    Well we reckon its five tables as I've had the exam, How can you do it on three I dunno, I mean you gotta make all the cards and ****. Does anyone who's already done part of the exam have a clue of what to do???

    Banned

    my mate's doing it. il ask him tomorrow how its going.

    Does anyone have an idea to an actual structure which has been normalised to whatever normal form, I mean I think once thats cracked we're all sorted, come on people we're in this together!!!

    Banned

    Stormstar;1436345

    Does anyone have an idea to an actual structure which has been normalised … Does anyone have an idea to an actual structure which has been normalised to whatever normal form, I mean I think once thats cracked we're all sorted, come on people we're in this together!!!



    :whistling: :roll::whistling:

    Craig David, what do you have pm me if you wanna talk I think I can help you even further.

    Banned

    Stormstar;1436471

    Craig David, what do you have pm me if you wanna talk I think I can help … Craig David, what do you have pm me if you wanna talk I think I can help you even further.



    sorry i dont have anything

    has any 1 got the text files for unit 7 plz its urgent i need it asap plz sum 1 help

    Today, i imported the data, on Monday i have to do Activity 3 and i don't have a CLUE what to do

    Any one knows which validation rule or input mask to set to the Session Number field???

    Hial, i have had two sessions so far and im on part two , i have created 4 tables and correctly done validation rules in every table and input masks where appropriate, however i have heard of people with 5 tables ..and some with three.. whats going on , no offense but blates there are 4 tables:

    Customers
    Sessions
    Rides

    those are the main three.. then to connect them all in a relationship add a Reservations table containg each the other three tables primary keys( Foreigh key) one to many relationship

    all links fine .. get a screen print of that and explain and youll get top marks ...

    also if anyone is interested in getting on msnsometime to discuss the exam it would be great to share ideas

    So link me ASAP .. my email/ msn is

    [email protected]

    Alternatively im always on MIrc chat client...... jaundies server .. nick is chuckie hit me up ill solve all your ICT needs

    Mwahahahahhaah

    get in touch.. youll regret it if you dont

    :santa:

    ChuckieTehPirate;1453969

    all links fine .. get a screen print of that and explain and youll get … all links fine .. get a screen print of that and explain and youll get top marks ...



    I too have had 2 sessions so far, and also have the 4 tables.
    What would you explain about the relationship though? =/

    Then I got a bit stuck on the beginning of Activity Three; no idea how to generate a new membership card number/ID :?

    new membership .. i am not on that quetsion yet but it will be refering to the previous data and adding one to the highest on there .. shouldnt be hard to sort..

    and for the card set it so it atuo fills in it all but the cust id whish you set to add on the end .. add me on msn or Irc as i often forget to check here ..

    but dude lol i bee on here for like 4 hourse helping / advising others who are taking the exam so i have a few ideas ..

    Those tables shud b ok i wud think, we'v discussed those except we put a reservations table in aswell:thumbsup:

    Bronco Brian is also the subject of the Networking Exam aswell.

    This thread will be useful.

    Is anyone doing the database exam now?

    Could use a little help with it.

    Customer
    Customer ID*
    Card number
    Customer Last name
    Customer first name
    Customer address line
    Customer town
    Customer county
    Customer post code
    Points outstanding
    Print card
    Student

    Session
    Customer ID
    Ride code *
    Session number *
    Session time
    Session date

    Ride
    Ride code*
    Ride name
    Points value
    Ride price

    Reservation
    Reservation number*
    Customer ID*

    Session number *
    Number reserved
    Reserved places available

    Im doing this exam in January along with the double exam, anyone got any infomation on it ?
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. What would be HELL to you?2635
      2. Easy Jet flights - does anyone know how far in advance seats are sold?47
      3. Do cheeky drivers annoy you when they park outside your house and leave it …2241
      4. I want to talk about the WEATHER no politics no religion19047132

      See more discussions