- 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.
- 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.
- The president of your company approached you with his iPhone in one hand and his iPad in the other. He has just purchased the iPhone 4S and is fascinated with Siri, the voice recognition software. He then pulls up an app your team developed for the company a few months ago and tells you that he wants it to work with voice commands just like Siri. When you pass this information on to your team, the news is met with groans and angry expressions. One of your developers tells you that it would be way too complicated to add voice recognition into the app and that you should have said no. Suggest three techniques to overcome the challenges of implementing natural language into interface designs.
- Sally, a young developer, requests a meeting with you to discuss a project. Sally tells you that she wants to develop a new application in a computer language she has developed, hoping to use the project as proof of concept for her newly developed language. Your firm encourages technological development and advancement and has allowed similar developments to happen in the past. Discuss with Sally what is required to be considered an effective computer language. Suggest three characteristics that make up an effective computer language. Support your response with evidence from the textbook or an article you found.
- You have just finished reviewing a design project your team has submitted to you and noticed that the team members used a great deal of command abbreviations. Explain to your team the value of using abbreviations for commands and give them at least two advantages and disadvantages associated with using abbreviations. Support your answer.
- From the e-Activity, Amore’s and Quesada’s article discusses the challenges of incorporating Natural Command Language Dialogs (NCLDs) into a phone system. One challenge pertains to sources of conflict in NCLDs. Discuss potential sources of conflict with an interface that you frequently use and devise a solution for preventing the conflicts.
0 comments