Comment on Database Model
Posted by: Michael Bird
Date: November 25, 2013 12:11AM

Hello,

This is my first post on the forum - so please be kind. I am very new to database design/modelling which will be very apparent if you look at my model.


I'm just looking for general suggestions and comments.

Questions:
1) I built it with MySQL Workbench (is that the right program to be using? It does crash a lot).
2) I have all my columns as 'not null' - is the correct?
3) I'm using '_' in my naming - is that general practice?
4) Yes - my relationships are completely screwed up - they're connected correctly but they shouldn't be all 1:1 - recommend any good reading here?
5) General suggestions? When I started linking everything with relationships - Workbench started to create new id's so that's why the naming scheme isn't standardized

Options: ReplyQuote


Subject
Written By
Posted
Comment on Database Model
November 25, 2013 12:11AM
November 25, 2013 12:13AM
November 25, 2013 02:51AM
November 28, 2013 12:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.