I am looking for a bit of advice on my database design. I am currently teaching myself database modelling, SQL normalisation etc.
I have designed a database for a online book store where members can also leave reviews.
The only 2 assumptions I have made are that all books are associated to one genre and only have one author. As the database is not going to be used live and it is more of a theroricital exercise to design a database and populate it and see how well I can generate SQL etc, I have made these assumptions.
Anyway I have attached the ERD diagram I have come up with and I am wondering if it is correct. If someone could have a look and give advice it be appreciated.
Just want to see if my entites are correct and the are the attributes of each table right too.
However the diagram that I posted was basically the way I was going to physically construct the database, with a few minor additons to the customer table.
I had rougher ER diagrams but the one above it what I settled on, have to do a double check to ensure they are normalisated and that - sometimes a bit confusing to me - but I did think that what I created above was mainly ok.
I know in a real life senario it would not be totally suitable but I want to practice the SQL, queries joins etc. I am fairly ok with the SQl side and that just the database design I sometimes struggle with.
So is the design with arrtibuts listed not suitable at all
As I said I am teaching myself database modelling and sql. So I want to practice and get it right. I hope to go on and maybe take a career change and move into DBA etc I know I will need to do professional courses and that but want to get a good grounding.
However I do not see the difference surely if I am teaching myself and practicing your answer be no different to a student learning and asking for advice.
Not being snotty but I am doing this myself and want to get it right, Im not a student submitting it but I want to be able to to database design well enough that if I took a professional cousre and I submitted this as an assignment it would be good enough to get a good mark.