Hello i am a university student doing a oracle assignment. at present i am to do a database on a video shop. i have so far started this assignment however in my database i would like to store history of members so i can see what video/dvd they have loaned. so far i have created the folowing tables in oracle:

Members-details on members
Video-video details
Stock-copies of videos as u have more than one copy of one video


somehow i am suppose to loan videos out to customers and make a copy of the video loaned in my database so i can view what they have hired in the last two months or so.


any suggestions any one

thank you