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