Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Red face Unanswered: help!!!!!!!!!!!!!!!

    Note: attached scenario

    Pls can any one help me generate an ER diagram and relevant tables from the attached scenario. I am relatively new to Database.

    However, i discovered some entities but i am not sure if they are accurate.

    1. Book Publishers(pub_num,name,address etc)
    2. Order
    3. Printing Job
    4. Print Manager

    NB: Pls could you fragmentate one of the tables you discover vertically.

    Plsssssssssss am on bended kness
    Attached Files Attached Files
    Last edited by FUNMIE; 02-16-04 at 07:30.

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    we won't do your homework assignment for you

    if you make a good effort, and show what you have done yourself, we might critique it and offer suggestions or corrections | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2004
    Binary Universe
    If you're even having a hard time defining the structure of your database how are you gonna develop it?!

    Here's some thoughts, though:

    Usually the data structure requirements for a database are determined through a meeting with the end user. In most cases they know their business cycle and have a pretty good idea about the data that they want to keep in a database.

    If they don't then examine the current business practices:
    Current paper trail will give you a good idea about purchase orders, job/print requests, personnel handling, invoicing etc... From there you can derive a set of tables and field specs for those tables in each area.

    Once tables structure is semi clear you can start working on the user interfaces (forms, reports etc…) to collect and manipulate data the end user wants in the db..

    I wouldn't hold my hopes high that there's someone on this forum working in book printing business and knows the specifics of it.
    Last edited by The Byte; 02-16-04 at 08:21.
    I won't byte... hard!

Posting Permissions

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