Question Overall Database review

[reddevil1]

Hi,

i haven't seen any threads that request an overall database review?

i am at a point in my DB development where the number of Forms will increase and i wondered if an overall DB review has been suggested before?

thanks

 

[gemma-the-husky]

do you mean a critique of your database. I am sure if you upload it, someone will take a look

the key, though is getting normalised tables. if the tables are designed correctly, then adding extra functionality is generally straightforward. if not, then it may be better to revisit the table design.

 

[reddevil1]

do you mean a critique of your database.
the key, though is getting normalised tables

yup, that is what i was hoping for....it just seemed to be potentially quite a lot of work to ask for.
thanks

 

[gemma-the-husky]

yes - but if you have a particular table structure you think may be improved upon, that's the area to get reviewed.

if the structure is right, developing the app is muchg easier.

 

[reddevil1]

I wish I knew what part of my DB needs to be improved (LOL). Unfortunately, due to my self-taught inexperience, I feel like i am running in the dark and I am just "hopeful" that whatever I have done is correct and will not cause me any major problems in the future.

So that is why I asked if an "overall" review can be requested? i say "overall" because i do not really know what areas may be poor or in need of improvement.

I guess a review of the tables & relationships is the place to start?