LocationID | Name |
---|---|
1 | University's Main Library |
2 | City Library |
PositionID | PositionName |
---|---|
1 | Head Librarian |
2 | Assistant Librarian |
EmployeeID | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | 123-456-7890 |
2 | Jane | Smith | jane.smith@example.com | 098-765-4321 |
ApplicationID | PositionID | EmployeeID | DateApplied |
---|---|---|---|
(→ Positions.PositionID) | (→ Employees.EmployeeID) | ||
1 | 1 | 1 | 2024-03-13 19:42:26 |
2 | 2 | 2 | 2024-03-13 19:42:26 |
LibraryID | LocationID | Description |
---|---|---|
(→ Locations.LocationID) | ||
1 | 1 | A large library with a vast collection of books. |
2 | 2 | A smaller library with a focused collection of local history. |
ArchivistID | EmployeeID | LibraryID | StartDate | EndDate |
---|---|---|---|---|
(→ Employees.EmployeeID) | (→ Libraries.LibraryID) | |||
1 | 1 | 1 | 2021-01-01 | 2021-12-31 |
2 | 2 | 2 | 2021-01-01 | 2021-12-31 |
LibrarianID | EmployeeID | LibraryID | StartDate | EndDate |
---|---|---|---|---|
(→ Employees.EmployeeID) | (→ Libraries.LibraryID) | |||
1 | 1 | 1 | 2021-01-01 | 2021-12-31 |
2 | 2 | 2 | 2021-01-01 | 2021-12-31 |