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 ...
Get Enterprise Application Development with Ext JS and Spring now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
