A ticket system in this case is a system for handling information / files
submitted by various users.
A ticket may be a bug, an expansion or a different type of task.
Ticket system can in practice be used by an IT department, then develop it
as if you were to sit in it.
There should not be a login page so it will be open to all who visit it.
Nor shall there be any permissions, ie anyone can do all in it.
The person who puts up a ticket does not have to specify who should take
care of the task,
the delegates, if so, then the head of the IT department can make the
delegate of the ticket later.
Each ticket contains the title (text), description (text), priority (0-100),
owners (id of the user), date (datetime), done (bool).
The owner in this table is the user which the ticket has been delegete to
There should be a page that lists all the tickets with relevant
You should be able to specify which user you want tickets for,
alternatively, also specify the tickets do not have a user. It should also
be able to sort the tickets more than one column;
For example, priority, date.
You should be able to post new tickets, edit and delete existing tickets
and flag a ticket as complete.
The application will be developed in ASP.NET with C # and SQL Server
database to be used.
All code should be written in English and be well documented.
One should in principle be able to read everything that happens in the
program without reading one line of code, ie just by reading the comments.
An SQL dump of tables and content must also be provided.
There must be no SELECT statements that run without the use out of index
* It is expected to be as up to 16 users in the system.
* It is expected to be available as more than 500,000 tickets.
* The title is at most 32 characters long.
* The description shall be as long as possible.
I just wonder how will these four points have influence on the design and
implementation of the taskSystem ?
can somebody gove me some guidelines what I must think of when designing and
implementing this so called ticket system.