XML and SQL: Developing Web Applications

Decomposing CyberCinema

Let's turn to our more complex example of the CyberCinema Web site. Let's revisit our skeletal requirements:

• Reviewers must be able to write reviews.

• Reviews must be searchable by movie.

• Reviews must be searchable by director.

• Reviews must be searchable by actor.

• Reviews must be searchable by reviewer.

• Movies must be searchable by director.

• Movies must be searchable by actor.

Now refer to the XML DTD for CyberCinema that we built in Chapter 5 (see Appendix A).

Finally, we'll bring to bear our data model diagram (see Figure 6-2).

Figure 6-2. CyberCinema data model diagram

First, we determine the tables required for our database. ...