- The customer's request is always correct, but it is not the best.
Demand is basic enterprise information management:
1. Require local entry and management of information.
2. Require information about Web browsing support.
For the first point, the customer considers the safety and server load capacity. Including the entry, query, deletion, modification of the information; including the salary automatic accounting in the business model, including the monitoring and automatic prompt of the information system.
For the second point, the customer considers information browsing and limited information modification operations. And some level of relationship between customers.
There are many times, I understand that customers are always correct, but there is a lot of distance between customers' thoughts and the effects of the effect, I have to estimate that many customers are unclear.
Preliminary design is this: old way, two levels: business relationships and information models. Business relationship as much communication, information model extracts the information relationship in the business.
The entire system is divided into two parts. The first part is information management, by the Delphi SQL Server architecture. The second part is information browsing. Developed by IIS ASP. Their core and abstraction is the database service.
The basic table of the database is from the information model and the relationship, tends to 3NF.
Pat out the required data types from the needs; the definition of the stored procedures and triggers; established views from local C / S and B / S data logic and relationship; the database trial operation. Sometimes, when the contradiction occurs, The minimum cost solves the problem.