When designing a relational database, what steps need to be taken?
2007-06-14 00:53:41 · 3 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
Don't go overboard on creating tables to house data that could be held in one and joined once to the main record. No one builds a perfect database right off the bat because you will always come up with new ideas that will have to work around mistakes made early on. as long as you keep it simple to begin with it will be easier to modify later. The simplest solutions is always the best and most efficient. Remeber that you want to create your databases so that others that come after you can understand the logic and flow.
2007-06-15 17:37:15 · answer #1 · answered by marketplacesoftware 4 · 0⤊ 0⤋
1. Understand your requirements
2. Draw an ER Diagram
3. Normalize it
2007-06-14 01:24:38 · answer #2 · answered by JR 2 · 0⤊ 0⤋
Clear structure and clearly define your tables and keys, lockings, reporting are really the main keys.
2007-06-14 00:57:31 · answer #3 · answered by Cupcake 7 · 0⤊ 0⤋