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