Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've been tasked with writing an analysis of a database that is currently used on a small scale. The intent of the document is to show to the business (as well as technically) that the database can scale to support other business divisions. I've struggled to find any database documentation standards on the web. It seems as though most databases are not documented; let alone have a basic ER diagram.

I'm more specifically concerned with the technical side and this is the outline I've come up with:

  • Non-functional Requirements
    • Storage needs
    • Server reliability
  • Schema Design & Normalization
    • Relational Integrity
    • Domain Integrity
      • Data types
      • (FOREIGN KEY, DEFAULT, NOT NULL constraints)
    • Referential Integrity
      • Parent/child references
  • Query Design

Is there any aspects that I'm missing or should focus more on?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

I would actually verify how it scales up: set up a test environment, expose to to the workload you are expecting, and see what happens. That done, describing your tests would be easy.

If you skip this essential step, your write-up might look good on paper and be completely useless.

share|improve this answer
    
Thanks. I agree that this would be best method. However, I feel that the effort would not be worth it since this is a very small application that is going from a handful of users to maybe 25-30. I would like to mainly focus on the design of the database. –  Kermit Nov 5 '12 at 15:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.