Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2016

    Wink Entity Relationship Diagram design need help

    I am working as a coder but recently my boss has asked me to design a ER diagram for the Tourist Service System project. I guess I am having a promotion if I do it well. I need some help because I am not sure if I design it right.

    This is the ERD between employee and customer. The customer after booking a tour will sign contract with employee. If you need any more information please ask. I really need help on this.

    I have attached the ERD within this topic and it is also in this link

    Click image for larger version. 

Name:	erd.jpg 
Views:	9 
Size:	71.4 KB 
ID:	16911

  2. #2
    Join Date
    Feb 2007
    I would use e ternary relationship for Sign Contract with Employee -Tour- Customer .
    In this way you can keep track of which tour that customer signed with an employee.

  3. #3
    Join Date
    May 2016

    For modeling correctly a db,
    1. Apply at least the 3 first Normal forms (NF)
    2. Use a dedicated tool like
      • Power*AMC (excellent but expensive)
      • JMERISE, excellent freeware here

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts