You can keep the answers to one page with references. Please seperate the anwsers by the numbers listed5.1 "Relational Set Operators" Please respond to the following: A relational Database Model allows database users to analyze data thoroughly. To accomplish this, advanced commands such as UNION and INTERSECT may be used.  Describe a business scenario where a UNION relational set operator may be used to merge two similar data sets. Within the context of your business scenario, analyze the analysis and data consistency advantages of using a UNION operator rather than simply merging two data sets into one result table. Suppose you are tasked with finding common data elements amongst various data sets. Specify how an INTERSECT operator may assist you in accomplishing this task. Construct a query that can perform the same function as the INTERSECT operator without using the “INTERSECT” syntax within the query. Note: The Strayer Oracle Server may be used to test and compile the SQL Queries developed.   5.2 "Advanced SQL and PL / SQL" Please respond to the following: Extracting and interpreting data can be very valuable to an organization. Describe the importance of using sub queries in a database system. Provide at least two business case scenarios to support your response.   A good IT professional is able to be versatile in SQL programming styles. Identify at least two possible advantages of utilizing PL / SQL instead of standard SQL Syntax. Explain whether either syntax provides enhanced code processing capabilities with examples. Note: The Strayer Oracle Server may be used to test and compile the SQL Queries developed.   6.1 "Planning the DBLC" Please respond to the following:  The development of a database requires thorough methodology that ensures quality within the solution. Imagine you have been contracted to develop a finance database that will help an organization track monthly expenditures by departments. Using the DBLC, discuss the various activities that you would have to achieve each phase. Assess possible challenges that may exist within each phase. Suggest actions that one can perform in order to overcome these possible challenges. In order to mitigate risks associated with a database, it is essential to consider common sources of database failures. Describe at least two possible database failures that may occur once a database is placed into operation. Suggest actions that may be performed in order to avoid or mitigate these possible failures.  6.2 "Logical and Physical Design" Please respond to the following: In order to ensure optimal database performance, the logical and physical design should consider the user requirements thoroughly. Suppose you have been hired to transform a conceptual model into a logical model for a sales database. Describe the specific steps that you must perform in order to appropriately construct the database model. For each step mentioned, speculate the risks that would take place and how you would avoid or mitigate those risks.     Suggest at least three activities that are required in the physical design process of a database to ensure adequate physical storage and data access. Analyze why user, security groups, and role definitions are essential to maintain the integrity of the database. 7.1 "Concurrency Control" Please respond to the following: There are times when a database is accessed by many users across the enterprise.  Transaction logs can help maintain concurrency in a multiuser platform. Describe at least two business scenarios where COMMIT and ROLLBACK would be required. Describe how these functions would be essential for business continuity and concurrency control. Identify how these functions would enable an organization to recover from a database corruption event.  Describe how locks could be used in order to qualify data transactions and enhance concurrency control. Suggest at least two business scenarios that would benefit from implementing locking methods. 7.2 "Optimization for Transactional Processing" Please respond to the following: Databases can grow in data structure and data capacity throughout time. At certain times, it is necessary to perform optimization techniques in order to ensure optimal performance of the database. Evaluate at least two methods that can be used to optimize database components such as queries, reports SQL transaction processing, and data consumption. Provide a real-world example that explains how these methods would help an organization process a large number of online transactions within a short time span.  Suggest at least two SQL optimization techniques that can be used to enhance the data access turnaround time and transaction processing time. Provide examples to support your response. Assess the database statistics that could be used in order to measure database performance. Provide a real-world example that demonstrates how this information would enable businesses to accurately scale its data processing requirements. 8.1 "Centralized versus Decentralized Database Management Systems" Please respond to the following: Compare and contrast benefits and challenges that exist between centralized database management systems and distributed database management systems. Identify potential business environments where each can be properly used.  Analyze at least two considerations that would be required to ensure effective transaction transparency of centralized database management systems and distributed database management systems. Justify your response. 8.2 "Business Intelligence Tools" Please respond to the following: Business intelligence tools are considered the key drivers for many organizations. Identify and evaluate at least two business intelligence tools that could be effectively used to report business performance. Justify your response. Estimate the costs and describe the values of the two business intelligence tools you have identified from Part 1 of this discussion based on their functionality, integrating architecture, and benefits to the enterprise. Provide your rationale. 

Plagiarism will result in a grade of 0 on this entire assignment. Any direct quotations should be in quotes. Paraphrased items of substance should be cited. All sources used should be listed at the end of the report. Do not use the words and suggestions given by other financial analysts or web sources. This should be a report of your own thoughts and ideas supported by data from financial databases, financial statements, textbook content, and similar resources.The assignment sheet gives you lots of information, but I will summarize and add more here:This is a full report. That is why I think 7 - 10 pages would be needed to do a thorough job of covering all that has been asked in the original assignment. The items I put in parentheses are suggestions, not requirements. You may find some more interesting items that I have not even listed. That would be great.(1) I ask for sections - this means paragraphs of information, not short lists or sentences.Section 1 - Describe the sector (You could indicate key competitors; this could be a table with your companies listed first and any key competitors you did not have in your portfolio highlighted. You might point out the best and worst companies you found in the sector -- even if they are not in your portfolio) and point out recent news (For recent news, I would accept anything happening from 2015 to now as recent enough to consider. I do not want a boring list of news items, but you could highlight major legislation, regulations, lawsuits, or corporate events that stand out.)Section 2 - Compare three companies which include your 2 assigned + any other you choose that was in your portfolio (You could plot their stock prices over time or any other performance measure you want; you could describe how they are similar or how they differ, you could examine their capital structures using the WACC command from Bloomberg and compare or many other functions that Bloomberg has) and how they fared within the sector Section 3 - Discuss the international company from your sector (You could indicate what might be different between US laws, regulations, investors, etc. and those in the home country of that company. You could look at the risk profile of that country and the US using sources like the World Bank website or some others that tell you more country specific details. You might also use the Economic Indicators section of Bloomberg. Important international news affecting the sector might be noted.)Section 4 - More detailed company analysis (consider financial ratios or governance indicators)Section 5 - Sector comparison (choose any other sector you want and discuss how it is similar and/or how it is different from your assigned sector (You could tell how the current economic conditions favors your sector or the other sector more and why; Maybe your sector faces greater hurdles in terms of borrowing, attracting equity investors, regulations, etc. Give examples.)Conclusion: Give a statement (perhaps a paragraph) indicating whether the outlook overall is positive or negative for your sector, as well as for some of the specific stocks in your portfolio. (For example, which stocks should be bought and why; which should be sold and why)Be sure to note the high quality report guidelines on the assignment page from the syllabus. You might consider headings. You can name them whatever is appropriate, but one example might be: For e.g., for healthcareCover pageI. Introduction to the Healthcare SectorII. Key Companies in the SectorIII. An International Healthcare CompanyIV. Financial Analysis of Selected Healthcare CompaniesV. A Comparison of the Healthcare Sector to _________ SectorVI. ConclusionList of sources used to complete this report I WILL GIVE YOU THE COMPANIES NAMES AFTER YOU ACCEPT THE REQUEST

PowerPoint eork , 23- to 30 slide see the attachment........................................................