ERD Entity Relatiaon Disgram

1
ERD (Entity Relatiaon Disgram)
2
Group Members

• Waqar ul Hassan
• Asad Ali
• Rizwan Rashid
• Muhammad Ibrar
• Nasir Zaka
• Muhammad Qasim
• Muhammad Abrar hussain
• Ahmed waqas Akhtar
• MD Arifur Rahmam

3
Entities

• Employee
• Emptype
• Sal Grade
• Department
• Transport
• Trans category
• License
• Wage Rate
• Designaiton

4
Employee Attributes

• Empid (Pk)
• Fname
• Lname
• Address
• City
• State
• Telephone

5
Emp Type

• Etype(Pk)
• EmpId(Fk)
• Description

6
Sal Grade

• Grade (pk)
• Low Sal(below 17)
• High Sal(17 and above)

Trans Category

• Cat Id(pk)
• Description

7
Department

• Dept Id(PK)
• Dname

Transport

• Trans no.(PK)
• Description
• Date of Addition
• Active

8
Wage Rate

• Wage Type (pk)
• Description
• Wrate
• Wvalue

License

• License no.(pk)
• Description

9
ER-COMPANY TRANSPORT
EMPLOYEE
EMP ID FNAME LNAME ADRESS CITY PHONE
SAL GRADE
EMP TYPE
GRADE LOW.SAL HIG.SAL
E-TYPE DESCRIPTION
DEPARTMENT
DEPT ID DNAME
TRANSPORT
TRANS NO DESCRIP DATE OF ADDITION ACTIVE
TRANS CATAGORY
CAT ID DESCRIPTION
DESIGNATION
WAGE RATE
DESG ID DESIGNATION
WAGE TYPE DESCRIPTION WRATE WVALUE
LICENSE
LICENCE WAGE
LICENSE DESCRIPTION
TYPE DESCRIPTION
10
Queries

• CREATE DATABASE transport
• CREATE TABLE employee(FName char(20),LName
  char(20),Address char(50),City
  char(10),license typ (10),telephone int(10))

11
Queries

• 2. INSERT INTO employees (Lastname,Firstname,addre
  ss,city,telephone,typ) VALUES()
• 8.Select fname from customer where fname like
  arl
• 9.Select Fname from employee where Ltype
  (select licence from license where description
  Motor cycle)

12

• 10. Truncate table employe