Eurocall ' 99
Université de Franche-Comté, Besançon, France
September 15-18, 1999

Understanding, using and creating web-enabled databases
Wednesday, September 15 from 09:30 to 17:00
Room 27, Propédeutique, 3rd floor


Designing web-enabled databases


Steps:

  1. Define the problem or objective (determine the purpose)
  2. Research current databases (or what is being used as a 'database')
  3. Design the data structures
    -- Determine the tables
    -- Determine the fields (numeric, boolean, time/date, text, binary)
    -- Adhere to naming conventions
  4. Construct relationships
    -- E/R (Entity/Relationship) Diagram
    -- One-to-One, One-to-Many, Many-to-Many, Keys
  5. Implement rules and constraints
    -- Can certain data only take certain formats?
    -- Some fields cannot be left empty
  6. Create views and reports (layouts)
    -- Turning data into information
  7. Implement the design
    -- Pick the software and create the 'computerized' version of your work
  8. Create web format Files -- E/R Diagram , Naming Conventions, Required Fields


Resources:

Gagne, J and Crabb, D. (1998). Database Design and Publishing with FileMaker Pro 4 for Mac and Windows. New York, M&T Books.

Roman, S. (1997). Access Database Design & Programming. Sebastopol, CA, O'Reilly & Associates, Inc.


][Overview][Getting Started ][Conceptualizing][Using][Choosing][Designing][Hands-On]

 

 

.