336 Part (Apache web server for windows) II: Developing Intranet Solutions . Sharing
336 Part II: Developing Intranet Solutions . Sharing and assigning events among users: Users can create events for themselves or assign events to others or even share events with multiple users. . Automatic reminders: Users can choose to be reminded about an event when they log in to the intranet on the day of the event. Let s look at the prerequisites of the calendar system. Understanding Prerequisites The event calendar builds on the intranet classes discussed in the Chapters 4 through 7. For example, it uses the Message class (discussed in Chapter 7) to announce event reminders. That class enables the application to create and delete messages. The intranet calendar applications that you ll develop require the central login/logout, user management, and intranet home applications discussed in those earlier chapters. Now let s look at the database design and implementation needed for creating the intranet calendar manager. Designing the Database Figure 10-1 shows the database diagram for the intranet calendar manager. Here the CALENDAR_EVENT table holds the event data, CALENDAR_EVENT_VIEWER table holds the viewer list for an event in the CALENDAR_EVENT table. The CALENDAR_REPETITIVE_EVENTS table stores information about how an event is repeated. Figure 10-1: Intranet calendar manager database diagram.