logo

Guides. TOUR PK. OUTING TourID. StartingDate. has. Tour

   

Added on  2022-08-08

1 Pages74 Words1 Views
EMPLOYEE
PK EmployeeNumber
FirstName
LastName
Contactno
GUIDE
PK
FK EmployeeNumber
FirstName
LastName
DateofBirth
HireDate
FK KinID
IS
a
SUPERVISOR
PK
FK EmployeeNumber
FullName
Contactno
NEWGUIDE
PK
FK EmployeeNumber
FullName
Contactno
Can
be
Act
TOUR
PK TourID
TourName
Totalcost
duration
HireDate
Location
FK EmployeeNumber
Guides
KIN
PK KinID
FullName
Contactno
has
CUSTOMER
PK CustomerID
FullName
Contactno
Address
Age
CUSTOMER_TOUR
PK
FK CustomerID
PK
FK TourID
OUTING
StartingDate
EndDate
FK TourID
FK EmployeeNumber
has
is
assigned
Guides. TOUR PK. OUTING TourID. StartingDate. has. Tour_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Management System
|15
|2546
|89

Database Management System
|17
|1391
|112

Entity Relationship Diagram docx
|14
|2468
|15

Analysis & Database Development
|8
|256
|20