Database Answers Header Kyomizu Dera, Japan
FACTS for the Data Model for a Mail System
Home Ask a Question Careers Data Models FAQs SQL Scripts Search Site Map  

Back to the Conceptual Data Model.
Original Requirements from the User :-

A database for a mail system ...
It contains a set of tables :-
1) branches(branch no, branch name .................)
2) exported letters(letter no, receiver branch no,sender, sender address, receiver, receiver addres, date,......................)
3) imported letters(letter no, receiver branch no, date)

I need to know if the foreign key here from branch letters or exported letters
that the main table in letters is exported letter but when letters imported its data
are taken from exported letters table, 
  • Things of Interest in the Scope of the Data Mode :-
    1. Branches
    2. Letters.
    3. Receivers.
    4. Senders.
    • What are the relationships between these Things of Interest :-
      1. Each LETTER is Sent or Received by a BRANCH.
    • What are the characteristics of these Things of Interest :-
      1. Every LETTER has a Letter Number, a Receiver Branch number and a Date.
      2. In addition, every EXPORTED LETTER has a RECEIVER, RECEIVER ADDRESS, SENDER, SENDER ADDRESS,
      3. Each RECEIVER has a Name and Address.
      4. Each SENDER has a Name and Address.

    Barry Williams
    Principal Consultant
    Database Answers


    [ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Search & Site Map ]

    © IceBreaker WebDesigns 2001