Results 1 to 9 of 9
  1. #1
    Join Date
    May 2011
    Posts
    5

    Unanswered: Could you explain how to create the ERD Diagram

    Hi everyone,
    I have a very little experience in oracle and on databases, i would like to ask if any of you would give me some help in order to desing the ERD Diagram i would be very greatful for what ever help given. Could you please explain to me, how many entities i should have and where all these attributes given in the scenario should go to?

    Find the scenario below:

    Details that need to be recorded includes the agents-name, cheque-number, payment date, base salary, total-monthly sales and commission paid. Your tables should contain the data which would allow commission calculations to be performed. (Commission is paid only when settlement occurs; which is when legal contracts are exchanged).


    Other information which needs to be considered for storage includes:

    Agents-work-phone, agents-mobile-phone, client-id, client-first-name, client-surname, client-address, client-phone, client-mobile-phone, property-location, property-size, house-description, number-rooms, year-house-built, listing-date (of the property for sale), asking-price, sale-date, buyer, agreed-price, settlement-date and deposit-paid.

    PR4U receive calls from sellers to find out how much their property can be valued at. Each call is received by receptionist and entered onto the database and a schedule to visit properties to estimate the value of the property would be generated by the system. This can be seen by each agent.


    Thank you very much for any help given.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You problem really has nothing specific to Oracle.

    Design the application to Third Normal Form (3NF)
    Third normal form - Wikipedia, the free encyclopedia
    but start out at First Normal Form (1NF) before progressing to Second NF (2NF) & onto 3NF
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2011
    Posts
    5
    Quote Originally Posted by anacedent View Post
    You problem really has nothing specific to Oracle.

    Design the application to Third Normal Form (3NF)
    Third normal form - Wikipedia, the free encyclopedia
    but start out at First Normal Form (1NF) before progressing to Second NF (2NF) & onto 3NF

    Thanks for ur attempt to help me, but this is not what i am looking for, i wanted to know how to desing this kind of database, how many tables i should have and where all mentioned attributes above should go to.

  4. #4
    Join Date
    May 2011
    Posts
    5
    Any help from you people please????

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You can start here, for example: DATABASE DEBUNKINGS - BOOKS

    You don't seriously expect someone to teach you a university course in a few words, do you?

  6. #6
    Join Date
    May 2011
    Posts
    5
    Quote Originally Posted by n_i View Post
    You can start here, for example: DATABASE DEBUNKINGS - BOOKS

    You don't seriously expect someone to teach you a university course in a few words, do you?

    Thank you for ur effort to help me.
    I am not expecting to teach me university course, all what i asked is how to design this small database in short point, and give me some hints on this.

    Anyway thank you for you time



    Any help welcomed form anyone ...

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >give me some hints on this.
    We have but you seem clue resistant & borderline clue repellent.
    It appears you desire to be spoonfed a design solution. Good Luck with that!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  8. #8
    Join Date
    May 2011
    Posts
    5
    Quote Originally Posted by anacedent View Post
    >give me some hints on this.
    We have but you seem clue resistant & borderline clue repellent.
    It appears you desire to be spoonfed a design solution. Good Luck with that!

    You are not supposed to help me, only if you express desire to.

    Thank you for you time mate anyway.

  9. #9
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    db-, you've been given a lot of help, if only you'd use it. Anacedent has told you exactly what you need to know in his first post i.e. 1st Normal Form, 2nd Normal Form, & 3rd Normal Form. If you apply the normalisation technique to your scenario you will have your answer.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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