Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2002
    Location
    Southern NH
    Posts
    3

    Talking Newbie needs help on database design

    Hi,

    I am a database newbie that is taking a database design course (because I thought it would help with my new job configuring Oracle HRMS 11i). I am not having any problems at work, just with this class!

    I have a project to work on, but I am totally lost in what to do. Here is what I need to do, can anyone provide pointers, examples, anything would help!

    Problem Definition - I have picked a simple database of the books I own so that I can tell subject, what I have read and when, etc...
    Conceptual Design
    Conceptual Model Verification
    Logical Design
    Physical Design
    SQL Table, Index and Key definitions
    Access Implementation

    Thanks to everyone for your help!
    Joann

  2. #2
    Join Date
    Dec 2001
    Location
    Delhi/Bangalore, India
    Posts
    74
    Did you forget to post the problem definition or what??

  3. #3
    Join Date
    Mar 2002
    Location
    Southern NH
    Posts
    3

    reply

    The problem was that I needed a database to organize all of my books, so I can see what I have (by subject).

  4. #4
    Join Date
    Dec 2001
    Location
    Delhi/Bangalore, India
    Posts
    74
    I guess you will have to follow these steps:

    1. Identify what info you need in the database (fields) and how you will be using them (which of them you will need always together...like book serial # and title,etc.)

    2. Form a design of the database that suits your requirements. Identify the keys/constraints you will need.

    3. To really optimize it, apply the Normalization rules and Normalize it upto 3NF ( or really 2NF if you don't care much)

    4. Build the DB using SQL and use a DBMS to manage it.

    5. Optionally, build a front-end application to interact with the DB.


    Now tell me, where are you stuck ??

  5. #5
    Join Date
    Mar 2002
    Location
    Southern NH
    Posts
    3

    Exclamation Yikes! Simple please!

    Manish,

    Thanks for the reply, but you are going way over my head! It is really the conceptual design and verification that I am lost in. I know SQL and can create the tables, etc... It's just the E-R diagrams and relationship issues that I don't understand. This is what I need to do:

    conceptual design:
    1. A high-level entity relationship diagram identifying the entities and relationships. Include as much narrative as is necessary to explain the document.

    2. Precise entity and relationship definitions.

    3. Precise definition of all business rules. This can be in narrative form, though applying them to the appropriate subset of the E-R diagram can be very helpful to understanding the business process.

    4. Precise definition of all attributes you can identify. Do not put these in an extended E-R diagram, Rather, repeat the high level definition of each entity and identify every attribute associated with it. Then, to the degree you can at this point in the process, identify the domain constraints.

    Verification:
    1. Identifying the central entity

    2. Identifying each module and its components

    3. Identifying each module transaction requirements

    Thanks Again!
    Joann

Posting Permissions

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