tailieunhanh - SQL Workshop

This workshop covers: Creating tables and sequences Modifying data in the tables Modifying table definitions Creating views Writing scripts containing SQL and iSQL*Plus commands Generating a simple report | SQL Workshop Workshop Overview This workshop covers: Creating tables and sequences Modifying data in the tables Modifying table definitions Creating views Writing scripts containing SQL and iSQL*Plus commands Generating a simple report Workshop Overview In this workshop you build a set of database tables for a video application. After you create the tables, you insert, update, and delete records in a video store database and generate a report. The database contains only the essential tables. Note: If you want to build the tables, you can execute the commands in the script in iSQL*Plus. If you want to drop the tables, you can execute the commands in script in iSQL*Plus. Then you can execute the commands in script in iSQL*Plus to create and populate the tables. If you use the script to build and populate the tables, start with step 6b. Video Application Entity Relationship Diagram TITLE #* id * title * description o rating o category o release date TITLE_COPY #* id * status RENTAL #* book date o act ret date o exp ret date MEMBER #* id * last name o first name o address o city o phone * join date RESERVATION #* res date for the subject of available as a copy the subject of made against responsible for created for responsible for set up for Practice 14 1. Create the tables based on the following table instance charts. Choose the appropriate data types and be sure to add integrity constraints. a. Table name: MEMBER b. Table name: TITLE Practice 14 (continued) c. Table name: TITLE_COPY d. Table name: RENTAL Practice 14 (continued) e. Table name: RESERVATION 2. Verify that the tables and constraints were created properly by checking the data dictionary. Practice 14 (continued) 3. Create sequences to uniquely identify each row in the MEMBER table and the TITLE table. a. Member number for the MEMBER table: Start with 101; do not allow caching of the values. Name the sequence MEMBER_ID_SEQ. b. Title number for the TITLE | SQL Workshop Workshop Overview This workshop covers: Creating tables and sequences Modifying data in the tables Modifying table definitions Creating views Writing scripts containing SQL and iSQL*Plus commands Generating a simple report Workshop Overview In this workshop you build a set of database tables for a video application. After you create the tables, you insert, update, and delete records in a video store database and generate a report. The database contains only the essential tables. Note: If you want to build the tables, you can execute the commands in the script in iSQL*Plus. If you want to drop the tables, you can execute the commands in script in iSQL*Plus. Then you can execute the commands in script in iSQL*Plus to create and populate the tables. If you use the script to build and populate the tables, start with step 6b. Video Application Entity Relationship Diagram TITLE #* id * title * description o rating o category o