Your submission for this assessment will be formatted as an informal written report responding to your...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your submission for this assessment will be formatted as an informal written report responding to your employer's work request(s). You are to address the following emails while referencing the client organization's Employee Database. Obtain, or create, a copy of the Employee Database, if you have previously built the Employee Database in a previous project then you may reuse said database on this individual assessment. From: Matt Kozi To: You Subject: Employee Database administration Hey, I'm not sure if anyone has briefed you on this, the department has been working towards standing-up an intranet site to allow select employees the ability to pull data from the Employee Database that is in your administrative portfolio. The project is meant to reduce the departments dependence on submitting data requests to you and the other Database Administrators, simplifying the process by allowing direct access to relevant by different groups of internal users. We just wrapped up our meeting with the web developers, and before they can implement the employee page for our intranet site, they had a few observations about our employee database that we need to implement to meet data protection regulations. From what I could gather, there are a few key elements that we need to get into place now before any more work can be done on the system, as always, we must affect as little changes to the system as possible as there are a number of systems and applications already running off of the employee database and we can't afford to take it offline right now. The first thing that the dev's requested was that we needed to establish proper schemas for the database. For the schemas, we were looking at five general groupings for the tables: Schema 1; Include any table that has general information about the employee and their role. Schema 2; Include tables that have private or personal data which would be subject to a higher degree of governmental regulations. I don't really think we should let many people have access to the data on these tables, the last thing we need is a lawsuit. Facility schema; any non-personal data that doesn't contain address information should be dumped into this schema. It doesn't matter if the tables aren't really a perfect fit with 'facility' data, this will more-or- less just be a catch all for any table we can't place inside any of the other schemas. Schema 4; Anything to do with contact information must be grouped together in a single schema. This schema will need to be restricted to only certain roles, there is no need for everyone in the organization to be able to see into this subset of data. Address schema; this one is pretty self-explanatory. You should also probably come up with clear names for the schemas for whichever ones we haven't named yet. No need to ask for approval, just call them whatever makes sense. The developers asked if you can forward the SQL commands you used to create all of the schemas and assign the tables within each of their respective schemas. If I remember anything else I'll email you and let you know, good luck with implementing all of these updates. P.S. They also mentioned something about the database having an administrator user account and all the schemas should be accessible by said user account. So, make sure that's in-place too. Matt Kozi Solutions Architect, Coffee Bean Roasters mkozi@cbr.org Your submission for this assessment will be formatted as an informal written report responding to your employer's work request(s). You are to address the following emails while referencing the client organization's Employee Database. Obtain, or create, a copy of the Employee Database, if you have previously built the Employee Database in a previous project then you may reuse said database on this individual assessment. From: Matt Kozi To: You Subject: Employee Database administration Hey, I'm not sure if anyone has briefed you on this, the department has been working towards standing-up an intranet site to allow select employees the ability to pull data from the Employee Database that is in your administrative portfolio. The project is meant to reduce the departments dependence on submitting data requests to you and the other Database Administrators, simplifying the process by allowing direct access to relevant by different groups of internal users. We just wrapped up our meeting with the web developers, and before they can implement the employee page for our intranet site, they had a few observations about our employee database that we need to implement to meet data protection regulations. From what I could gather, there are a few key elements that we need to get into place now before any more work can be done on the system, as always, we must affect as little changes to the system as possible as there are a number of systems and applications already running off of the employee database and we can't afford to take it offline right now. The first thing that the dev's requested was that we needed to establish proper schemas for the database. For the schemas, we were looking at five general groupings for the tables: Schema 1; Include any table that has general information about the employee and their role. Schema 2; Include tables that have private or personal data which would be subject to a higher degree of governmental regulations. I don't really think we should let many people have access to the data on these tables, the last thing we need is a lawsuit. Facility schema; any non-personal data that doesn't contain address information should be dumped into this schema. It doesn't matter if the tables aren't really a perfect fit with 'facility' data, this will more-or- less just be a catch all for any table we can't place inside any of the other schemas. Schema 4; Anything to do with contact information must be grouped together in a single schema. This schema will need to be restricted to only certain roles, there is no need for everyone in the organization to be able to see into this subset of data. Address schema; this one is pretty self-explanatory. You should also probably come up with clear names for the schemas for whichever ones we haven't named yet. No need to ask for approval, just call them whatever makes sense. The developers asked if you can forward the SQL commands you used to create all of the schemas and assign the tables within each of their respective schemas. If I remember anything else I'll email you and let you know, good luck with implementing all of these updates. P.S. They also mentioned something about the database having an administrator user account and all the schemas should be accessible by said user account. So, make sure that's in-place too. Matt Kozi Solutions Architect, Coffee Bean Roasters mkozi@cbr.org
Expert Answer:
Related Book For
Auditing and Assurance Services A Systematic Approach
ISBN: 978-1259162343
9th edition
Authors: William Messier, Steven Glover, Douglas Prawitt
Posted Date:
Students also viewed these databases questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
1. Contextual Application For a Specific Workplace : If your program is tailored for a specific workplace, clarify how it aligns with the unique culture, goals, and challenges of that organization....
-
(d) Consider a straight wire of length 1, and cross sectional area A, carrying a current I, in a uniform magnetic field B. The angle between the direction of current flow and the magnetic field is 0....
-
At this point, you have been introduced to various security tools (Network Discovery, Network Scanning, DLP, Firewalls, and HIDS). You are to take one of the five identified categories of tools and...
-
Given the network shown in Figure P8.39 determine the value of the capacitor C that will cause the impedance seen by the 240 V voltage source to be purely resistive. f = 60Hz. 4 12...
-
A hemispherical bowl of radius \(R\) is placed in a uniform magnetic field that has magnitude \(B_{0}\) and is in the positive \(z\) direction. The open top of the bowl is in the \(x y\) plane....
-
Using PERT, Ed Rose was able to determine that the expected project completion time for the construction of a pleasure yacht is 21 months and the project variance is 4. (a) What is the probability...
-
Total Energy (a) Conserved 12. Which one of the following is true in the case of inelastic collisions? Kinetic Energy Conserved Momentum Conserved (b) Conserved Not Conserved Conserved (c) Conserved...
-
I invested $ 100 per month except May $500 and December $300 in a XYZ Corporation Stock Stock prices Jan $21.25, Feb $ 22, March $23.75, April $23.25, May $ 22.75, June $23.25, July $ 24 August $...
-
In his treatise, Overcoming Law, the legal scholar Richard Posner spends a great deal of time exploring the relationship between economics and the law. In doing so, he focuses on the ideas of two...
-
What are the duties of an agent to the principal?
-
U.S. Electronics, a Missouri corporation with a place of business in DeKalb County, Georgia, borrowed money from a Missouri bank. The corporation gave the bank a security interest in all of its...
-
Suppose Congress decided to strip the Fed of its monetary policy independence and legislate interest rate changes. How would you expect the policy choices to change? Which arrangement would most...
-
What are the functions of the Taft-Hartley Act?
-
a) Thevenize the circuit driving terminals A and B in Fig. Show the Thevenin equivalent circuit and calculate the values for IL and V. R, = 10 0 A R= 150 R= 15 0 V, = 100 V R= 68 N B R= 10 0
-
What is the expected payoff of an investment that yields $5,000 with a probability of 0.15 and $500 with a probability of 0.85? Select one: O a. $325 O b. $5,500 O c. $2,750 O d. $1,175
-
When an entity does not adequately segregate duties, the possibility of cash being stolen before it is recorded is increased. If the auditor suspects that this type of defalcation is possible, what...
-
Discuss the two control environment factors that an auditor should consider when examining the human resource management process.
-
Why is PrimePlus potentially a major service for CPA firms? What types of PrimePlus services can a practitioner offer?
-
Lennon Industries had the following transactions. 1. Borrowed 5,000 from the bank by signing a note. 2. Paid 3,900 cash for a computer. 3. Purchased 650 of supplies on account. Instructions a....
-
Ong Enterprises had the following selected transactions. 1. Shareholders invested NT\($40,000\) cash in the business in exchange for ordinary shares. 2. Paid office rent of NT\($8,400. 3. Performed...
-
The T-accounts below summarize the ledger of Negrete Landscaping at the end of the first month of operations (amounts in ). Instructions a. Prepare the complete general journal (including...
Study smarter with the SolutionInn App