Project description
Laboratory work on databases is required. It is necessary to develop an ER-diagram, and then, using the Microsoft Access database, create a database of an organization engaged in conducting sociological surveys by phone. The database shall allow the storage of the following information:
1. List of questions to which you need to get statistics. The survey is always conducted under a contract with an organization. For each question, several possible answers are stored, and the maximum number of people to be interviewed is known, and the planned date by which the survey should be completed. If the survey has already been conducted, the actual date of the end of the survey should be kept.
2. List of staff performing surveys. For each employee, the name and home phone are known.
3. List of survey results. It is stored information that such and such a date, at such and such a time, such and such an employee called on such and such a phone and received such and such a response.
It is assumed that only one question is asked in each survey. The phone that the employee calls is selected randomly. The database should contain the following integrity limitations:
1. Surveys should take place between nine in the morning and nine in the evening. The system does not allow to record the results of surveys in which the call time does not fall within the specified interval.
2. It is forbidden to call twice on the same phone during the month.
1. List of questions to which you need to get statistics. The survey is always conducted under a contract with an organization. For each question, several possible answers are stored, and the maximum number of people to be interviewed is known, and the planned date by which the survey should be completed. If the survey has already been conducted, the actual date of the end of the survey should be kept.
2. List of staff performing surveys. For each employee, the name and home phone are known.
3. List of survey results. It is stored information that such and such a date, at such and such a time, such and such an employee called on such and such a phone and received such and such a response.
It is assumed that only one question is asked in each survey. The phone that the employee calls is selected randomly. The database should contain the following integrity limitations:
1. Surveys should take place between nine in the morning and nine in the evening. The system does not allow to record the results of surveys in which the call time does not fall within the specified interval.
2. It is forbidden to call twice on the same phone during the month.
Education and consulting Bank transfer, E-money
