Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Create a new schema (user) with name and password of your choosing. (5 points) 2. At least four (4) tables must be created
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
1 Create a new schema with name and password sql CREATE USER myuser IDENTIFIED BY mypassword 2 Creat...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started