O'Reilly logo

Enterprise Application Development with Ext JS and Spring by Gerald Gierer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required