1. One of the methods usually used by Database Administrators to improve database performance is to use PL/SQL code Blocks, stored procedures, and functions instead of using usual actual SQL queries. a. Propose a scenario of a database problem related to IR 4.0 with at least THREE (3) tables that include master-detailed relationships. Write a complete PL/SQL program that enables the user to insert new data, update and delete existing data as well as retrieve data from the database instead of using actual queries. Use the concept of divide and conquer when developing your code and provide a separate procedure for each of the required operations. Test the PL/SQL program created by executing different scenarios that covers all the required operations. Make use of substitution variables to get the input from the user. Attach screen snapshot for the output [40 marks] b. Improve the performance of the database by writing a PL/SQL trigger to maintain the referential integrity constraints between the Master table and Detailed tables. For any record that is updated or deleted from the Master table, the related record(s) in the Detailed tables should be updated or deleted accordingly. Test the trigger by executing different update and delete queries on the Master table, that affect the Detailed table. Provide screen snapshots for the output [20 marks] 2. Database security is one of the critical tasks of in database administration. A database administrator is the person in charge of implementing the authentication as well as the authorization of the database. a. Propose a scenario of a database administrator who is responsible of a small company consisting of FIVE (5) employees. Using oracle SQL commands show how to authenticate all the users as well as grant them required authorizations to enter and use the database. Provide screenshots for your answer. b. Propose a scenario to differentiate between admin privileges as well as object privileges. In your scenario, you need to show how both admin and objects privileges that are assigned through an intermediary affect the grantee when the intermediary is dropped from the database. Use Oracle commands to implement the scenario and provide a justification for the output of your commands.
- Select TWO of the prompts below to respond to in this week’s discussion. 1. Dylan and Regan are attending their first prenatal appointment. As a
- The Final Project is a stepwise process, and its goal is to leave you well-prepared by the end of this course to execute on your qualitative rese
- If you are collecting phone or face-to-face interviews, the audio recorder is the most important tool for ensuring accuracy in capturing the inte
- How will you decide on an appropriate theoretical framework for your study? What questions might you ask to ensure the best foundation for answer
- Identify the theoretical framework in each article in your annotated bibliography. If not noted there, return to the article and see if a theory
- A physician on staff tells you about a study that they are doing on their patients. They hope to have the study published and to receive a grant
- Discuss a time when you may have had difficulty discussing an issue related to oppression, privilege, or intersectionality due to struggles with
- The SWOT analysis is an excellent tool to help a nursing leader assess the capacity for change within a unit. Think of yourself as a new leader o
- Screening is the administration of measures or tests to distinguish individuals who may have a condition from those who probably do not have it.
- Explain Florida state laws for involuntary psychiatric holds for child and adult psychiatric emergencies. Include who can hold a patient and for