To create the DVDLibrary database (dvdlibrary) and populate the table with data in NetBeans: 1. In the Service tab, expand Databases, then right-click on Java DB and select Create Database. 2. Enter the following information in the Create Java DB Database dialog: * Database Name: dvdlibrary * User Name: oracle * Password: oracle 3. Click Ok 4. Right-click on the new connection: jdbc:derby://localhost:1527/dvdlibrary and select Connect. 5. Right-click on the connection again and select Execute Command - the editor will open a pane named SQL Command 1. 6. Copy the dvdlibrary.sql file contents to the SQL Command 1 pane. 7. Click the Run SQL button at the top of the pane (the cyclinder with the green triangle), or press CTRL-Shift-E. The database schema for dvdlibrary has been created and populated with data.