470,815 Members | 1,204 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

Request New Database Procedure

564 Expert 512MB
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,
Sep 27 '10 #1
2 157618
295 Expert 100+
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.
Nov 22 '10 #2
32,311 Expert Mod 16PB
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.
Nov 27 '13 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Shiraz | last post: by
1 post views Thread by Alan T | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.