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)
3. Printing Job
4. Print Manager
NB: Pls could you fragmentate one of the tables you discover vertically.
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..