2006 IPT paper help (2 Viewers)

[Niksta123]

I had trouble pasting in the section i needed help for...

If you wouldn't mind going to the 2006 IPT HSC paper and go to page 8...and then plz explain how to get the answer to qu 16 of the MC...also help me understand what the different relationships mean between the tables etc, that would be greatly appreciated!

Thanks heaps

 

[nubix]

Is the answer B?

 

[Niksta123]

Is the answer B?

Yes the answer is B...

Can you please explain to me how you got that?

 

[Jonny90]

Niksta 123................ what's the problem????? nothining's that hard if you looking for the answers instead of askin and postining messages

 

[Jonny90]

I mean if you go looking for answers then you will get them..........

quote: "seek and you shall find, knock and the door will open to you"

 

[LatK7]

Yes the answer is B...

Can you please explain to me how you got that?

Look at the relationships. All of them except B have them wrong. For instance "Movie ID -------------------- Borrower ID"

 

[nubix]

You'll need to familiarise yourself with relational databases. Once you get that, it's just logical.

The shop can have more than one copies of the same movie. The movie itself is unique, but the copies can be borrowed by different people. Similarly, each borrower is unique, but they can borrow more than one movie.

ie. one movie - many loans, one borrower - many loans.

 

[seano77]

I mean if you go looking for answers then you will get them..........

quote: "seek and you shall find, knock and the door will open to you"

-by Jesus, Matthew 7:7-8.... I think he was talking about spiritual things, not relational databases somehow..

 

[Starcraftmazter]

Stupidly easy quesrtion, just choose the schema where the fields match.

It can't be A because Movie_Name goes to Movie_ID
It can't be C because Type goes to Phone
It can't be D because Movie_ID goes to Borrower_ID

But in B the field names match up. If you don't understand, give each field a colour, and select the schema where colours match. Braindead easy.