Relationships

[kempa]

I am having a very hard time getting my head around the relationship diagrams and how to successfully put the infinity of 1 sign in the correct place.
any help please? 

[ell]

Could you give us a sample question that you're stuck on?

[kempa]

Could you give us a sample question that you're stuck on?

VCE past exam 2007 question 20

[ell]

The first thing you should do is ensure that you have a clear idea of what each table/object is and its purpose (if you want you can just scroll down to the bottom for the short answer).

E.g. referring to Q20 MC in VCAA '07, we have three tables: Books, Loans and Borrowers.

Each record in the Books table has details about a particular book - title, author, etc. (obvious).
Each record in the Borrowers table has details about a particular person who borrows - name, phone number (also obvious).

The Loans table is slightly trickier. This is what I think most students are confused by - what exactly are 'Loans'?

If you look at the table, Loans has details about a particular book and a particular borrower. Each record in the Loans table is an instance of when someone has borrowed a book.

The short answer:
How many times can a single book be loaned? A lot - so we say one book can be loaned many times.
How many times can a person make a loan? A lot - so we say one borrower can make many loans.

[kempa]

The first thing you should do is ensure that you have a clear idea of what each table/object is and its purpose (if you want you can just scroll down to the bottom for the short answer).

E.g. referring to Q20 MC in VCAA '07, we have three tables: Books, Loans and Borrowers.

Each record in the Books table has details about a particular book - title, author, etc. (obvious).
Each record in the Borrowers table has details about a particular person who borrows - name, phone number (also obvious).

The Loans table is slightly trickier. This is what I think most students are confused by - what exactly are 'Loans'?

If you look at the table, Loans has details about a particular book and a particular borrower. Each record in the Loans table is an instance of when someone has borrowed a book.

The short answer:
How many times can a single book be loaned? A lot - so we say one book can be loaned many times.
How many times can a person make a loan? A lot - so we say one borrower can make many loans.

I thank you so much!