the relationship between two entiteis in databases?

[powerup]

oh people iv got three questoins
what properties of vedio cassetes do we store in microsoft access?and is the seller's number is primary key
can we say that the cattsefilm contains name or with is better word?
finally is the primary of the seller is his number reference to the cassete vedio?
thank you :D

[buntine]

You will need to store all the data your application requires. Such as, video title, year, genre, rating, run-time, etc. You could even be more precise and record data such as directors, actors, awards, nominations, etc.

The sellers number should NOT by the primary key in the Video Cassette entity. Each and every video should be uniquely identified

Similarily, each Seller should be identified uniquely. Whether it be numeric, alphanumeric, etc is up to you.

Regards.