472,988 Members | 2,594 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,988 software developers and data experts.

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 165995
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,550 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Adnan | last post by:
I want to read a file list in a directory from a database procedure. I m using Oracle 9i Release 2. How to do??? I don't want to user external procedures. I know it can be done through java stored...
by: Leroy | last post by:
Hello, I have a question regarding the maximum number of parameters that can be passed to a procedure. In VB 6 the max was 60. What is the max for Dot Net? please and thanks.
by: Jack | last post by:
Hi, I am trying to run an example code from a book. However I am getting the following error message: Number: -2147217900 Description: Syntax error or access violation Source: Microsoft OLE...
by: Shiraz | last post by:
Updated to the latest version of DBD-mysql using perl -MCPAN -e "install DBD-mysql" and now the calling mysql function r2() within perl work > $SQL_Text = "select r2() from dual " ; >...
by: Alan T | last post by:
Is there a sample code I can use to call a stored procedure which has input and output paramerts ?
by: kkubio | last post by:
Hi all, I'd like some advice on adding an extended stored procedure (XP). I found an article which advises "put the call of the extended prodecure within a database procedure in the database from...
by: nielsena54 | last post by:
I am currently working on a client-server project using WCF. I have been using .NET for about 3 months now and have some questions about what it can do and how to do it. Before the question, here...
by: Lucky | last post by:
Hi guys, I'm having problem with case sensitive collation of SQL Database. one my client is having case sensitive database. While developing the Data Layer i didn't consider this scenario. the...
by: vamsioracle | last post by:
Hi all, I have a stored procedure registered with the following details short name: delegateproc executable: delegateproc attached to application developer request group. and i am...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.