A telephone company may wish to adopt an information system that would allow its technicians access to an online registry of address book contacts, so that each group member can consult at any time and the information contained in it All ' update if applicable (enter new contacts, edit or delete existing contacts).
The Chief of the Information System will expand the portal that is accessed normally members of the group by adding this new feature: Each member will be authenticated by the system in use by the insertion of credentials (username and password) to ensure secure access to information which is permitted, and the information shared between multiple users of the working group.
In order to produce regular statistics to optimize the work of the group must keep track of every access to the system, recording the basic information (identifier user name, date and time of access, time and date of logoff, ...) and transactions (consultations / updates section of the contact) performed by each user authenticated in the case of update operations should be maintained even the status of the book before the change until the administrator of the system will validate the changes and make them public.
Applicants without the necessary additional assumptions:
1. Produce an analysis of the reality of reference by focusing on safety aspects of the information system
2. Projects a conceptual scheme and corresponding logical database schema
3. Perform the definition of relations and the following in SQL queries expressed in language SQL:
- Display the list in alphabetical order by name, of the contacts in a specific province
- List, in chronological order, the accesses made by a member of the group
- Calculating and displaying the average daily number of hits in a given period of time
- Calculate and display the total number of new contacts entered, for each member
- List the steps in a given day by each user of the working group
- View account information over more interested in a week
4. Propose a solution for web-based administration system and code in a programming language of your choice in a significant segment of the project realized.
- Calculate and display the total number of new contacts entered, for each member
- List the steps in a given day by each user of the working group
- View account information over more interested in a week
4. Propose a solution for web-based administration system and code in a programming language of your choice in a significant segment of the project realized.
0 comments:
Post a Comment