Unit 7:Bronco Brian database exam

Banned 36
Found 7th Jan 2008
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

  1. Misc
Groups
  1. Misc
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

Quillcousins@hotmail.co.uk

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. Just heard this...2 ★★★★★★★★★★★★★★ congrats to all on 392k ★★★★★★★★★★★★★★7771874
    2. Just saw justice league *mimor spoiler*22
    3. Corrupt banks finally being dealt with33
    4. I want to talk about the WEATHER no politics no religion19548044

    See more discussions