
|
Step 2 is the process of Conceptual database design. I have identified the following Access-specific entities (others are look-up tables derived from the SIS database structure): Conventions used: underlined terms refer to primary keys (PK); "FK" refers to foreign keys. Data Architect is one possible tool to use to convert the following entities into appropriate Entity-Relationship Diagrams.
Terms
Examples: 992, Spring 1999, 1/6/99, 5/8/99Student Athletes
Award
Vendors
Debits & Credits
The database design process is comprised of the following steps*:
|
| Step | Description |
| 1 | Requirements collection and analysis |
| 2 | Conceptual database design |
| 3 | Choice of a DBMS |
| 4 | Data model mapping (also called logical database design) |
| 5 | Physical database design |
| 6 | Database system implementation |
Other Links:
Last modified by Blaise Byron Faint on: July 23, 2001