Essays24.com - Term Papers and Free Essays
Search

Kanbay System

Essay by   •  August 3, 2016  •  Coursework  •  842 Words (4 Pages)  •  917 Views

Essay Preview: Kanbay System

Report this essay
Page 1 of 4

[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

Varchar (10)

utf8_general_ci

No

Designation_Name

 Varchar (30)

utf8_general_ci

No

Salary_Slab_ID

Int (11)

Yes

Table: sal_slab

Name

Type

Collation

Null

sal_slab_id

Int (11)

No

sal_slab_desc

 Varchar (25)

utf8_general_ci

No

sal_amount

Int (11)

No

Table: Login Page

Name

Type

Collation

Null

ID

Int (11)

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

Varchar (10)

utf8_general_ci

No

Accessory_Name

 Varchar (20)

utf8_general_ci

No

Model

Varchar (10)

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

...

...

Download as:   txt (9.3 Kb)   pdf (241.3 Kb)   docx (45.3 Kb)  
Continue for 3 more pages »
Only available on Essays24.com
Citation Generator

(2016, 08). Kanbay System. Essays24.com. Retrieved 08, 2016, from https://www.essays24.com/essay/Kanbay-System/69919.html

"Kanbay System" Essays24.com. 08 2016. 2016. 08 2016 <https://www.essays24.com/essay/Kanbay-System/69919.html>.

"Kanbay System." Essays24.com. Essays24.com, 08 2016. Web. 08 2016. <https://www.essays24.com/essay/Kanbay-System/69919.html>.

"Kanbay System." Essays24.com. 08, 2016. Accessed 08, 2016. https://www.essays24.com/essay/Kanbay-System/69919.html.