Kanbay System
Essay by Nodirbek Sobirjonov • August 3, 2016 • Coursework • 842 Words (4 Pages) • 1,032 Views
[pic 1][pic 2][pic 3]
Kanbay System |
Sobirjonov Nodirbek – B1300922 |
YEAR 1 |
b1300922 |
[Pick the date] |
E-R Diagram
[pic 4][pic 5][pic 6][pic 7][pic 8][pic 9]
[pic 10][pic 11][pic 12][pic 13][pic 14][pic 15][pic 16][pic 17][pic 18][pic 19][pic 20][pic 21][pic 22][pic 23][pic 24][pic 25][pic 26][pic 27][pic 28][pic 29][pic 30][pic 31]
[pic 32]
[pic 33][pic 34][pic 35][pic 36][pic 37][pic 38][pic 39][pic 40][pic 41][pic 42][pic 43]
[pic 44][pic 45][pic 46][pic 47][pic 48][pic 49][pic 50][pic 51][pic 52][pic 53][pic 54][pic 55][pic 56][pic 57][pic 58][pic 59][pic 60][pic 61][pic 62][pic 63][pic 64][pic 65][pic 66][pic 67][pic 68][pic 69][pic 70][pic 71][pic 72][pic 73][pic 74][pic 75][pic 76][pic 77][pic 78]
Main Data Dictionary
SQL Name: B1300922.sql
Table: Employee
Name | Type | Collation | Null |
Emp_id | Varchar (6) | utf8_general_ci | No |
Emp_Name | Varchar (30) | utf8_general_ci | No |
DOB | Date/time | utf8_general_ci | No |
DOJ | Date/time | utf8_general_ci | No |
Qualification | Varchar (10) | utf8_general_ci | No |
Design_Code | Varchar (10) | utf8_general_ci | No |
Dept | Varchar (10) | utf8_general_ci | No |
Proj_ID | Varchar (10) | Ref Project | No |
Mgr_Id | Varchar (10) | Ref Manager | No |
Trainer_Id | Varchar (10) | Ref Trainer | Yes |
Accessory_id | Varchar (10) | Ref |Accessory | Yes |
Table: Employee Type
Name | Type | Collation | Null | ||
Design_Code |
| utf8_general_ci | No | ||
Designation_Name | Varchar (30) | utf8_general_ci | No | ||
Salary_Slab_ID |
| Yes |
Table: sal_slab
Name | Type | Collation | Null | ||
sal_slab_id |
| No | |||
sal_slab_desc | Varchar (25) | utf8_general_ci | No | ||
sal_amount |
| No |
Table: Login Page
Name | Type | Collation | Null | ||
ID |
| No | |||
username | Varchar (50) | utf8_general_ci | Yes | ||
password | Varchar (50) | utf8_general_ci | Yes |
Table: Manager
Name | Type | Collation | Null |
Mgr_Code | Varchar (10) | utf8_general_ci | No |
Mgr_Name | Varchar (30) | utf8_general_ci | No |
Mgr_Start_Date | Date/time | No | |
Mgr_End_Date | Date/time | No | |
Mgr_Salary | Int (11) | Yes | |
Mgr_Qualify | Varchar (15) | utf8_general_ci | No |
Mgr_Dept | Varchar (10) | utf8_general_ci | No |
Table: Accessory
Name | Type | Collation | Null | ||
Accessory_ID |
| utf8_general_ci | No | ||
Accessory_Name | Varchar (20) | utf8_general_ci | No | ||
Model |
| utf8_general_ci | No | ||
Brand | Varchar (15) | utf8_general_ci | No |
Table: Project
Name | Type | Collation | Null |
Proj_ID | Varchar (10) | utf8_general_ci | No |
Proj_Name | Varchar (30) | utf8_general_ci | No |
Proj_Start_Date | Date/time | No | |
Proj_End_Date | Date/time | No | |
Proj_Status | Varchar (10) | utf8_general_ci | Yes |
Table: Trainer
Name | Type | Collation | Null |
Trng_Code | Varchar (10) | utf8_general_ci | No |
Trng_Name | Varchar (30) | utf8_general_ci | No |
Trng_Start_Date | Date/time | No | |
Trng_End_Date | Date/time | No | |
Trng_Salary | Int (11) | Yes | |
Trng_Qualify | Varchar (25) | utf8_general_ci | No |
Trng_Dept | Varchar (30) | utf8_general_ci | No |
...
...