|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Entity Diagram Help - Crowfoot model
i have created the tables..
Customer ------------- Customer ID (Unique) Customer Name Customer Contact details Tours ------- Tour name Tour Description Date Of Departure Date Of arrival No. of Adults No. of Children Agency ---------- Agency Code Agency Name Agency Address Agency Contact Agency manager Payment (Booking) -------------------- Receipt number Date Of payment Amount of payment Overstay Hotel ------- Hotel name Hotel Address Hotel contact(Fax) City these are the tables... now agency will contact tours... one customer can have many tours.... should create a Entity Relationship Diagram (Crow Foot Model) and should indicate primary and foreign key.... then should identify the relations as well...(one to one, one to many, many to many) plz help...thank u very much... |
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Entity Diagram Help - Crowfoot model |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|