Recent content by redverse22

Thanks Pat. Advice greatly appreciated So if I go back and add into my ER the following 2 tables Books_Author Table - (book_id, author_id) Book_Genre Table (book_id, genre_id) Then adjust the book table as follows New Book table (book_id, title, publisher_id, description, ISBN, price) I...

You are totallly right it much better to build things in at start then levaing them out and having to go back. Consider every possibility. I agree Pat gives great advice and I appreciated it. Hope my post did not come across as ungrateful. So if I go back and add into my ER the following 2...

No you are totally correct it is better to have all possibilities built in at the start.

Thanks for the advice. However I mentioned above for the purpose of this database books with only 1 author will be entered and books will be attributed to one genre. ( not totallly realistic I know but at the moment it is what is needed) I will probably expand upon this later and as you said...

Thanks for all the help to you and RainLover. It been very beneficial and you just do not think of certain things at times and how much detail is needed at times. I have revised my ER and have it attached. I think I finally got it right ( cross fingers and toes anyway), inspiration thanks to...

I am using Gliffy as a applicaion. It very good for Database design, wireframes etc. I friend of mine uses it for work and recommended it to me. So def give it al go you can get a free trial for 30 days I think and after that can keep a basic verison or sign up for a year. Thanks for looking...

I attached a copy now. I have been a drawing package to do out UML's as that is what I am used to using. I have it as JPEG though so hope that is ok. It is not complete as I said got confused but this is what I have so far-it does need rework I bet.

Hi I am designing a database for a bookstore. Customer can place and order Customers can leave a review for a books in catalogue but can only leave 1 review per book Books will be defined in one genre only For this example a book will be written by one author ( I know really you would need...