Hi im trying to build a database for a web service where authors submit books which can be reviewed by a normal user.
So i understand i need two tables one for users and one for authors. I would also need a table to hold all the books information and then another one to hold all the reviews so thats four tables.
how would i go about linking the reviews to the books but these should be allowed to be deleted by the user who posted the review and the book deleted by the author who posted the book only.
Any ideas ive just confused myself :o