This project requires you to use all previous knowledge to create database objects and populate data into tables. It will prepare you for database objects to practice various database security techniques in this course.

You may copy the script from the downloaded files from the course web site. You need to create one (the only one) SQL script that will complete the following tasks:

1. Connect to SYSTEM user. (5 points) When you need to connect to SYSTEM users, please use a syntax so that it will ask the user to type the password. A typical example will be: "connect system;"
2. Change the password of the user "DBSEC" to "secc$1new." Please note that the period "." is not a part of the password specification. (10 points)
3. Grant the DBSEC user with "CREATE SESSION" and "CREATE TABLE" privileges. (5 points)
4. Connect to DBSEC with the new password. (5 points)
5. Create all 17 tables (SUPPLIER, SHIPMENT_METHOD, DEPARTMENT, JOB, EMPLOYEE, SALES_COMMISSION , PROMOTION, CATEGORY, PRODUCT, PRODUCT_SUPPLIER, PRODUCT_PRICE, PRODUCT_INVENTORY, PAYMENT_METHOD, CUSTOMER, ORDER_TAB, ORDER_LINE, EMPLOYEE_RANK) under DBSEC schema. (40 points)
6. Populate SUPPLIER table with the data. (35 points)

Tips:

1. You may copy from files provided in the course download into Notepad or Wordpad.
2. Please note the changes in table names from the scripts provided by this course. It is required to follow the exactly spelling from on this page.
3. To be able to repeatedly test your script, you may add "DROP TABLE table-name;" at the beginning of your file to drop all tables.
4. Throughout the semester, exact spelling is required to conform to the specifications.

One and only one SQL script file will be required and submitted through WebCT. Please note that 20 points will be taken off if the script file is not executable under SQL Plus, or is not in one file. Thus, please test it so that you can perform all above tasks in one file.

Convention for File Name: Please name your file as firstname_lastname_project4.sql, where firstname and lastname are your first and last name, respectively, and "_" is underscore. The file naming convention will be enforced throughout this semester. Five (5) points will be taken off if the file is not named according to the convention.