Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Requirements  Requirements for a Notes Field
Previous Previous
 
Next Next
New Post 12/9/2014 11:09 AM
User is offline Mohammad
5 posts
10th Level Poster


Requirements for a Notes Field 
Can you give me some requirements for a notes field? I tried to google it but no luck! Thanks!
 
New Post 12/12/2014 12:09 AM
User is offline NitWitNick
259 posts
5th Level Poster


Re: Requirements for a Notes Field 

You will need to ask your users how they prefer to enter notes ... Will you have one field ... ie. 30 char long and entering them one at a time on multiple lines ?


or

Will you have a single notes field where they can type in multiple notes at once ... like a Visual Basic Text Field or like the Notes Field you are using here on Modern Analyst to enter in your questions?


Based on the user preferred method ... talk to your Database Administrator to see what their preferred method is to store that data.


Will they store it One Note At a Time:

You would need to create some kind of database varchar field. One Note, One Record.

You would also need a sequence or Date/Time field to keep them in order ... and display them in some type of grid in that order.


Or


Will they store it Multiple Notes At a Time ... like into a Visual Basic Memo Field.

You would need to creaate a database Field to hold the notes:


The database field type depends on your database ... ask your Database Administrator what they are using:

Access = Memo (Access 2010 can store up to 1 gigabyte of characters).

MySQL = LONGTEXT (Holds a string with a maximum length of 4,294,967,295 characters).

SQL Server = varchar(max) (Variable width character string. Maximum 1,073,741,824 characters).

Oracle = Long (Can store variable-length character data containing up to 2 gigabytes of information).

Etc.

----

The user part is easy ... draw a picture (wireframe) of your user interface displaying how the notes field will look ... single fields or a memo field ... describe how they will enter the notes.

The technical part was described above ... talk to your Database Administrator to see how the data will be entered into the database and what fields they prefer to use or create.

Also get the names of any Tables and Fields they will create so you can put that into the functional specs for the database Administrator to create and so the programmers know what to use..


It Ain't Hard ... It Just Takes Time To Be Detailed ... Have Fun  

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Requirements  Requirements for a Notes Field

Community Blog - Latest Posts

Gen1us2k
Gen1us2k
Most of the IT projects imply constant cooperation between the team members and customers. Although it might be often overlooked, the role and the importance of the client within the project is very crucial. Thus, it is in your interest to build a strong relationship based on trust. However, gaining trust on a single occasion is not a dealmaker &md...
0 Responses
emorphistechno
emorphistechno
Introduction In today's world, most enterprises work aggressively to achieve a higher level of business growth, which is made possible by leveraging one of the best automation technologies. One such technology is Robotic Process Automation (RPA) that plays a vital role in streamlining the customer experience in the most profitable manner.&nb...
0 Responses
Nick Stowers
Nick Stowers
Introduction   When I was introduced to scrum, the burndown chart was a tool that was highly emphasised however I feel the purpose has changed from it being a tool to predict (to a certain level) timescales for delivery to a tool that measures a team’s productivity…..in other words, the focus is on the number of points clear...
0 Responses






Latest Articles

Top Metrics for measuring Agile Project’s success
Aug 01, 2020
0 Comments
Good news is that the adoption of an agile approach is increasing with more and more projects being successful. As a business analyst / project manage...
Copyright 2006-2020 by Modern Analyst Media LLC