1. Create a new schema (user) with name and password of your choosing. (5 points) 2....
Fantastic news! We've Found the answer you've been seeking!
Question:
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)
Expert Answer:
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these literature questions
-
A regular language is a language that can be defined by a regular expression. 0 2 . 1 Complete the unshaded cells of Table 1 to show which of the statements about regular languages are true and which...
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
What are the main technical challenges faced by firms that wish to internationalise their selection and assessment approaches?
-
Refer to Yellowberry, Inc.'s, trial balance in Short Exercise 2-15. The purpose of this exercise is to help you learn how to correct three common accounting errors. Error 1. Slide. Suppose the trial...
-
Give a brief general description of a markup-programming hybrid language.
-
Many researchers are interested in the transcription of protein-encoding genes in eukaryotes. Such researchers want to study mRNA. One method that is used to isolate mRNA is column chromatography....
-
Gore Range Carpet Cleaning is a small, family-owned business operating out of Eagle-Vail, Colorado. For its services, the company has always charged a flat fee per hundred square feet of carpet...
-
1. Why have neo-classical economists generally argued that international economic relations are not zero-sum in character? What theoretical frameworks have they used to support this argument? It's...
-
#2. Find the mean, median, and mode for the following sample of scores: 3, 6, 7, 3, 9, 8, 3, 7, 5 Mean= Median= Mode= #4. Find the mean, median, and mode for the scores in the following frequency...
-
Robert Provider purchases a joint and survivor annuity providing for payments of $200 per month for his life and upon his death for his wife, Robin, for the remainder of her life. As of the annuity...
-
How does an expected insurance reimbursement for a business casualty loss affect the amount of a casualty loss deduction? Does it make a difference whether an expected insurance reimbursement for...
-
Bevis Bag Co. purchased a tract of land on August 31 of the current year, paying $225,000. Prior to the sale, the seller paid property taxes of $18,000 on the property. The taxes covered the calendar...
-
Put yourself in the position of a management trainer. You have been asked to make a short presentation to the local Business Improvement Association at its biweekly luncheon. The topic you are to...
-
Don Smith's wife died in January while still employed and, as her beneficiary, he began receiving an annuity of $147 per month. There was no investment in the contract after June 30, 2013. The...
-
Explain what happens to saving, investment, and the real interest rate in each of the following scenarios in a closed economy. Illustrate your answer using a saving-investment diagram. Label the axes...
-
The unadjusted trial balance of Secretarial Services is as follows: SECRETARIAL SERVICES Unadjusted Trial Balance as at 31 December 2017 Account Debit Credit Cash at bank Office supplies Prepaid...
-
What is the difference between UNION and UNION ALL? Write the syntax for each.
-
Given the scenario and the requirements in Problem 2, answer the following questions: a. What recommendations will you make regarding the type and characteristics of the required database system? b....
-
Write a query to produce the number of invoices and the total purchase amounts by customer, using the output shown in Figure P7.35 as your guide. CUS CODE Number of Invoices Total Customer Purchases...
-
Draw a block diagram for the feedback control of a liquid-level system, which consists of a valve with a control knob (0\%-100\%) and a liquid-level sensor. Clearly label essential components and...
-
A control system is represented using the block diagram shown in Figure 10.59. Sketch the root locus with respect to the proportional control gain K. Determine all the values of \(K\) for which the...
-
Roughly sketch the root locus with respect to \(K\) for the equation of \(1+K L(s)=0\) and the following choices for \(L(s)\). Make sure to give the asymptotes, arrival or departure angles, and...
Study smarter with the SolutionInn App