Answered step by step
Verified Expert Solution
Link Copied!

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

image

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

11th edition

9781305323230, 1285196147, 1305323238, 978-1285196145

More Books

Students also viewed these Literature questions