1. Create a new schema (user) with name and password of your choosing. (5 points) 2....

Transcribed Image Text:

1. Create a new schema (user) with name and password of your choosing. (5 points) 2. At least four (4) tables must be created in the database with the minimum of four (4) columns in each table. Overall minimum of sixteen (16) columns must be created. Apply appropriate column datatypes, constraints (e.g., NOT NULL, CHECK), primary keys, and foreign keys. (25 points) 3. Insert (populate) data into the tables. Minimum of five (5) records for each table should be provided. (20 points) 4. Create two (2) roles (e.g., user, manager, developer, etc.). Assign appropriate privileges for each role. One of the roles should be able to INSERT, UPDATE, and DELETE data in all tables. Then, create two (2) user for each role. (10 points) 5. Create two (2) queries that utilize JOINS and GROUP Functions. Your queries should return results that are meaningful for the company. (10 points) 6. Create two (2) stored procedures that involve INSERT, UPDATE, or DELETE data in the database. (10 points) 7. Create two (2) stored functions that return calculation values. You should create functions that are essential and useful for the company. (10 points) 8. Create PL/SQL block that drops tables, users, roles, stored procedures, and stored functions. Add these blocks to proper location in your script. (10 points) 1. Create a new schema (user) with name and password of your choosing. (5 points) 2. At least four (4) tables must be created in the database with the minimum of four (4) columns in each table. Overall minimum of sixteen (16) columns must be created. Apply appropriate column datatypes, constraints (e.g., NOT NULL, CHECK), primary keys, and foreign keys. (25 points) 3. Insert (populate) data into the tables. Minimum of five (5) records for each table should be provided. (20 points) 4. Create two (2) roles (e.g., user, manager, developer, etc.). Assign appropriate privileges for each role. One of the roles should be able to INSERT, UPDATE, and DELETE data in all tables. Then, create two (2) user for each role. (10 points) 5. Create two (2) queries that utilize JOINS and GROUP Functions. Your queries should return results that are meaningful for the company. (10 points) 6. Create two (2) stored procedures that involve INSERT, UPDATE, or DELETE data in the database. (10 points) 7. Create two (2) stored functions that return calculation values. You should create functions that are essential and useful for the company. (10 points) 8. Create PL/SQL block that drops tables, users, roles, stored procedures, and stored functions. Add these blocks to proper location in your script. (10 points)

Answer rating: 100% (QA)

1 Create a new schema with name and password sql CREATE USER myuser IDENTIFIED BY mypassword 2 Creat... View the full answer