I am new to the board. Thus I would like to start off by saying hello to everyone!!!
My assignment question is this:
A Library has one location but two separate departments. Each department has its own set of book titles. The department is as follows : Yound Adult Library and Children's Library, both located in the same building but different floors.
You are required to store information on the classification of each book for example, romance, thriller, ect. For each book, there must be a classification as well as a department assignment.
Besides the normal employee information, you are also required to keep track of the department the employee is assigned to. Please be advised that an employee can work in only one department at a time but this assignment can be changed if necessary.
I have to draw an Entity Relationship Diagram.
I have already identified some of my entities:
Employee, Department, Book
What I need to know is how to get my diagram to cater for each department having its own books and how to keep track of each employee in a department.