| Custom database software development is facilitated | | | | etc.b. Database level security – MS Access has |
| by the use of a checklist of standard questions to be | | | | security, but SQL Server has a much tighter security |
| answered before a system is created, and before | | | | model tied in with the Win 2000/NT operating |
| analysis begins. This checklist is provided to assist in | | | | system.c. Application level securityd. Minimum |
| the Analysis/Requirements phase of a new custom | | | | (pseudo) security algorithm - low coste. Please |
| software development project. | | | | specify User Groups that may have special Security |
| If you are interested in having 21st Century | | | | needs requiring different levels of security:i. |
| Technologies, Inc. create a new system for you, | | | | Administrative Assistantsii. Analystsiii. Engineersiv. |
| then the following checklist and the associated | | | | Managersv. Company Ownersvi. System |
| answers will facilitate the analysis process. The | | | | Administrators |
| answers can be e-mailed or faxed to us at the email | | | | 16. Are Backup Scenarios currently in place? Backups |
| address and fax number at the bottom of the page. | | | | will be an integral component of the system. The |
| BUSINESS CONSIDERATIONS | | | | importance of this cannot be over emphasized.a. |
| 1. Desired delivery date or proposed project schedule. | | | | Daily, Weekly, Monthly onto tapeb. Daily, Weekly, |
| 2. Business reason for, and urgency of project. | | | | Monthly onto CD or other optical drivec. Onto |
| 3. What are the cost constraints? | | | | another computerd. Regular backups located at a |
| 4. Use cases – description of how each group | | | | remote site |
| of users will be using the system.a. General business | | | | 17. Are Anti-Virus protection and policies in place? It is |
| process – web user will buy a product, web | | | | an important part of ensuring that a system stays up |
| user will add a customer, web user will add contact | | | | and running. |
| information, etc.b. Input/Output – web users | | | | 18. Will remote troubleshooting be desired? The |
| will enter data into forms, data will be imported, | | | | addition of Error Processing and Logging software will |
| administrator must run many management reports, | | | | facilitate remote support and troubleshooting. |
| administrator needs to export to Excel and text, | | | | 19. Desired Documentation?a. Noneb. Installationc. |
| etc.c. Frequency of activity – many times | | | | Userd. Administratore. Softwaref. On-line helpg. |
| each day, once daily, weekly, etc.d. Cycles of activity | | | | Specialh. All of the above |
| – weekly sales reports to all sales managers | | | | 20. What is the proficiency level of all users for the |
| on Monday morning, close books at end of year, etc. | | | | target tools and environments - Windows, Excel, |
| NATURE OF APPLICATION | | | | etc.? |
| 1. Do you have a desired development tool or | | | | 21. Will interfaces to other systems (accounting, |
| technology in mind? You may want to split the | | | | payroll, another database, GIS, truck routing, etc.) be |
| application into some parts that can be run on a | | | | required? This will affect the data model and system |
| Windows workstation computer, while other parts | | | | configuration, so early planning for these interfaces is |
| (like reports, or timecard entry screens) are accessed | | | | critical to their successful inclusion into the system. |
| via a web browser on your local intranet. Web | | | | 22. Is an audit trail function desired for changes to |
| applications and reports can be viewed on all | | | | existing data? What parts of the system will need to |
| computer types and operating systems that are | | | | be audited? |
| capable of viewing web pages. Some tools currently | | | | 23. Is government reporting or data security required |
| available to build the system are listed here:a. C# | | | | - Sarbanes Oxley, HIPAA, etc. |
| VB.NETb. ASP.NETc. Active Server Pages or Cold | | | | 24. Number of reports. A sample hardcopy or at least |
| Fusion for robust database driven Web applicationsd. | | | | hand drawing of each will significantly help in |
| ColdFusione. Visual Basicf. SQL Serverg. MS Accessh. | | | | determination of report prices and commonalties |
| JavaScript – for cross browser compatibility,i. | | | | (company headers, formats, etc.). Important items |
| VBScript – for server scripting, and client | | | | are:a. Number of sections including sort groups,b. |
| scripting if Internet Explorer is the only client | | | | Definition of the source data for all fields in each |
| browserj. Dreamweaver – for higher ended | | | | section and their calculation method,c. Summaries,d. |
| client functionalityk. SQL Server Reporting Servicesl. | | | | Desired output format:i. Windows screen previewii. |
| Crystal Reports – for Windows and Web | | | | HTMLiii. E-Mailiv. PDFv. Delimited Textvi. Excel |
| based reportsm. ActiveReportsn. Excelo. PowerPointp. | | | | spreadsheetvii. Other outputs |
| Interactive Voice Response (IVR) Systems – | | | | 25. Is an ad hoc user-defined reporting, data retrieval, |
| dial 1 for English, 2 for Spanish… | | | | or analysis (On Line Analytical Processing (OLAP), |
| 2. If other applications are involved (MS Word, MS | | | | Data Mining, etc.) capability desired? |
| Excel, QuickBooks, etc.), what version will be used? | | | | 26. Is an installation program needed for distribution |
| 3. Desired screen resolution (800×600, | | | | of an application to many users? |
| 1024×768, etc.), | | | | 27. Is an automated network or internet installation |
| 4. Screen Size (15", 17", 19", 21") | | | | desired? |
| 5. Preferred Font and size (Arial 10, Times New | | | | 28. Are custom point to point communications |
| Roman 12, etc.)? | | | | needed? This may also include automated faxing. |
| 6. Target Windows version for each client computer | | | | 29. Special Considerations:a. Unique business rules, |
| in the system (98, NT 4.0, 2000, XP, 2003 Server, | | | | calculations, desired warnings, etc.b. Significant text |
| etc.), | | | | parsingc. Known or possible issues and problems that |
| 7. Web Server - MS Internet Information Services | | | | may be alleviated with testingd. Voice driven |
| (IIS), Apache, etc. | | | | capabilitye. Multiple databases (Access and SQL |
| 8. Target computer Operating System if not a | | | | Server, Oracle, etc.) |
| Windows Platform – Apple, Unix, Linux, etc. | | | | DATA AND VOLUME |
| 9. Target workstation hardware for all client | | | | 1. How many users are expected on the system in |
| stations,a. Clock speed -1333, 1500, 2000, 3000, etc. | | | | the near (first 6 months) and long (1 - 3 years and |
| MHz,b. Hard drive space - 100, 200, 400, etc. | | | | past) term? |
| Gbytes,c. RAM - 128Mb, 256Mb, 512Mb, 1Gb, etc. | | | | 2. How many users are expected to use the system |
| 10. If a network application, which network and | | | | at the same time during peak periods in the near and |
| version? -Windows, Novell 3.1, Novell, etc. | | | | long term? |
| 11. What are the drive letters for the networked | | | | 3. What type of data traffic will be on the network |
| back end databases if a network application? F, G, H, | | | | for the near and long term – numbers, text, |
| etc.? This reduces the deployment effort by | | | | images, video, multi-media, etc.? |
| developing in the same environment as the target | | | | 4. What is the expected volume of traffic for the |
| workstations. | | | | near and long term? |
| 12. If available and pertinent, please provide a | | | | 5. What is the estimated number of data records to |
| network configuration diagram with paths to server | | | | be stored for the near and long term? |
| (where database will reside) and all clients, security | | | | 6. Do we need to import data from existing files or |
| user groups, etc. | | | | systems? Note that Characters like ' " # have special |
| 13. Is 24×7 (24 hours a day, 7 days a week) | | | | significance in data processing and conversion, and |
| uptime required? If so, please explain the business | | | | require special code handling. Names (D'Joy) and other |
| need. We will discuss this further. The cost goes up | | | | data fields may contain these characters.a. No. |
| as more uptime is required. More resources are | | | | Example data will usually be provided in database, |
| needed – various personnel on pagers, | | | | text, or spreadsheet format. This helps significantly in |
| redundant computers or components like power | | | | system testing and allows for error discovery and |
| supplies RAID or mirrored hard drives, etc. | | | | error trapping before the system is delivered.b. Yes.i. |
| 14. Is Internet/Intranet data access desired?a. For | | | | Is all or part of the existing data needed? What |
| data entry?b. For report reviewing only?c. To | | | | parts?ii. Can use of the existing data be stopped |
| disseminate existing documents?d. To email | | | | while we convert the data into the new system?iii. Is |
| notification of pre-determined business trigger events | | | | this a one time data conversion, or will we have to |
| (project milestone met and approved, employee | | | | import data from existing systems regularly?iv. Are |
| appraisal ready for approval, etc.)? | | | | some fields mostly blank?v. Are some desired fields |
| 15. Is Security desired?a. Extremely high network | | | | missing? |
| (Internet) security – firewall, proxy server, | | | | |