Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Location
    uk
    Posts
    4

    Red face 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

  2. #2
    Join Date
    Aug 2003
    Location
    Massachusetts, USA
    Posts
    106

    Re: help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    For future viewing of this post:

    A change regarding employees. Need an employee table, an association table between printing job and employee. Include column in this association table of employee role (distinguish print manager from other employees responsibilities).


    Originally posted by FUNMIE
    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

  3. #3
    Join Date
    Nov 2005
    Posts
    5

    Talking

    i have 2 question on this one

    what are the tables ??

    and how can i make the relation between the tables

    can anyone tell me!!!!

  4. #4
    Join Date
    Oct 2005
    Posts
    178
    Hi roor83,

    Create 4 tables

    1. tblJobRequests
    add fields.. 1.1 - JobID
    1.2 - PublisherName
    1.3 - JobDescription
    1.4 - PrintJobManager

    2. tblPurchaseOrders
    add fields.. 2.1 - JobID
    2.2 - PONumber

    3. tblMaterialsUsed
    add fields.. 3.1 - JobID
    3.2 - MaterialName
    3.3 - QuantityUsed

    4. tblJobMembers
    add fields.. 4.1 - JobID
    4.2 - EmployeeName

    Used JobID as key field and link it from JobRequest table to other tables.

    If you decide to have another table for employees, then
    add table tblEmployees
    add fields 1 - EmployeeID
    2 - EMployeeName
    but then you need to change the field content in PrintJobManager as PrintJobManagerID ( which is link to field EMployeeID in tblEmployees)
    same token in EmployeeName under tblJobMembers, change the field name to EmployeeNameID and link it to EmployeeID in tblEmployees.

    To make it more realistic add another table for Publishers information like tblPublishers and add fields such as PublisherID, Name, Address phone, and etc... then in tblJobRequests change the field to PublisherNameID which you would link to PublisherID.

    Go for it..make the tables and draw the links. Good to learn by hands on experience..
    Last edited by fredservillon; 11-25-05 at 22:47.

  5. #5
    Join Date
    Nov 2005
    Posts
    5
    thanx alot fredservillon,,,,

    could any one draw the ERD for this problem plz

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Quote Originally Posted by r00r83
    thanx alot fredservillon,,,,

    could any one draw the ERD for this problem plz
    I'm pretty sure you can do your own homework given freds' post...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Nov 2005
    Posts
    5
    i made this ERD

    but i think there are some problem can any one help me to correct it
    Attached Thumbnails Attached Thumbnails PUBLISHERPIC.jpg  

Posting Permissions

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