Database Question

Hi

I am doing a scenario for my compnay which is a video library, i have the following entities but need help with the database using MS Access 2003 as iam new to this piece of software:

The entities i have got are as follows

Video (Vcode, VTitle, Date Made, Director, Genre)
Copy (CopyNum, Vcode, Due Date)
Loan (LoanMemNum, CopyNum, Ldate)
Member (MemNum, MName, MAddress)
Reservation (VCode, resMemNum, Resdate, CollectDate

re: Database Question

You forgot to mention what you needed help with.

re: Database Question

Hi,

I need help with my database, when i go to make the relationship in access using my entites in the previous post, i cannot get the relationship from loan to video to be a one to many, because access put it as many to one

Loan (LoanMemNum, CopyNum, Ldate)
Video (Vcode, VTitle, Date Made, Director, Genre)

Is this possible? Do i need to add anymore entities?

Any help on this matter would be appriciated

re: Database Question

Which one's the primary key and which one's the foreign key?

re: Database Question

Hi the primary key are underlined:

Video (Vcode, VTitle, Date Made, Director, Genre)
Loan (LoanMemNum, CopyNum, Ldate)

Thanks, Also would there be an easier solution to this as i have encountered some problems when put in a relationship in access

re: Database Question

The relationship should be One-Video to Many-Loan surely?

BTW you seem to have made a good stab at the table structure :)

re: Database Question

So VCode = LoanMemNum? If not then you need VCode in your Loan table.

And NeoPa's right, it should be one-to-many from Video to Loan.

re: Database Question

Hi so the relationship will be as follows

Member 1 : n Loan n : 1 Video 1 : n Copy

Member 1 : n Reservation n : 1 Video.

Is this correct as i was told to do it a different way as stated in my previous post, do i need to add anymore entites to my tables?

Thanks

re: Database Question

Nice way to display the relationships :)
I would say rather :
Can you confirm this is right for your situation?

re: Database Question

Hi,

I need a little help with functional and non functional requirements, can someone please help me

Thanks

re: Database Question

I can't and won't answer questions with such a broad scope.
Your best approach is to ask discrete questions on a particular issue. Smaller bites are much easier to handle and less daunting for the potential helper. A good idea is to respond to all posts in your thread too. You've left my question hanging, what response do you expect in those circumstances? It is after all, your own thread.

re: Database Question

Hi,

Thanks eveyone for all your help, i am current stuck i need to have a n: 1 relationship between Reservation and Video, the entities are as follows

Reservation (VCode, resMemNum, Resdate, CollectDate)
Video (Vcode, VTitle, Date Made, Director, Genre)

Here is what it says in access:

Data in the Reservation table violates referential integrity

Thanks

re: Database Question

Hi NeoPa

Ive used your example buT i cannot get the relationship between RESERVATION and COPY to be a n:1

Thanks

re: Database Question

See if this setup works for you.
Can you please explain why [Due Date] is to be found in the [Copy] table?