Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-08-2015, 02:32 AM   #1
RainLover
VIP From a land downunder
 
RainLover's Avatar
 
Join Date: Jan 2009
Location: Qld Australia
Posts: 5,044
Thanks: 28
Thanked 517 Times in 492 Posts
RainLover will become famous soon enough
When is a Database Finished. Where do I stop.

Programming is:

Phase 1
Design
Coding
Testing, Testing, Testing
Find what does not work

Phase 2
More Design
More Coding
More Testing, Testing, Testing
Find what does not work now

repeat Phase 2 until you do not find an more issues.

Phase 3
Give the app to the end users
End users find what does not work now
Go back to Phase 2

Phase 4
Wait for the end users to have issues or the requirement have changed
or
Developer/programmer learns how to do things better

Go back to Phase 2

Phase 5
Developer/programmer learns how to do things better and the original design will no longer meet the needs of the users.

Time scrap the old app and create a new one and convert the data.

Back to Phase 1.


I have found that a database app never really is finished until it is no longer used at all.


__________________
Regards Rain.

Windows 7. Access 2003. East Coast Australia. GMT +10,

RainLover is offline   Reply With Quote
Old 07-08-2015, 04:10 AM   #2
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,657
Thanks: 98
Thanked 1,500 Times in 1,415 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: When is a Database Finished. Where do I stop.

From the developer's perspective, the database is finished when they are no longer paid to keep working on it.
Galaxiom is offline   Reply With Quote
Old 07-09-2015, 04:51 AM   #3
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,569
Thanks: 92
Thanked 1,682 Times in 1,560 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: When is a Database Finished. Where do I stop.

The only time an application can be finished is if the process on which it is modeled can never be changed again. Which is why the government thinks that some projects can actually be finished. But as long as Congress is still alive and kicking, it ain't necessarily so.

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 07-09-2015, 04:56 AM   #4
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,791
Thanks: 55
Thanked 1,027 Times in 993 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: When is a Database Finished. Where do I stop.

I think its finished when the user has an app that does what he wants.

It may need some support from time to time, but generally that's it.

I have several apps that have been running without amendment or intervention for at least 5 years.
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Old 07-09-2015, 05:03 AM   #5
ButtonMoon
Newly Registered User
 
Join Date: Jun 2012
Posts: 304
Thanks: 11
Thanked 56 Times in 55 Posts
ButtonMoon will become famous soon enough
Re: When is a Database Finished. Where do I stop.

Quote:
Originally Posted by RainLover View Post
I have found that a database app never really is finished until it is no longer used at all
Exactly. Software should reflect changing business needs. Very often change is the only constant.

Your description of the software lifecycle looks like a Waterfall methodology. Many organisations have realized that Waterfall isn't such a good fit for the modern business environment. Increasingly these days Agile software development approaches are used instead (Scrum, Kanban, XP).
ButtonMoon is offline   Reply With Quote
Old 07-09-2015, 06:03 AM   #6
RainLover
VIP From a land downunder
 
RainLover's Avatar
 
Join Date: Jan 2009
Location: Qld Australia
Posts: 5,044
Thanks: 28
Thanked 517 Times in 492 Posts
RainLover will become famous soon enough
Re: When is a Database Finished. Where do I stop.

I hope you all realise that what I posted was mainly for light entertainment. Even though it is based upon reality.
__________________
Regards Rain.

Windows 7. Access 2003. East Coast Australia. GMT +10,

RainLover is offline   Reply With Quote
Old 07-09-2015, 06:47 AM   #7
vbaInet
AWF VIP
 
Join Date: Jan 2010
Location: U.K.
Posts: 26,374
Thanks: 0
Thanked 2,423 Times in 2,389 Posts
vbaInet is a name known to all vbaInet is a name known to all vbaInet is a name known to all vbaInet is a name known to all vbaInet is a name known to all vbaInet is a name known to all
Re: When is a Database Finished. Where do I stop.

After several iterations...

Phase 5

Fix all bugs, test, hand over to client's IT guys, do a runner!

vbaInet is offline   Reply With Quote
Old 07-12-2015, 07:47 AM   #8
spikepl
Eledittingent Beliped
 
spikepl's Avatar
 
Join Date: Nov 2010
Location: San Serriffe
Posts: 6,144
Thanks: 77
Thanked 980 Times in 958 Posts
spikepl is a jewel in the rough spikepl is a jewel in the rough spikepl is a jewel in the rough
Re: When is a Database Finished. Where do I stop.

That is all totally [struck by the censor].


Any project has 6 phases:

  1. Enthusiasm,
  2. Disillusionment,
  3. Panic and hysteria,
  4. Hunt for the guilty,
  5. Punishment of the innocent, and
  6. Reward for the uninvolved
.
__________________

Don't tell us what did not happen.
Do you tell the mechanic about your car "it doesn't work" or vague stuff like:
I couldn't, No joy, To no avail, No go
, Incorrect, Wrong, Seems, Without success, It didn't let me, I/it failed.

Do tell us what did happen
:

I want this ... to happen, I attempted this ..., using this ... code and pressing these buttons, the system did this ... in response, and I got this ... error in this ... line.

Did it help? Pass it forward!

Joys of Access:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Last edited by spikepl; 07-12-2015 at 11:50 AM. Reason: typo
spikepl is offline   Reply With Quote
Old 07-17-2015, 07:42 AM   #9
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,569
Thanks: 92
Thanked 1,682 Times in 1,560 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: When is a Database Finished. Where do I stop.

Spike, you must have worked for the U.S. Government as a contractor (if you know the six-step project guide).
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 07-18-2015, 12:43 PM   #10
burrina
Newly Registered User
 
Join Date: May 2014
Posts: 974
Thanks: 67
Thanked 151 Times in 133 Posts
burrina will become famous soon enough
Re: When is a Database Finished. Where do I stop.

Rain, I was thoroughly entertained, Thanks for the memories.

P.S.
Short Answer: NEVER

__________________
Up Late? It's the What If Safeguards.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
burrina is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to count months after finished last year & count days after last finished month? mraccess101 Queries 3 04-14-2013 11:09 AM
distributing your finished database NigelShaw General 8 07-21-2009 01:33 PM
take a look at my finished database chewy General 47 02-21-2007 07:41 AM
My database is nearly finished!!! Looking for a few answers 8) ogg13 General 2 02-07-2007 06:14 PM
Stop Watch Database help TIDMAN General 3 07-11-2004 02:58 AM




All times are GMT -8. The time now is 07:56 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World