Not understand in database concepts

egovernment used Ask the Experts™

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

Do more with

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

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

If the job is managing the department ....
The start date is the date the manager started the job
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

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