Section |
Description |
Preface |
- Describe expected reader. (You will expect mostly technical reader
but also a super user, who is a system user but has some knowledge of
the data. They may use this in the future to help ask for reports. They
will also be able to make sure all the information they expected is
being captured in the system.
|
Version |
- Version History (empty at this point perhaps)
|
Introduction |
- Copy System intro from your requirements spec
- Add a paragraph at the top explaining that this is the database design
and that you will be defining tables and database administration strategy.
|
Glossary |
- Define any terms a user or programmer may need to know to read this.
(Remember both read this.)
|
Database Technology |
- Database type (most will choose mysql)
- How many servers?
- How many databases?
- Will you use replication to store a database copy locally for transaction
use or just for reporting?
- Databases outside your system that you will be interfacing to, if
any
|
ERD |
- Entity Relationship Diagram
|
Table with Columns Listing |
For each table:
- Table name
- Short table description
- Column names with type and length and if necessary, a short description
- Table Primary Key
- At least 2 lines of sample data.
(Note: If you prefer to just create the table and include the create
table statement, that is okay for this class.)
|