Request New Database Procedure

[CroCrew]

Hello everyone,

I would like to thank everyone first that reads this post and takes the time to provide me with your view/answer to my question below.

We are starting to apply “Procedures” and “Standards” in our organization that span across each development unit. Currently each unit has their own way of doing business. My question is not about the standards like “Naming Conventions” for tables but, more towards the procedures aspect like how to do something.

I have been tasked with helping create a procedure that when a new application has been requested by a development unit how to handle that request. So I would like to ask any of the people out there that are DBAs in their place of business how do you do accept request? What are your procedures? I am hoping that someone could post an example of a form that they use as their procedure.

Again, thanks for any feedback.

Happy Coding,
CroCrew~

[maxamis4]

This is a good question.

First and far most you have to establish a scope. The biggest issue with development is the scope creep of the project. Gather good requirements and understand what the customer wants regarding the application and what it captures. Commit to that version release as your primary scope. The last thing you want is the scope of your project changing and having to pay twice as much form something that was poorly planned.

The best way to capture these requirements is through work flow. The logic that is applied to your application (keep in mind at this point this is all concept no actual development is done). Many misconstrue work flow as one chart. This is a typical error in all design implementations. Work flow should be established for all aspects of the application include the function that it will perform. This will help identify what fields your database will need and what type of programmatic solutions your database will need.

This is just an overview of how I start projects regarding databases. The topic could go on forever so start with these two since they will encompass a ton of time.

[NeoPa]

This thread will be closed to avoid further spam posts.

Anyone wishing to contribute may report this post and include their submission (intended post) for review. If it is a serious post then we'll open the thread again to allow the post.