Video Shop Triggers

I'm currently practising my PL/SQL by modelling a video shop. I've got the following tables:

FILM(film_no [PK], film_name, filmmaker_id [FK], date_added, year_made)

FILM_MAKER(filmmaker_id [PK], maker_name, maker_street, maker_suburb, maker_country, maker_state, maker_postcode, royalty_rate)

FILM_COPY(filmcopy_id [PK], film_no [FK], buyer_no [FK], mastercopy_indicator, format)

FILM_BUYER(buyer_no [PK], buyer_name, buyer_street, buyer_suburb, buyer_country, buyer_state, buyer_postcode, discount)

Note: PK = primary key, FK = foreign key

I would like to enforce some integrity on these tables using triggers. At present, I've a trigger that ensures only one mastercopy exists for each film. Does anyone have any ideas for more triggers?

I would appreciate it if you would kindly cc your reply to steelx_at_hotmail.com. Thanks in advance!

steelx

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 09 1998 - 08:44:09 CDT