Re: Planning the Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

suggest you pick up a copy of Database Design for Mere Mortals by Michael J.
Hernandez. it is an excellent step-by-step guide to data modeling using
relational design principles.

hth


"dee" <dee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AE1B0F4B-A17F-470B-ABF4-634E580E6784@xxxxxxxxxxxxxxxx
Hi was wondering if using outline view in Word would be the best way to
create a "blueprint" for a database I wish to create, or is there some
other
option that would be better?

Also, what would be the main items I should make sure to include?

Included, of course, would be the goal of the database, the scope, the
processes used to gather data, the forms, reports, queries, etc. required,
time-frames, who is in charge of what.

Does anyone know of a good Web site that would have suggestions on what to
make sure to include, perhaps a general step-by-step process of creating a
database, from planning to creating objects, normalizing, etc.?

Thanks!

--
Thanks!

Dee


.

Relevant Pages

  • Re: Relationships. Does anyone use them?
    ... If you do not care to "go in into the relationships window to set the relationship" you are, quite simply, going to fail badly any relational database course. ... Relationships are the constraints that are needed to be set up to ensure database structural integrity. ... You really need to go over this in detail, because right now I can tell you, no offence intended and with the greatest of respect, that you are NOT DOING RELATIONAL DATABASE DESIGN WORK at present. ...
    (comp.databases.ms-access)
  • Re: Table design - reducing number of entities
    ... I've looked at a lot of crappy code written against databases. ... lot of that code is crappy, because the database design itself was crappy. ... > look at all the constraints on the putative entities--not forgetting the ...
    (comp.databases.theory)
  • Re: Relationships. Does anyone use them?
    ... why do I need to add 2 tables in the Relationship window and set relationships? ... If you do not care to "go in into the relationships window to set the relationship" you are, quite simply, going to fail badly any relational database course. ... When a database application gets large and widely used, the following is an example of what happens that simply screams for the lowest level constraints to be used. ... You really need to go over this in detail, because right now I can tell you, no offence intended and with the greatest of respect, that you are NOT DOING RELATIONAL DATABASE DESIGN WORK at present. ...
    (comp.databases.ms-access)
  • Re: Basic Database Design
    ... the Client has a Insurance Company ... you'll need some further knowledge on the subject of database design. ... Books: General: Beginner ...
    (microsoft.public.access.tablesdbdesign)
  • Re: speed
    ... > Hi Nicolaas ... > To make a long story short, a well designed database is a good foundation for proper application that helps the users to maintain ... So learning about database design may in time bring you more then 'just' statisfied end ... list of about 15 facilities. ...
    (alt.php)