#Idea This is an App I have created for 6th semester collage End Term Submission. This idea come to me when School of Computer Science of Engineering ask every one to design an android app for 5th semester Project, After getting project I was looking for an unique name the Musica (name) come at that time, Musica is an Spanish name which means music (Song). #Design In this app First I have created splash activity after opening splash activity we Have move to home page I Navigation Layout to open songs, songs information and list of songs are their. In this app I also wanted to get music (Songs) from are External storage and display them into the cardview, I wanted this to show alert dialog during deleting some song ask as to you wanted to delete or not option. at that I have find some problems during Design on this App but I ask some of my faculties to resolve the issue they help me resolve me that issue. The first version of the app would include the following user flows . User can login via Email and Google When the user opens app for the first time, song are added into the list view and he can play these song The user can Search songs which he likes the songs. The user can play song and listen at another page and stop the song When User Wanted To Quit the songs he alert dialog for quit the song. #Outcome I looked some similar app like that jio sawan and Ganna I fount some problem in these Apps we can not get downloaded songs in our list of songs So I have created this app to help user to listen there downloaded songs in there list of song so that they do not found problem to listen songs which they actually like. #Philosophy Of Building Apps I Have created more then 5+ apps I think If you work on multiple apps then you get more information developing apps, and how to resolve issues of apps. Writing good code comes out of practice, experience and lots of code reading. I realized that well-written code always comes back to help you. A good UI/UX design is also the key to your app’s success. Design should be geared towards making the app easy to use for any random user. It should also be practical enough for developers to implement quickly. I always look at the design components available in Material Design before creating a new one. #Engineering I have done B.Tech in Computer Science and Engineering from Lovely Professional University . I started my career as a Android Developer Intern where I working on Android , java, Firebase, Restful apis, UX/UI design ,Json. Another side I learnt flutter and dart from Udemy #Want to build a Mobile app? Reach out to me. If you have an idea and want to convert it into Android app, do get in touch with us. apart from Android development we are working ios apps also link : https://github.com/rishabh1422/musica Hire an android developer to get quick help for all your android app development needs. with the hands-on android assignment help and android project help by Codersarts android expert. You can contact the android programming help expert any time; we will help you overcome all the issues and find the right solution. Want to get help right now? Or Want to know price quote Please send your requirement files at contact@codersarts.com. and you'll get instant reply as soon as requirement receives

1. Consider a perceptron learning algorithm (PLA) used for a binary classification problem (adaptive decision boundary). Question: What will be the algorithm’s output if the training data are not linearly separable? Answer: The perceptron learning algorithm does not terminate if the learning set is not linearly separable. To avoid infinite looping, specify finite number of iterations. Question: Would you call the PLA supervised or unsupervised learning? Answer: Supervised learning 2. Obtain the linear regression of Y on X1, X2 (by hand-calculation or writing code, but do not use an off-the-shelf linear regression function): X1 X2 Y 0 0 2 0 1 2 1 0 10 1 1 10 Question1: Write the regression equation. Question2: If we use the result of this regression as a classifier, what will be the equation of the classifier? 3. Exercises 3.6 and 3.7 from the textbook (page 92). 4. In least squares linear regression, we obtain the solution (the weights) analytically. In logistics regression, why don’t we analytically solve for the weights by setting the partial derivatives of the (log-)likelihood expression (or the negative of that expression) to zeros? 5. Explain the concepts of “training data,” “test data,” “training error,” and “test error.” Is it good to have as low a training error as possible? 6.Justify or refute: Gradient descent/ascent guarantees convergence to the global optimal solution. 7. Advice: Please read the textbook carefully. If you can devote further time, read the references. Get instant help or need compete solutions of any machine learning project or research paper then you can contact us at: contact@codersarts.com

Instruction: 1. Use Scikit‐Learn to complete the assignment. Question 1: Class imbalance, ensembles, and feature selection For this question, we are again using the Portuguese Bank Marketing dataset from the UCI Machine Learning Repository. (The direct link is located at https://archive.ics.uci.edu/ml/datasets/Bank+Marketing. You should again use the bank-additional-full.csv file with all examples (41188) and 20 inputs for this assignment.) The aim of this binary learning task is to predict whether a client will purchase a product from the bank, i.e. the output variable (desired target) is feature 21, with classes 'yes' and 'no'. Recall that this data set is imbalanced. In this assignment, our aim is to improve the performance of the algorithms used in homework 1, apply ensemble-based methods and assess the significance of the results. Complete the following tasks. 1. Rebalance the data set using three different approaches. Oversampling of the minority class. Under-sampling of the majority class. Balanced sampling, i.e. combining oversampling and under-sampling. 2. Apply the four algorithms (a support vector machine (SVM), a decision tree, a Naïve Bayesian learner, and the k‐nearest neighbor (k-NN)), as used in homework 1 to the three resampled data sets. Report your results when using tenfold cross validation. 3. In addition, construct models using the random forests (RFs) and extreme learning trees algorithms, again using tenfold cross validation. 4. Choose the sampling method that produces the best results and motivate your answer. 5. Create a table showing the accuracies of the six algorithms against each one of the ten folds when trained using the sampling technique you selected in question A.4, similar to Example 12.4 in the textbook. Hint: Also refer to Section 12.3, and notably Example 12.6, in the textbook as well as the slides. 6. Determine whether there is a statistically significant difference in the accuracies obtained by the six algorithms against this dataset. 7. Next, apply two different feature selection techniques to the data you chose in question A.4. 8. Retrain the “best two” algorithms, as selected during question A.6, to determine whether feature selection led to improvements in accuracies. Motivate your answer by showing the average accuracies obtained during tenfold cross validation, before and after feature selection. Part B: Comparison of algorithms - multiple datasets Consider the following three benchmarking datasets, together with the Portuguese Bank Marketing dataset. https://archive.ics.uci.edu/ml/datasets/Labor+Relations https://archive.ics.uci.edu/ml/datasets/Congressional+Voting+Records https://archive.ics.uci.edu/ml/datasets/Iris 1. Apply only the SVM, k-NN and RFs algorithms to the three new data sets, again using tenfold cross validation, to obtain the average accuracies over the ten folds. 2. Create a table showing the average accuracies of the three algorithms against all four data sets. (For the Portuguese Bank Marketing dataset, report the most accurate results you obtained in Part A.) Use Friedman’s test to determine whether there is a statistically significant difference in the accuracies obtained in question B.1, calculate the critical difference (CD) and draw the Nemenyi diagram. Hint: Refer to Section 12.3, and notably Example 12.8 and Figure 12.1 (top), of the textbook. Also, see the slides that contain the Friedman test values(Did not receive this yet) TextBook Link: http://2.180.2.83:801/opac/temp/11802.pdf Peter Flach :Machine Learning The art and science of algorithms that make sense of data. Contact us to get instant help with an affordable price or need solution of this project then send your request at here: contact@codersarts.com

In this we have retrieving data form web pages and perform the following task: Steps needs to perform: Retrieving Text from Static Website Beautiful Soup Using Newspaper3K to handle text cleanup Several Web Examples Processing Local Text File Basic WordCloud with WordCloud Readability with Textatistic Sentiment Analysis with TextBlob Be able to: Download text from (some) web pages and prep for text analysis. Clean up the text with Beautiful Soup, if possible. Learn to use a library like Article to extract articles from most news sites and blogs including key meta-data. Practice manipulating speech transcript data from Rev.com. Perform sentiment analysis and plot sentence level subjectivity and polarity data with matplotlib and plotly express Wrangling Text from Web-pages is Hard! Each web-site stores data different so you need to be a sleuth. Most modern sites no longer store the text as part of the page. Static web pages are hard to find. You could spend a semester just on retrieving data from web-pages or other APIs. Many web-pages have restrictions on what you can retrieve. (See robots.txt before making heavy use of a web-page.) Most book examples will use a static, locally stored text file as input. Some newer tools (e.g. Article) can make it "easier" to retrieve properly formatted pages. Install from Command or Terminal Prompt (not Jupyter Notebook) TextBlob Module conda install -c conda-forge textblob ipython -m textblob.download_corpora Note: Windows users may need to run as administrator wordcloud Module *conda install -c conda-forge wordcloud Install from Command or Terminal Prompt (continued) Newspaper3k https://github.com/codelucas/newspaper Reliable text scraping pip3 install newspaper3k TextTastic Module Not required for our assignments but good for practice and examples pip install textatistic Note: Windows users may need to run as administrator* Some students have reported needing to install VS Code to get Textatistic to work (ymmv)* https://www.rev.com/blog/transcripts/donald-trump-white-house-rally-speech-transcript-october-10-first-event-since-covid-diagnosis Importing All Related Libraries import requests        # import from web from bs4 import BeautifulSoup      # clean up text from wordcloud import WordCloud    # create word clouds from textblob import TextBlob      # basic NLP, install first from textatistic import Textatistic   # readability, install first from pathlib import Path    # for quick import of text file for NLP import pandas as pd import seaborn as sns import matplotlib.pyplot as plt from plotly import express as px # Magics %config InlineBackend.figure_format = 'retina' %matplotlib inline Example 1: Extraction Block or Not Allowed ## 403 Forbidden Error, extract blocked / not allowed url = 'https://www.americanrhetoric.com/speeches/mlkihaveadream.htm' response = requests.get(url)   # retrieve the webpage response.content               # show content from the retrieved page Example 2: Static, Predominately Text-based Web-Page ## Static web page - JFK speech re: moon url = 'https://er.jsc.nasa.gov/seh/ricetalk.htm' response = requests.get(url) response.content       # Notice moderate amount of HTML code soup = BeautifulSoup(response.content, 'html5lib') text = soup.get_text(strip=True)  # text without tags text       #BeautifulSoup has done a decent job on this page removing HTML Example 3: Sometimes it is easier to copy and paste to a file ## Somewhat hidden text url = 'https://www.whitehouse.gov/briefings-statements/remarks-president-trump-2020-united-states-military-academy-west-point-graduation-ceremony/' response = requests.get(url) response.content            # UGLY! significant amount of code -- Where's the text?? ## Soup doesn't help much in this case soup = BeautifulSoup(response.content, 'html5lib') text = soup.get_text(strip=True)   text Let's try Article Steps: Install newspaper3k via pip (only do this once per machine) Import Article from newspaper (once per notebook) Create an article object and set it to the URL of the web-page (required once per web-page) Download (required after creating article object) Parse the downloaded object (required once per download, separate data into text, authors, title, date, etc.) Now you are ready for other tasks (view text, check authors and publication date; perform NLP tasks). https://newspaper.readthedocs.io/en/latest/ Try it! Try the newspaper article code on your own link to a site that is likely to have all of the atributes # Change the url to your own, comment out all urls but one, note may not show all of article if behind pay wall url = 'https://hbr.org/2020/04/bringing-an-analytics-mindset-to-the-pandemic' # url = 'https://www.wsj.com/articles/ceos-increasingly-see-sustainability-as-path-to-profitability-11602535250' # url = 'https://www.cnn.com/2020/10/13/health/us-coronavirus-tuesday/index.html' article = Article(url) article.download() article.parse() print("Title: ", article.title)   print("Authors: ", article.authors)   print("Publication Date: ", article.publish_date)   print("First Image:", article.top_image)   print("Video Links:", article.movies) print("Title: ", article.title) print() print(article.text) article.nlp() print("KeyWords: ", article.keywords)   # creates a list of authors; no authors on this page print() print("Summary: ", article.summary)  # no publish date on this web-page Processing a Transcript with Newspaper3k We can leverage article to retrieve text of transcribed speeches though we may need to process the data a bit to prepare it for analysis. Most transcripts include speaker names, time stamps and other information. Speech Transcript These examples are specifically for the transcript site https://www.rev.com/blog/transcripts Modifications likely for other speech sources # Set the url # From rev.com url = 'https://www.rev.com/blog/transcripts/donald-trump-mosinee-wi-rally-speech-transcript-september-17' event = '-mosinee-2020' # this will be part of the file name for a text file we create  #url = 'https://www.rev.com/blog/transcripts/ruth-bader-ginsburg-stanford-rathbun-lecture-transcript-2017' #event = '-standfordlecture-2017' # Minimum code needed to get to the text of the speech article = Article(url) article.download() article.parse() print(article.text) # write the text to a file with open('speech.txt', 'w') as f:     f.writelines(text) with open('speech.txt', 'r') as f: for cnt, line in enumerate(f): print(f'Line {cnt}: {line}') # Custom processing for rev site # line 0 = speaker and time # line 2 = what speaker said # lines 1 and 3 = blanks # create four lists of the components of speech with open('speech.txt', 'r') as f:     speech = f.readlines() tmp = [] speaker = [] time = [] words = [] for cnt, line in enumerate(speech): if cnt % 2 == 0:         tmp.append(line.rstrip())   # temp list of just the text lines 0,2 for i in range(0,len(tmp),2):     speaker.append(tmp[i].split(': ')[0])  #split speaker line into 2 parts     time.append(tmp[i].split(': ')[1])     words.append(tmp[i+1])    # words from speaker # find unique speaker names for later filter set(speaker) spkr = 'Donald Trump' file = spkr.split()[len(spkr.split())-1] + event + '.txt' file # use write instead of writelines since we don't want entire list # remember to add new line with open(file,'w') as f: for i in range(0,len(speaker)): if speaker[i] == spkr:             f.write(words[i]+'\n') # Confirm good file text = Path(file).read_text() text Web scrapping using beautiful soup is used in machine learning or data science to extract useful data and preform machine learning algorithms or task on it, like: sentiment analysis in NLP etc. If need any help related to this then contact us at: contact@codersarts.com

INTRODUCTION :- Problem Statement is most of the users have to use multiple apps to track their fitness activity, do workout, exercises & meal planning. People lose interest after a while as they find it very cumbersome to use different apps and keep track of it. Solution to the above is and mobile applications that will help users develop the habit of practicing daily to track their progress (activity, meal, nutrition intake, workout. etc.) and stay motivated especially when they are slacking. Competitive Analysis I started of first with Competitive Analysis. I did analysis on 3 apps Strava, Runkeeper & CarrotfitBased on the target user defined earlier; I recruited 6 personas and conducted interview session with them to understand their lifestyle, difficulties they go through to keep themselves fit, what are their aspirations and what motivates them to be consistent. My questions were based on need, task and value. Persona Board I shortlisted 3 users to create by persona board. This exercise helped me understand clearly what are their motivation, frustration, goals & expectations also about their lifestyle. Below is an example from one of the user’s persona boards. Empathy Map Empathy map helped to understand what users say, here, think/feels and do, which give me their pain and gains. Customer Journey Mapping This journey helped me understand where users are facing problem and how they can be solved with digital touch points, which gives a list of features that I can have in the app to improve the user’s experience. After completing customer journey map for all the users, I got a list of features. I used few features marked in blue and the other will be worked on, in the next phase. Task Flow I worked on the task flow for this app, it was important that the flow is very simple and easy for user to navigate around using the app. Information Architecture (IA) I performed card sorting to understand which feature fits best under which section. Contents were organized based on location and Time. Low Fidelity wireframe I started with basic level wireframe with help of balsamic tool. The journey I choose to work on was tracking your activity with GPS. Mid Fidelity Wireframe or Digital Wireframe In this journey I tried to be as detailed as possible, from navigation, icons, and touch points. Interactive Prototype I used Invisionapp to create interactive prototype. It is very simple to use application. Usability Testing I conducted usability testing by sharing the prototype link with users and asked them to perform few task. The list of tasks was: Check your today’s task to be completed. Add an activity to your schedule. You are going for morning walk. Start tracking your activity. Can you point out what are the activities completed. After usability test I worked on the issues faced by the users and tried to fix them. Finally I have a product that user is happy to use it on daily basis. Our goals As there were no specifications at the beginning of the project, our goals were to: Create a technical specification Develop an MVP to a tight deadline Expand the MVP later into a full-fledged product Integrate the application into an existing management system. We created the technical specification and defined these features for the application: Personal profiles Activities (booked classes, membership cards, statuses) QR code scanner Listing of all classes with descriptions Information about trainers Dynamic scheduling Class bookings and cancellations Wait lists for group classes Maps and routes Payment system for classes Memberships of different levels and durations Internal currency The challenges 1. No specification Our client had never created a mobile app before, and they had no specification at the start of the project. However, as they already had a website with most of the features we needed to implement, creating the technical specification wasn’t that hard. 2. Tight deadline This was our first challenge, as we had only two months to develop a mobile app that would work for all of our client’s fitness centers3. Complex functionality Our client wanted to provide an experience in a mobile app similar to that of the website, but some elements of the interface appeared to be too complex. For example, the suggested personal profile feature was far too complex. It featured: Memberships Links to other pages in the app Internal currency balance Invite code for sharing with friends Activities, including all purchases, points, and order statuses Personal information Addresses of gym locations Maps with routes, pins, and other features4. Integration with gyms and fitness clubs To really be useful for gym-goers, we needed to add mobile-specific features that wouldn’t merely copy the website but would make users’ lives easier and provide them with additional value. Our solutions 1. We created a technical specification To be able to plan the development process and provide our client with a detailed estimate, we needed to create a technical specification. As a full-cycle development company, we provided a business analyst who: Extracted knowledge and business expectations from the client during an interview Created wireframes to show how the user experience would look Developed a technical specification with a description of the main features, technologies, and the people responsible for delivery, testing, and acceptance we created an MVP As we created the technical specification with the client, we determined the features for the app. To meet the deadline, we created a plan for an MVP and added the remaining features to our backlog. The MVP consisted of: Personal profiles Class bookings and cancellations Membership card management and purchases Activities Determining the main features allowed us to focus and plan our time so we could meet the deadline. Also, these features were enough to meet the business goals. CONCLUSION: - We managed to create a gym locator app in just few months. Then we spent another few months, implementing the remaining functionality and changing the application according to the feedback from the user. We continue to work on this product, integrating new features and supporting the application. Hire Figma Experts for any kind of projects – urgent bug fixes, minor enhancement, full time and part time projects, If you need any type project hep, Our expert will help you start designing immediately. T H A N K Y O U

What's new Android Studio 4.1 includes these new enhancements & features: Design Material Design Components updates Android Studio templates in the create New Project dialog now use Material Design Components (MDC) and conform to updated guidance for themes and styles by default. These changes will make it easier to use recommended material styling patterns and support modern UI features like dark themes. Develop Database Inspector Run Android Emulator directly in Android Studio Dagger navigation support Use TensorFlow Lite models Build & Test Android Emulator - Foldable Hinge Support Apply Changes updates Export C/C++ dependencies from AARs Symbolification for native crash reports Optimize System Trace UI Improvements Standalone profilers Native Memory Profiler Reference : https://android-developers.googleblog.com/2020/10/android-studio-41.html?m=1 Hire an android developer to get quick help for all your android app development needs. with the hands-on android assignment help and android project help by Codersarts android expert. You can contact the android programming help expert any time; we will help you overcome all the issues and find the right solution. Want to get help right now? Or Want to know price quote Please send your requirement files at contact@codersarts.com. and you'll get instant reply as soon as requirement receives

Aim This coursework examines the student’s ability to design a relational database, manipulate and analyse large datasets, and to interpret analysis results. Part 1: Designing a Relational Database Little Panda is a takeaway who wants to open up its business to accept online orders. To do this, it needs a database to store its food menu, customer data and orders. Your task is to design a relational database that runs on MySQL. Here are some requirements: Customers must register before they can make orders. They must provide enough details for home delivery. Menu item prices may change. Customers are charged prices at the time of order. Little Panda needs to know the status of an order so that they can follow up. e.g. either it is “waiting to be cooked”, “cooked and to be delivered”, or delivered, etc. You can assume all orders are paid before they enter the system. Order details must be stored for accounting purpose, even after they are completed. Other than these it is a usual takeaway scenario. You can apply your common sense to make reasonable assumptions. Part 2: Analysing the “UN City Population” Dataset You are given the “UN city population” dataset. Perform the following analysis using Pig: Question 1: Find the number of countries in the dataset. Question 2: List the countries together with the number of cities in each country1 . Question 3: List countries in ascending order of female-to-male ratio, throughout the years2 . Question 4: List the top 10 most populated cities according to the most recent data in the dataset3 . Question 5: List the top 10 cities which have the highest population change per year in percentage since the start of the survey4 . Notes: You must use Pig. Annotate your program code properly so that the marker can understand how it works. The annotation also contributes to the grade. State any assumption that you made. If you cannot complete a task, an incomplete solution may also bring you partial credit. Part 3: Analysing Datasets of Your Choice In this part of the coursework you need to: 1. Find a dataset, or multiple datasets. Dataset(s) must be public domain and of a considerable size. ▪ A dataset cannot be too small. e.g. Just a few lines. ▪ There is no need to go for a GB or TB-sized dataset unless the dataset is very interesting. ◦ DO NOT choose a dataset similar to the one in part 2. 2. Propose 3 analysis tasks that you will perform on the dataset(s). ◦ Your proposed analyses should be insightful. e.g. give useful information for decision making. ◦ You may combine multiple datasets for some interesting analyses. ◦ DO NOT propose tasks similar to those in part 2. 3. Implement the 3 proposed analyses using Pig. 4. For each analysis, interpret the result. Dataset Source Here are some starting places to look for datasets: https://github.com/datasets http://www.datasciencecentral.com/profiles/blogs/big-data-sets-available-for-free http://hadoopilluminated.com/hadoop_illuminated/Public_Bigdata_Sets.html Deliverables Part 1: Show an ER diagram of your conceptual model. State all assumptions you have made. State all limitations (if any) of your design. Show the process of normalisation up to the 3rd Normal Form. • DO NOT just claim your schema is in 3NF. You must show evidence. e.g functional dependencies among attributes and keys. • Show how the database schema changes as normalisation progresses. Show your final database schema. i.e. All tables and their structures Part 2 & 3: Your submission should include the followings: ▪ All Pig scripts for the tasks. • DO NOT combine all Pig scripts into one file. • These scripts should be provided as separate text files which are ready to be executed. ▪ A report, preferably in PDF format. • For part 2: ◦ State the result of each analysis task. ◦ For short results, you can copy-and-paste them into the report. For long results, include them as external text files. • For part 3: ◦ Describe your chosen dataset. e.g. What is it about? ▪ State clearly the source of the dataset. e.g. What is its URL? ▪ Describe the format of the dataset. e.g. What does each field mean? ▪ Explain your motivation in selecting this dataset. For example: • What makes you interested in this dataset? • What useful information can you get from this dataset? ◦ For the 3 proposed analyses. ▪ Explain the motivation of each analysis. ▪ State the result of each analysis. If you need any help related to design a relational database, manipulate and analyse large datasets then you can contact us at: contact@codersarts.com

-- Connect to your Postgres server and set the active database to CAP ("\connect CAP" in psql). Then ... Droping Tables if already exist with same name DROP TABLE IF EXISTS Orders; DROP TABLE IF EXISTS Products; DROP TABLE IF EXISTS Customers; DROP TABLE IF EXISTS Agents; DROP TABLE IF EXISTS People; Creating Tables -- People -- CREATE TABLE People ( pid int not null, prefix text, firstName text, lastName text, suffix text, homeCity text, DOB date, primary key(pid) ); -- Customers -- CREATE TABLE Customers ( pid int not null references People(pid), paymentTerms text, discountPct decimal(5,2), primary key(pid) ); -- Agents -- CREATE TABLE Agents ( pid int not null references People(pid), paymentTerms text, commissionPct decimal(5,2), primary key(pid) ); -- Products -- CREATE TABLE Products ( prodId char(3) not null, name text, city text, qtyOnHand int, priceUSD numeric(10,2), primary key(prodId) ); -- Orders -- CREATE TABLE Orders ( orderNum int not null, dateOrdered date not null, custId int not null references Customers(pid), agentId int not null references Agents(pid), prodId char(3) not null references Products(prodId), quantityOrdered integer, totalUSD numeric(12,2), primary key(orderNum) ); Inserting Records Into tables -- People -- INSERT INTO People (pid, prefix, firstName, lastName, suffix, homeCity, DOB) VALUES (001, 'Dr.', 'Neil', 'Peart', 'Ph.D.', 'Toronto', '1952-09-12'), (002, 'Ms.', 'Regina', 'Schock', NULL, 'Toronto', '1957-08-31'), (003, 'Mr.', 'Bruce', 'Crump', 'Jr.', 'Jacksonville', '1957-07-17'), (004, 'Mr.', 'Todd', 'Sucherman', NULL, 'Chicago', '1969-05-02'), (005, 'Mr.', 'Bernard', 'Purdie', NULL, 'Teaneck', '1939-06-11'), (006, 'Ms.', 'Demetra', 'Plakas', 'Esq.', 'Santa Monica', '1960-11-09'), (007, 'Ms.', 'Terri Lyne', 'Carrington', NULL, 'Boston', '1965-08-04'), (008, 'Dr.', 'Bill', 'Bruford', 'Ph.D.', 'Kent', '1949-05-17'), (009, 'Mr.', 'Alan', 'White', 'III', 'Pelton', '1949-06-14') ; -- Customers -- INSERT INTO Customers (pid, paymentTerms, discountPct) VALUES (001, 'Net 30' , 21.12), (004, 'Net 15' , 4.04), (005, 'In Advance', 5.50), (007, 'On Receipt', 2.00), (008, 'Net 30' , 10.00) ; -- Agents -- INSERT INTO Agents (pid, paymentTerms, commissionPct) VALUES (002, 'Quarterly', 5.00), (003, 'Annually', 10.00), (005, 'Monthly', 2.00), (006, 'Weekly', 1.00) ; -- Products -- INSERT INTO Products( prodId, name, city, qtyOnHand, priceUSD ) VALUES ('p01', 'Heisenberg Compensator', 'Dallas', 47, 67.50), ('p02', 'Universal Translator', 'Newark', 2399, 5.50 ), ('p03', 'Commodore PET', 'Duluth', 1979, 65.02 ), ('p04', 'LCARS module', 'Duluth', 3, 47.00 ), ('p05', 'Remo drumhead', 'Dallas', 8675309, 16.61 ), ('p06', 'Trapper Keeper', 'Dallas', 1982, 2.00 ), ('p07', 'Flux Capacitor', 'Newark', 1007, 1.00 ), ('p08', 'HAL 9000 memory core', 'Newark', 200, 1.25 ), ('p09', 'Red Barchetta', 'Toronto', 1, 379000.47 ) ; -- Orders -- INSERT INTO Orders(orderNum, dateOrdered, custId, agentId, prodId, quantityOrdered, totalUSD) VALUES (1011, '2020-01-23', 001, 002, 'p01', 1100, 58568.40), (1012, '2020-01-23', 004, 003, 'p03', 1200, 74871.83), (1015, '2020-01-23', 005, 003, 'p05', 1000, 15696.45), (1016, '2020-01-23', 008, 003, 'p01', 1000, 60750.00), (1017, '2020-02-14', 001, 003, 'p03', 500, 25643.88), (1018, '2020-02-14', 001, 003, 'p04', 600, 22244.16), (1019, '2020-02-14', 001, 002, 'p02', 400, 1735.36), (1020, '2020-02-14', 004, 005, 'p07', 600, 575.76), (1021, '2020-02-14', 004, 005, 'p01', 1000, 64773.00), (1022, '2020-03-15', 001, 003, 'p06', 450, 709.92), (1023, '2020-03-15', 001, 002, 'p05', 500, 6550.984), (1024, '2020-03-15', 005, 002, 'p01', 880, 56133.00), (1025, '2020-04-01', 008, 003, 'p07', 888, 799.20), (1026, '2020-05-01', 008, 005, 'p03', 808, 47282.54) ; Queries Related to Given Schema Query 1: Display the cities that makes the most different kinds of products. Query 2: Display the names of products whose priceUSD is at or above the average priceUSD, in reverse-alphabetical order. Query 3: Display the customer last name, product id ordered, and the totalUSD for all orders made in March, sorted by totalUSD from high to low. Query 4: Display the last name of all customers (in reverse alphabetical order) and their total ordered, and nothing more. (Hint: Use coalesce to avoid showing NULLs.) Query 5: Display the names of all customers who bought products from agents based in Teaneck along with the names of the products they ordered, and the names of the agents who sold it to them. Query 6: Write a query to check the accuracy of the totalUSD column in the Orders table. This means calculating Orders.totalUSD from data in other tables and comparing those values to the values in Orders.totalUSD. Display all rows in Orders where Orders.totalUSD is incorrect, if any. If there are any incorrect values, explain why they are wrong. Query 7: Display the first and last name of all customers who are also agents. Query 8:Create a VIEW of all Customer and People data called PeopleCustomers. Then another VIEW of all Agent and People data called PeopleAgents. Then "select *" from each of them in turn to test. Query 9:Display the first and last name of all customers who are also agents, this time using the views you created. Query 10:Compare your SQL in #7 (no views) and #9 (using views). The output is the same. How does that work? What is the database server doing internally when it processes the #9 query? Get complete solution of above queries with an affordable price by sending request at: contact@codersarts.com or need other database assignment help also contact us and get help.

Submission file Please submit a PDF file that, for each query, contains: 1) SQL query: copy and paste your query in the pdf 2) a screenshot executing the query in SQLite Studio, and it should clearly show the output table. EntertainmentAgency.sqlite Query1. What is the percentage of male and female entertainer members whose musical style is Jazz? The query should output the percentages of each gender separately and indicate which is which. (The percentage here means percentage out of all members) Query2. What is the full name (in the form of LastName, FirstName) of the top 3 agents who have the highest average commission per engagement? Print out both the full names and the average commissions. The average commission can be calculated by multiplying the contract price with the agent’s commission rate. Query3. What is the total income of the Jazz entertainers (i.e.,the sum of all Jazz entertainers’ income across all of their engagements) and the total income of the Salsa entertainers? The income of each entertainer for each engagement is the ContractPrice of the engagement minus the agent’s commission. To receive credit you must not use subqueries anywhere (i.e., no nested SELECT clauses at all). Query4. What are the top 5 musical styles that have the highest number of customers, and how many customers each of these styles has? BowlingLeague.sqlite Query5. Which teams have captains with the same last name? Each such team must be listed exactly once, along with the team captain’s full name (in the form of LastName, FirstName). Query6. List the TourneyDate,TourneyLocation,TeamNames and Lanes of the teams that have captains with the same last name. You can use only the team name from the results of the previous question. To receive credit you must not use subqueries anywhere (i.e., no nested SELECT clauses at all). Query7. How many teams have the different players with the same last name? To receive credit you must not use subqueries anywhere (i.e., no nested SELECT clauses at all). SalesOrders.sqlite Query8. Print the states that have a customer, but no vendor. Query9. Print a report of the 5 products that have sold in the greatest total quantity (the most popular products). You should print the name of the product and the total quantity. Be careful to count the quantity in each order, not just the number of times a product was ordered. Query10. Print all the pair of products whose names have the same number of characters. List each pair only once (ie., don't list both A,B and B,A).(SQLite has a LENGTH() function that can be applied to text. https://sqlite.org/lang_corefunc.html#length) You can easily download all the schema for GitHub using below link: https://github.com/CodersArts/database

MongoDB is a document database designed for ease of development and scaling. A record in MongoDB is a document, which is a data structure composed of field and value pairs. MongoDB documents are similar to JSON objects. The values of fields may include other documents, arrays, and arrays of documents. For ease and better understanding of the queries in mongoDB, i’ll be comparing SQL database structure with the database structure of mongoDB(NoSQL). KEY POINTS:- SQL database consists of TABLES and NoSQL database consists of collections. Which are simply different ways of representing and storing datas. Please go through the MongoDB documentation( https://docs.mongodb.com/manual/reference/operator/query/ ) on queries before going through the project to understand the basics . Before writing queries let’s connect mongoDB atlas with our system :- 1) Download mongoDB Atlas from https://www.mongodb.com/try . 2) After installing mongoDB Atlas, open it and connect it with the required PORT or connect it with the default PORT(27017) by clicking on connect. 3) Create a new database and create a new collection inside of that database by selecting the CREATE DATABASE and entering name of database and collection. 4) For this project import an existing dataset by clicking the IMPORT option under collection or you can add data manually. 5) After completing all the steps you are ready to start writing queries in the mongoDB atlas itself and later we’ll show how to write queries on any other terminal such as CMD prompt. 6) Here I have downloaded the dataset from, http://grouplens.org/datasets/movielens/ . Use the small dataset (ml-100) from the category MovieLens Latest Datasets section Getting Started with Queries : 1. Generate a list of movies that have “Adventure” as a genre. Hint: Simple queries like the above one could be written directly on the options bar given above the collection, then click on the find option to run the required query.In the above query we are finding the genres that consist of the adventure word in it. 2. Generate the movies that have been categorized into more than 2 genres. Hint: For solving this query we checking if the genres field of each document consist of “|” in it. If it consist of “|” that shows it has more than one category under genres. 3. Generate a list of movies that have the “Children” genre and a user rating > 3. Hint: In the above query we are using two collections, movies and ratings. So before writing any query we have to join the two tables and then write the required query. Note that for writing multiple queries aggregate keyword is being used (i.e. db.movies.aggregate([ ])), and in mongoDB Atlas you can directly do it using the aggregation tab mentioned on top. And for different queries under aggregation use the boxes given on the left and the result will be displayed on the right. You can select the queries from the dropdown as shown below 4. Generate all users whose average rating across the movies they have rated is greater than 3 5. What are the genres that appear in movies that are rated greater than 4? 6. Which Star Wars movie has the highest average user rating and what is the average rating? 7. A. What is the average rating of all movies with a date of 2008 in the title? 7.B. What is the average rating of all movies with Star Wars in the title? Try to solve this on your own if you face any issue go through the solution given below. Run on CMD NOTE: TO RUN THE FOLLOWING QUERIES ON COMMAND LINE TERMINAL FOLLOW THE GIVEN STEPS, 1) Open CMD prompt. 2) Change the current directory to the directory where you have installed mongoDB using (cd) command. E.g: cd C:\Program Files\MongoDB\Server\4.4\bin After changing the directory run the mongoDB server by typing the keyword (mongo) in terminal and you’ll get the given response Contact Us to Get solution of these queries or other MongoDB Project Related Help at affordable price then you can contact us at: contact@codersarts.com

INTRODUCTION : - Weather forecasting is the application of current technology and science to predict the state of the atmosphere for a future time and a given location. People can download thousands of weather apps on Apple App Store or Android Play Store nowadays. Those apps show about present weather information and weather forecasts, with sleek and gorgeous interfaces. It seems it’s unnecessary to design more weather applications, but I designed new one few days ago. Problems As I told you above, people can get various kinds of weather forecast apps. But those apps are all the same thing, except their design elements like color, icons, etc. Basically, it’s not a big problem. Their main purpose is to inform how the weather like today or this week is. However, research shows that there are still some problems like: 1. Users easily forget to check today’s weather. Imagine you have date at night with your friend, without knowing the rain is coming…. Even if people checked for today’s weather forecast yesterday, It’s too easy to forget that (how’s the weather like today) after they wake up! 3. For sure, those applications are beautiful. But it’s still bothersome to check today’s weather forecast every morning, right after you woke up. 4. Some weather applications notify users about today’s weather forecast, but it’s kind of somewhat annoying thing to get push notification everyday morning when they’re still on bed. Even when you don't want to be notified! More than 85% of people I surveyed experienced to forget to take their umbrella before they go outside, even though they checked the weather forecast already. I guess everybody has an experience like this once before, ‘Do I need to take my umbrella today…?’ in front of his/her front door, just before open the door to go outside, turn on smartphone… launch weather application… check if it’s rainy today… and decide to take it or not. But what if he/she totally forgot to check the weather forecast? When I took this project (to design any weather application) as an assignment, I decided to design a weather “Alarm” application — Weather that notifies users about weather events only they want to be notified, not the same application that people usually can get on store. Let's get started! #1. Observation Goal & Challenge I wanted users not to launch app often. When users launch this app for the first time, they set settings like what weather events to be notified like ‘snowy’ or ‘cloudy’, and what time and days to be notified. That’s it! When setting finished, users don’t need to launch this app again until they want or need to change notification settings. Job Stories Additionally, I wrote some Jobs to be done lists to design more useful product and make it from user’s perspective. When I woke up late for the work, I want to be notified in advance about specific weather events, so I can prepare with that even I don’t have much time to check how the weather like today. When I’m too lazy that it’s bothersome to check the weather with my smartphone on every morning, I want to be notified about today’s weather only it’s rainy outside, so I can prepare my umbrella without forgetting and get additional minutes on my bed. When I set an alarm at specific time like before I go to my work, I want to be notified about the events I want, not every alarm how’s the weather like today, so I can avoid to get notification everyday even if it’s sunny(that I don’t need to be informed). #2. Ideation Main purpose This app’s main purpose is to notify users about the weather information that only they want to be notified, on time they selected. This can save their time, makes them to get ready with specific weather events without checking whole weather forecast. With that way, even if users forgot yesterday's weather forecast or forget to check today's weather forecast, App will notifies users when if there are specific weather event that user's want to be notified. Brainstorming Here’s simple user flow about this application: 1. User downloads and launches this app. 2. User sets an alarm of weather events he/she wants to be notified. 3. User gets notification based on the settings. For example, if users selected that they wants to get notification when it’s rainy or windy, push notification pops up on the time when user sets, only when it’s rainy or windy. I wanted to keep this application as simple as possible with minimum depth, so I focused only for the one process: to set an alarm. No other function was added. Just like the example above, user gets push notification based on his/her weather alarm settings. In the case above, user sets an alarm for 9AM, Monday if it’s rainy. What if it’s not rain on Monday? No alarm pops up! #3. Rapid Prototyping Lo-Fi Prototypes 1. On the main screen, simple introduction and launcher icon pops up before user get started with “Start” button at the bottom of the screen. 2. On “Select weather type” screen, users can select what kind of weather events they want to be notified. Selected weather types are shows up at the top of the screen as weather icons. 3. On “Set time” screen, users can set what time to be notified with time picker and date picker. On the last screen, this app informs users that everything has finished. If users want to change settings of alarm they set, simply tab the “Alarm Settings” button at the bottom of the screen. This makes users to iterate one step from screen 2 to screen 3. On "Select weather type" screen, I did not give many options. Notifications for ordinary (e.g., sunny) weather on a smartphone that already has many push notifications will only interfere with other more important notifications. I only wanted to use push notifications for important weather events that require attention, such as having to pick up an umbrella or wear a thick coat. That is why I restricted the selection of weather events on the "Select weather type" screen. In addition, if there are too many options, users will spend much more time to choose. The choices that come out from those ideas are as follows: · Snow / Rainy · Thunderstorm · Swelter · Gale · Sudden Cold · Fog / Cloudy · ​​​​​​​All Above Improvements Usability Testing Based on the Lo-fi prototypes above, I had some usability tests with my friends who were not designers to prove usability of this application. Examples below are about some pain points I’ve notified during user testing. #4. Validation & Iteration Based on Feedback With improved design above, I had one more user testing with other testers. The table below shows the result of second user testing with redesigned wireframes. If user can perform specific mission (pain points) without any struggle, I recorded it as ‘succeeded’. #5. Output Hi-Fi Prototypes After some usability tests, I fixed and redesigned some screens and details based on the feedback from the tests. Based on the settings that user set on, push notification pops up on user’s smartphone. In this case, user selected that he/she wants to be notified only when it’s [Snow/Rainy], [Swelter] or [Gale]. When it’s [Snow/Rainy], [Swelter] or [Gale] on every Monday, Tuesday and Thursday, push notification will pops up at 9AM. Once users set their alarm, they don’t need to launch this app again until they need to change the alarm’s setting. CONCLUSION : - So, we conclude: in order to create a weather app and succeed, it's important to think through the logic of the program and develop a strategy of distinguishing from competitors. After all, such meteorological services are basic Android & iPhone weather apps, and you should do your best to attract the user. If you want to build your own weather app from scratch, we’re more than happy to help you. Our team employs only experienced and skilled specialists who'll implement your idea with pleasure and inspiration. T H A N K Y O U ! !

File Name rubyElseIf.rb #!/usr/bin/ruby marks = 90 if marks >= 90 puts "Grade A+" elsif marks >= 80 puts "Grade A" elsif marks >= 70 puts "Grade B" elsif marks >= 60 puts "Grade C" else puts "Pass" end How to run: ruby rubyElseIf.rb Output: Grade A+ How to Use Multiple Conditions You can do this by using the && (AND) operator: if name == "David" && country == "India" #statement 1 ----------- #statement 2 ----------- end You can also use the || (OR) operator: if age == 10 || age == 20 #statement 1 ----------- #statement 2 ----------- end