Adobe Dreamweaver CS3 Unleashed- P21: The good news is Dreamweaver provides numerous windows, panels, inspectors, and toolbars for streamlining the way you build websites. The bad news, unfortunately, is that Dreamweaver provides numerous windows, panels, inspectors, and toolbars for streamlining the way you build websites. Why so many windows, panels, and so on, Dreamweaver is unprecedented in the feature set it provides, allowing developers complete control when building websites and applications | If you look at the Vecta Corp store example again you can begin to imagine how the DBMS looks much like the filing cabinet discussed earlier. Unlike a filing cabinet however which typically contains two to four drawers a DBMS can manage hundreds possibly thousands of databases all of which are immediately at your fingertips. Later in this chapter we ll look at the various database management systems that exist on the market today for interacting with SQL Server 2005 Express Edition and MySQL including the File Manager for Access. The Database Inside your DBMS you have the potential for storing hundreds if not thousands of databases. Although for most projects you would never need more than one database you may in the future realize that your project has grown far beyond the scope of a single database that because of security or maintenance reasons you require more. Figure shows MySQL Administrator with a list of three catalogs otherwise known as databases housed within its framework. Figure . MySQL Administrator and a list of the databases it contains. View full size image Tables After a database has been created you might want to begin storing information relevant to a specific part of the store. As mentioned earlier tables are very similar to file cabinet drawers. It would be a mistake to store all the information about inventory product information customers and even transactions in one drawer instead you ll break out these categories of information and create different drawers or tables to store all this information. Figure shows the Vecta Corp store database in MySQL Administrator. By selecting the Vecta Corp store database from the view in the left column you can begin to see all the tables that reside within the store. Figure . Selecting the vectacorp database reveals all the tables associated with the project. View full size image Notice that there are more tables than just the four outlined in the beginning of the chapter. If you think in
