the service manager prepared by : dilip sheladiya(08it051) : ramesh bamrotiya(09it043) : jagdish...
TRANSCRIPT
![Page 1: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/1.jpg)
THE SERVICE MANAGER
Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group ID :090470110025
![Page 2: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/2.jpg)
DATA DICTIONARY
Login DetailColumn Name Data Type Constraint Description
User_name nvarchar(50) Not null Employee’s user name for login
Password nvarchar(50) Not null Employee’s password for login
![Page 3: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/3.jpg)
CONT……
Add_UserColumn Name Data Type Constraint Description
User_id int Primary Key,Not Null
It define user’s uniqe id
[First name] char(20) Not null User’s firstr name
[last anme] char(10) Not null User’s last name
Gender char(10) Not null User’s gender
Birth_date datetime Not null User’s birthdate
Phone_no int Not null User’s phoneno
Email_id nvarchar(50) Not null User’s emailid
City char(20) Not null User’s city
![Page 4: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/4.jpg)
CONT……Employee
Column Name Data Type Constraint Description
Employee_id int Primary Key,Not Null
It define employee’s uniqe id
Employee_name nvarchar(50) Not null Employee’s name
Address nvarchar(50) Not null Employee’s Address
Phone_no int Not null Employee’s phone no
[Date of join] datetime Not null Employee’s date of join
Department nvarchar(50) Not null Employee’s department
Email nvarchar(50) Not null Employee’s email
![Page 5: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/5.jpg)
Party
Column Name Data Type Constraint DescriptionParty_id int Primary Key,Not
NullIt define party’s uniqe id
Party_name nvarchar(50) Not null It define party’s name
Address nvarchar(50) Not null It define party’s address
City nvarchar(50) Not null It define party’s city
Phone no int Not null It define party’s phone no
[No of items] int Not null It define no of item’s
Email id nvarchar(50) Not null It define party’s email id
![Page 6: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/6.jpg)
Product
Column Name Data Type Constraint Description
Product_id int Primary Key,Not Null
It define product id
Product_name nvarchar(50) Not null It define product name
Product_type nvarchar(50) Not null It define product type
[manufacture date]
datetime Not null It define product manufacture date
[Expire date] datetime Not null It define product expire date
price nvarchar(50) Not null It define product price
![Page 7: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/7.jpg)
Bill
Column Name Data Type Constraint Description
Bill_id int Primary Key,Not Null
It define bill id
Party_id int Not null It define party id
Bill_no nvarchar(50) Not null It define bill no
Date datetime Not null It define bill date
[Bill start date] datetime Not null It define bill start date
[Bill expire date] datetime Not null It define bill expire date
[No of items] nvarchar(50) Not null It define no of items
[Net amount] nvarchar(50) Not null It define net amount
![Page 8: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/8.jpg)
CONT……
Call_Status
Column Name Data Type Constraint Description
Party_id int Primary Key,Not Null
It define party id
Bill_id int Not null It define bill id
[Service type] nvarchar(50) Not null It define service type
[Service date] datetime Not null It define service date
![Page 9: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/9.jpg)
CONT……
Service
Column Name Data Type Constraint Description
Service_id int Primary Key,Not Null
It’s define service’s uniqe id
Bill_id int Not null It’s define bill id
Party_id int Not null It’s define party’s uniqe id
Service type nvarchar(50) Not null It’s define service type
Employee_id int Not null It’s define employee’s uniqe id
![Page 10: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/10.jpg)
CONT……
Status
Column Name Data Type Constraint Description
Status_id int Primary Key,Not Null
It define status id
Bill_id int Not null It define bill id
Status nvarchar(50) Not null It define status
![Page 11: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/11.jpg)
FORM….
Login Form:
![Page 12: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/12.jpg)
Add User Form……
![Page 13: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/13.jpg)
Employee Form…..
![Page 14: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/14.jpg)
Party Form….
![Page 15: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/15.jpg)
Product Form….
![Page 16: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/16.jpg)
Bill Form….
![Page 17: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/17.jpg)
Call Status Form….
![Page 18: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/18.jpg)
Service Form….
![Page 19: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/19.jpg)
Status Form….
![Page 20: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/20.jpg)
Class Diagram…..
![Page 21: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/21.jpg)
ER Diagram…..
![Page 22: THE SERVICE MANAGER Prepared By : Dilip Sheladiya(08it051) : Ramesh Bamrotiya(09it043) : Jagdish Rathod(09it051) Guided By : Prof. Chintan Sidhapara. Group](https://reader035.vdocuments.us/reader035/viewer/2022081603/56649f475503460f94c693ec/html5/thumbnails/22.jpg)
THANK YOU…….