The Database from 20,000 Feet
With the entire schema in place, you can use a tool such as Together to get an overall view of our database with an ERD. Together is a commercially available integrated development tool (IDE) that can also be used to model and create Java and EJB architectures. Although I'm from the older school that does everything using the emacs editor, a lot of developers swear by the visual design approach that tools such as Together employ.
You can immediately see that the data falls into three separate islands: the customer group, the product group, and the order group. As you go along, you're certain to add more to this schema, especially with regard to cart persistence using cookies, but this gives you enough to get going. ...
Get MySQL™ and JSP™ Web Applications: Data-Driven Programming Using Tomcat and MySQL 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.
