|
|
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:
- Define
the problem or objective (determine the
purpose)
- Research
current databases (or what is being used as a
'database')
- Design
the data structures
-- Determine the tables
-- Determine the fields (numeric, boolean,
time/date, text, binary)
-- Adhere to naming conventions
- Construct
relationships
-- E/R (Entity/Relationship) Diagram
-- One-to-One, One-to-Many, Many-to-Many,
Keys
- Implement
rules and constraints
-- Can certain data only take certain
formats?
-- Some fields cannot be left empty
- Create
views and reports (layouts)
-- Turning data into information
- Implement
the design
-- Pick the software and create the
'computerized' version of your work
- 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.
|
|