Hardware Sales And Service

Customer details Field Name cname sno addr mno nop rps dop war

primary key: sno Type varchar(50) bigint nchar(10) bigint int float datetime int

Description Customer name Serial Number address Mobile no Number of system purchased Rate per system Date of purchased Warranty

Employee details Field Name eid ename gen [add] pno jd qu desi exp

primary key : eid Type nvarchar(50) nvarchar(50) varchar(50) nvarchar(50) bigint datetime varchar(50) varchar(50) nvarchar(50)

Description Employee ID Employee Name Gender Address Phone number Joined date Qualification Designation Experience

Feed back Field Name Name date eid mno mih

primary key:mno Type varchar(50) datetime nvarchar(50) bigint nvarchar(MAX)

Description Name Date Email ID Mobile number May I help you

Reply Field Name eid yn mno

primary key:eid Type nvarchar(MAX) text bigint

Salary details Field Name eid ename bs cps nos tc np

Description Email ID Yes/No Mobile no primary key:eid

Type nvarchar(50) varchar(50) float float int float float

Description Employee ID Employee name Basic salary Commission Number of system Total commission Net pay