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

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).

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!!!!

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..

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...

i made this ERD

but i think there are some problem can any one help me to correct it