Results 1 to 15 of 15
  1. #1
    Join Date
    Nov 2007
    Posts
    3

    Unanswered: Database design Oracle

    Hi there, I'm new here.

    I'm going to make a relational database for a business. I have made an ERD and defined the tables.

    is it a good idea to make the database in MS ACCESS and do the relationships to see if they all work and "seem" OK??

    and what goes into a simple data dictionary? at the initial design stage?

    cheers..

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I'm just curious.
    Why are you posting about ACCESS in an Oracle forum?
    Is the database designed to Third Normal Form?
    Last edited by anacedent; 11-19-07 at 18:04.
    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
    Nov 2007
    Posts
    3
    because the database has to be made in Oracle. the tables will be in 3rd NF soon.

    its all so confusing. i always feel un-certain all the time.

    ACCESS provides a GUI so its easier to see how the data is going to be seen with the relationships

  4. #4
    Join Date
    Mar 2007
    Posts
    623
    Hi,
    I do not know Access at all, so I do not have any idea, how the "GUI" should look like.
    If you just want to see all objects in database, install eg. SQL Developer.
    For data design, you may try Oracle Designer.

  5. #5
    Join Date
    Nov 2007
    Location
    Switzerland
    Posts
    27

    why access ?

    My 5 cents: Don't even think about putting things into MS Access. Go and do it in Oracle right away. I use PL/SQL Developer for ERD's.

  6. #6
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    In addition to Oracle Developer, you may wish to consider ErWin (I think that is what it's called). It doesn't have the same number of features as Oracle Developer, but it can be suitable if you want to quickly represent a database schema graphically.

    Regards,
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  7. #7
    Join Date
    Nov 2007
    Location
    Switzerland
    Posts
    27

    the price will be the key ... once again ..

    so basically it comes all down to the price ..... Erwin is nice but incredibly expensive. Going with PL/SQL Developer will, beside ERD functionality, also give you a big hand full of other nice features. Money talks .....

  8. #8
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    It appears that I had the wrong idea about the price of ErWin, as I thought it was much cheaper than Oracle Developer. Noting my mistake, I would agree prsahe and recommend Oracle Developer.
    Last edited by r123456; 11-20-07 at 14:14.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  9. #9
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Especially since Oracle Deeveloper is free. hard to beat.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  10. #10
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by beilstwh
    Especially since Oracle Deeveloper is free. hard to beat.
    Do you have a download link? I know SQL Developer, JDeveloper but never have heard of a free Oracle Developer

  11. #11
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Sql developer is the oracle tool that will allow you to maintain the database, build tables and develop queries. All in all a very nice product.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  12. #12
    Join Date
    Nov 2007
    Location
    Switzerland
    Posts
    27
    The link to download SQL Develoer: http://www.oracle.com/technology/sof...sql/index.html

    A product which is worth to look at is PL/SQL Developer:
    http://www.allroundautomations.com/

    You pay 180 USD which is actually very cheap for what it offers.

    Rgds: Peter

  13. #13
    Join Date
    Nov 2007
    Location
    Switzerland
    Posts
    27
    The link to download SQL Develoer: http://www.oracle.com/technology/sof...sql/index.html

    A product which is worth to look at is PL/SQL Developer:
    http://www.allroundautomations.com/

    You pay 180 USD which is actually very cheap for what it offers.

    Rgds: Peter

  14. #14
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    OK, so there is no such thing as "Oracle Developer".
    I do know SQL Developer

    Cheers

  15. #15
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Yes, there is a product called oracle developer. It is a product that contains Oracle forms and Oracle reports and they are run using an oracle application server and cost about 5000 US.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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