Database of the staffing table of the enterprise. Control
Replenishment date: 19.01.2008
Content: 005.rar (491.05 KB)
️Automatic issue of goods ✔️
️Automatic issue of goods ✔️
Sales:
4
Refunds:
0
Reviews:
1
Views:
694
Seller discounts
for all goods
for all goods
The goods are given a discount for regular customers.
If the total amount of purchases from a VSbest seller is more than:
If the total amount of purchases from a VSbest seller is more than:
the discount is: 3%
Description
The task. Create a database of the enterprise staffing table.
Indicative composing tables: "Departments", "Positions", "Employees". The total number of fields in the database is at least 20, the total number of records is at least 30.
Create reports: "List of employees not employed in the main production" (query - conditional selection); “Salary summary of each department” (summary request); "List of employees for a given position" (parametric query); Dynamics of job vacations as employees retire (cross-reference)
Indicative composing tables: "Departments", "Positions", "Employees". The total number of fields in the database is at least 20, the total number of records is at least 30.
Create reports: "List of employees not employed in the main production" (query - conditional selection); “Salary summary of each department” (summary request); "List of employees for a given position" (parametric query); Dynamics of job vacations as employees retire (cross-reference)
Additional Information
The database is organized in Microsoft Office Access 2003!CONTENTS 2
PURPOSE AND OBJECTIVES OF DB DESIGN ON THE THEME OF INDIVIDUAL TASK 3
SUBJECT DIAGRAM 3
ESSENCE-LINK MODEL 4
DATA SCHEME IN ACCESS (RELATION MODEL) 5
DESIGNERS OF TABLES AND INQUIRIES, REPORTS ON INQUIRIES 5
"LIST OF EMPLOYEES NOT EMPLOYED IN THE CORE PRODUCTION". 5
"SUMMARY OF EACH DEPARTMENT'S Wages" 6
"LIST OF EMPLOYEES OF ASSIGNED POSITION" 7
"DYNAMICS OF EMPLOYMENT OF JOBS BY THE RATE OF EMPLOYEES TO PENSION" 8
FORMS: MAIN AND SUBSIDIARY. DESCRIPTION OF NAVIGATION AND OPERATING OPPORTUNITIES 9
DEVELOPMENT OF MASTERS, OTHER CONTROL ELEMENTS 12
PROGRAM LISTING 12
LISTING FOR FORM "POSTS" 12
LISTING FORM "DEPARTMENTS" 15
LISTING OF THE "EMPLOYEES" FORM 17
LISTING OF THE "EMPLOYEE DISTRIBUTION" FORM 19
LISTING FORM "MASTER OF FIELDS" 20
CONCLUSION 21
Feedback (1)
+ 1
- 0
22.05.2016+
nice