Category: Technology

This lab focuses on the design, build, and use of a relational database. You are to chose a database of your choice (the labs use MySQL, but you can use MS Access or other database) and complete the following:
Complete an EER diagram of the company database described in chapter 4. You may use Visio, PowerPoint, MySQL Workbench, or gliffy.com
Create the database based on your design. Write the Create table statements (even if you create the tables in MS Access, you need to provide the Create Table statements). Keep in mind keys and referential integrity requirements
Under Course Lab files you will find lab documents. Under chapter 4 use the data files provided to load the database.
Prepare the following queries:
Select * from each table
Complete a query with at least 2 joins
Complete a query with 2 joins and the use of an aggregate function like average or sum
Complete a query using an outer join
You should submit your EER diagram, DDL statements, Load DDL, and queries in a single document by the end of the course
The lab is worth 12% of your grade

Development of a robotic arm for automated manufacturing.
Important Info

The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.

Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)

Scenario
A company you work for is planning a two-day business conference. Conference speakers and attendees will be traveling from different cities. Over 15 speakers and 200 attendees are estimated to attend.
You are the lead technologist on the planning committee for this conference. To ensure that the event runs smoothly, you suggest that the company use the following web services for the conference:
Smartphone application to be used by conference attendees (e.g., Whova, 10Times, Grupio)
Web service functions and goals:
Lists the conference schedule
Tracks the number of attendees in each session
Provides a communication platform for attendees to virtually network throughout the conference
Allows attendees to add the sessions they want to attend into their calendars
Registration sign-in to be used by conference greeters
Web service functions and goals:
Allows user to enter a person’s name to see if they have already registered
Sends data to a server as to the time that each attendee arrived at the conference
Confirms whether registered attendee already purchased a ticket
Allows non-registered attendees to pay the ticket price and register
Virtual personal assistant to be used by event coordinators
Web service functions and goals:
Tracks the flight numbers and departure times for each speaker
Tracks when each conference speaker needs to be picked up from the airport
Provides GPS directions from airport to hotel
Provides the hotel information for each speaker(room number and check-in times)
As the lead technologist, you have to explain why and how these web services are necessary to the other members of the planning committee. In order to do this effectively, you need to create a technology plan. Not only do you have to consider the user perspective within your plan, but you also need to consider the developer perspective.
Directions
Develop a Technology Plan to present to the Conference Planning Committee. You may use a diagram or other visuals within your plan.
In your plan, be sure to:
1.
1.Explain the benefits of using web services from both a user perspective and a software developer perspective.
Consider the following question:
Why would your company create its own program that would be accessible over the web instead of using the three web services mentioned in the scenario?
2.Describe the purpose of each web service described in the scenario from a user perspective (smartphone application, registration sign-in, virtual personal assistant).
Consider the following questions:
Why would conference attendees use the smartphone application before, during, or after the conference?
Why would conference greeters use the registration sign-in before, during, or after the conference?
Why would event coordinators use the virtual personal assistant before, during, or after the conference?
3.Identify additional user requirements that developers would need to know prior to the conference.
Topics to consider may include how conference attendees may want to:
Use the conference schedule
Receive notifications
Interact with other attendees
Provide at least two new user requirements for each web service (smartphone application, registration sign-in, and virtual personal assistant) presented in the scenario.
After identifying the user requirements, explain how each web service functionality meets the user requirements you discussed. Be sure that you are referring to the user requirements you identified to explain how each web service functionality meets those requirements.
Determine the protocols that each web service should use to package and send data over a network, and explain why that protocol would be used to best support the service.
For the first web service, review the header file, shown in this header file resource, to make this determination.
What to Submit
To complete this project, you must submit the following:
Technology Plan
Your technology plan should be 3–5 pages in length and may include diagrams and visuals. Within the plan, you must address all of the topics presented in the directions.

This assignment has multiple steps. Please complete them in this order.
Read Snowflake Review: A data warehouse made better in the cloud by Martin Heller.
Setup your Snowflake free trial. Watch this YouTube video for directions.
Watch this Connect to Snowflake through Microsoft Excel tutorial.
Pull in a data set from Excel into Snowflake following the above videos.
For accessing your data after it’s loaded into Snowflake, I will provide a free key for Tableau that can be used to download the Tableau data visualization product which can be connected to snowflake.
Other tools such as PowerBI can be used if you have access to those already. See below for instructions on downloading Tableau.
Download the latest version of Tableau Desktop and Tableau Prep Builder here
Click on the link above and select “Download Tableau Desktop” and “Download Tableau Prep Builder.”
On the form, enter your Ottawa email address for business e-mail and enter Ottawa University for organization.
Activate with your product key: TCLI-69E5-F8E0-2994-E805
New to Tableau? Engage with their Data Analytics for University Students guide to help get started.
You can continue using Tableau after the class is over by individually requesting your own one-year license through the Tableau for Students program.
Already have a copy of Tableau Desktop installed?
Update your license in the application: Help menu → Manage Product Keys
Need help with Tableau? Find answers to frequently asked questions here.
In a PowerPoint of 5-7 slides, screen shot the steps in creating your connection in Snowflake and the data in Excel.
This can be any data set.
Remember to cite any content you did not create yourself using APA formatting.
References
Heller, M. (2019). Snowflake review: A data warehouse made better in the cloud. InfoWorld.
Kahan Data Solutions. (2020, December 1). Connect to Snowflake through Microsoft Excel [Video]. YouTube.
Snowflakian. (2020, May 16). Snowflake free account creation [Video]. YouTube.

Please explain why you would like to pursue your applied program at Mohamed Bin Zayed University of Artificial Intelligence and include the following information: (Note: I attached my CV file)
Motivation for applying to the university
Personal and academic background and how it makes you suitable for the program you are applying for
Experience in completing a diverse range of projects related to artificial intelligence
Stand-out achievements (e.g., awards, distinction, etc)
Goals as a prospective student
Preferred career path and plans after completing your applied program
Any other details that will support the application
Website:https://www.mbzuai.ac.ae
Note: I am working at ADNOC group, please mention the future vision of Machine Learning concept as part of our country (United Arab Emirates) targets toward to the sustainability.

Create a data model for the data warehouse using the environment you have chosen. Determine which data model type you will use to create the data elements. Present your creation in a narrated presentation.
Your presentation must include:
5-7 slides in PowerPoint;
use APA formatting throughout the presentation. Remember to cite all media you do not create.

Answer each week’s question only in your own words. No copying and pasting as it will be checked for plagiarism upon submission.
Week 2 AI Assignment (One page)
Discuss how does ChatGPT contribute to enhancing customer experience and increasing customer loyalty in the finance sector?
Outcomes: By Automating customer service and support functions. Discussion on the Impact on various industries.
Week 3 AI Assignment (One page)
Discuss how ChatGPT can contribute to improving customer relationship management in business?
Outcomes: By providing personalized customer interactions using advanced natural language processing.
Week 4 AI Assignment (One page)
How can ChatGPT benefit organizations in terms of customer support and customer experience?
Outcomes: By providing personalized recommendations and 24/7 support.

When completing the case study you must have a minimum of 3-5 outside sources cited and referenced in the paper. Your references page must be written in APA citation style.
Case Study
You are hired by JLA Enterprise to conduct a Forensic Examination after a network intrusion occurs at their corporate office. Your job is to determine the source of the network intrusion and provide as much information regarding the attack as possible. Here are some things to consider when explaining what happened during the network intrusion:
What time did the attack happen?
How did the hacker get into the network?
What computers were compromised?
What computers were accessed?
What data was extracted from the network?
What type of attack was conducted?
How long did the attacker have access to the network?
Is there any persistence on the network for future attacks?
You are asked to conduct a forensics examination of the network and provide a forensic report explaining what happened during the attack and what corporate data was compromised. The report should cover the above information, as well as create a timeline that shows the attack from the initial stages of the attack to when the data was extracted from the network.
Your submission should be about 3 to 5 pages (not including the title page and the references page) long in APA format with proper citations and references if you are using them. It will be subjected to checking against plagiarism. The final product must follow acceptable originality criteria (no more than 15% max total, and 2% per individual source match are allowed).

I. What is the difference between a compiler and an interpreter? What are the words that make up a high-level programming language?

Designing a crypto app for real-time view and search of cryptocurrency prices:
1. Introduction:
– Provide background on the growing demand for cryptocurrency tracking apps and the importance of secure user authentication.
– Highlight the aims and objectives of your proposed crypto app, including the real-time price monitoring and search functionality.
2. Proposed App Idea:
– Describe the key features of your crypto app, such as:
– Real-time price tracking for major cryptocurrencies
– Ability to search and compare prices across different cryptocurrencies
– Customizable watchlists and price alerts
– Biometric authentication (e.g., fingerprint or face recognition) for secure user login
3. App Development Approach:
– Discuss the decision to use Kotlin (KT) and Java for the app development, highlighting the benefits of this hybrid approach.
– Explain the reasons for choosing the KT+Java stack, such as:
– Improved code readability and maintainability
– Leveraging the strengths of both languages (e.g., Kotlin′s conciseness, Java′s extensive ecosystem)
– Seamless integration with the Android platform and associated libraries
– Mention the use of Android Studio as the development platform for deploying the app.
4. Biometric Authentication:
– Describe the implementation of biometric authentication in your crypto app, such as:
– Integrating fingerprint or face recognition APIs provided by the Android platform
– Ensuring secure storage and handling of biometric data
– Providing a seamless and user-friendly login experience
– Discuss the importance of biometric authentication in the context of a cryptocurrency tracking app, where user security and data privacy are critical.
5. App Design Considerations:
a. Data Persistence:
– Explain how you will achieve data persistence in your app, such as:
– Storing user preferences, watchlists, and price alerts using a local database (e.g., Room or SQLite)
– Caching historical price data for offline access
b. Sensors and APIs:
– Identify the external APIs your app will utilize, such as:
– Cryptocurrency exchange APIs for real-time price data
– Geolocation API for location-based features (e.g., currency conversion based on user′s location)
– Discuss the rationale for selecting these APIs and how they contribute to the app′s functionality.
c. Cloud Integration:
– Explore how cloud services can be used to enhance the user experience and functionality of your crypto app, such as:
– Cloud storage for user data sync across devices
– Cloud-based price data processing and analysis
– Integration with AI-powered services for personalized recommendations or price prediction
6. Deployment and Testing:
– Discuss the use of Android Studio as the platform for deploying your crypto app.
– Outline the testing strategies you will employ, such as:
– Unit testing for individual components
– Integration testing to ensure seamless functionality
– User acceptance testing to gather feedback and refine the app
7. Conclusion:
– Summarize the key aspects of your proposed crypto app, highlighting the use of KT+Java, biometric authentication, and the Android Studio deployment.
– Emphasize how the app′s design and features can provide a secure and efficient cryptocurrency tracking experience for users.
8. References:
– Include a list of sources and references used in the essay.
Remember to keep the essay within the 1,500-word limit and ensure that it covers the required topics as outlined in the assignment requirements. APA format