Chapter 2. The Task Time Tracker Database
This chapter defines the Task Time Tracker (3T) database design and configures NetBeans as a client of MySQL server.
The 3T application will be used to keep track of the time spent on different tasks for different company projects. The main entities are:
- Company: This is the entity that owns zero or more projects. A company is independent and can exist in its own right (it has no foreign keys).
- Project: This represents a grouping of tasks. Each project belongs to exactly one company and may contain zero or more tasks.
- Tasks: These represent activities that may be undertaken for a project. A task belongs to exactly one project.
- Users: They are participants who undertake tasks. Users can assign time spent to ...