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

    Wink Entity Relationship Diagram design need help

    Hi.
    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
    https://lh3.googleusercontent.com/gx...w=w692-h617-no

    Click image for larger version. 

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

  2. #2
    Join Date
    Feb 2007
    Posts
    24
    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
    Posts
    89
    Hi

    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
  •