What would be this FortuneTelling Center ER Diagram using Cr
What would be this Fortune-Telling Center ER Diagram using Crow´s Foot Notation?
Madame Z runs a fortune-telling business, employing a number of fortune tellers. The business has many
customers, some of whom come back on a regular basis. Before a visit customers can brows the list of fortunetellers by name or method used (tarot, astrology, etc.) and can schedule a session with a specific fortune-teller.
Repeated customers are usually assigned to one person as their “primary” fortune-teller. When customers come
in for a session, a number of predictions can be made, which are saved for future reference. (This ensures that
this information is available when making predictions in later sessions.) The customer is billed for the services
provided during the session, which can include multiple billable items. They can either receive an invoice after
the completion of the session to be paid immediately, or have an invoice sent to them by mail at the end of the
month, in which case the invoice would include all services for that month. Customers who receive an invoice
by mail can pay it by mailing a check. The payments are recorded when they are received.
Solution
the start of crow’s foot notation dates lower back to an article by Gordon Everest (1976, 5th Computing convention, IEEE). The notation naming convention turned into converting; in fact, it have been evolving over several years. when asked by using me about the difficulty, Mr. Everest said:
I referred to as it the “inverted arrow.” on the time to distinguish [it] from Bachman’s notation. I prefered it to the arrow as it did no longer imply directionality or a bodily get right of entry to direction, and it changed into visually intuitive, showing manyness. Others then started referring to it as bird toes (e.g., Carlis textbook ¹). I now decide upon to call it a FORK, which is short and to the point, and doesn’t require the possessive crow’s or the longer chicken. In my unique paper, the focal point turned into on “simple data systems explained with a common example” ² (the title, which later became chapter 4 in my McGraw Hill text, Database management, 1986). the usage of the notation become incidental though cautiously chosen. I just like the fork when you consider that it can without problems be represented in a popular person set as in:
