Not understand in database concepts

egovernment
egovernment used Ask the Experts™
on

The company is organized into DEPARTMENTs. Each department has a name, number and an employee who manages the department. We keep track of the start date of the department manager. A department may have several locations.

What meaning the statement
We keep track of the start date of the department manager
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Neil RussellTechnical Development Lead

Commented:
It means that you record and remember the start date of each departments manager :D
You store the date the manager begins managing the department.
EirmanChief Operations Manager

Commented:
If the job is managing the department ....
The start date is the date the manager started the job
Commented:
To realise this you'll need a Department table, an Employee table and a relation table (DepartmentManager table) holding the DepartmentNumber, EmployeeNumber and StartDate. Sometimes (when a department can have no manager for a while) you can add the EndDate.
David VanZandtOracle Database Administrator III

Commented:
A range of dates (start & stop) are commonly used for a broad set of business conditions, such as when a subscription is in effect.  For a person, I might want to record which leadership positions were held, and for how long.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial