Due date for this assignment: 2024-02-04, 23:59 IST.You may submit any number of times before the due date. The final submission will be considered for grading.Note: This assignment will be evaluated after the deadline passes. You will get your score 48 hrs after the deadline. Until then the score will be shown as Zero.1 pointConsider the three relations given below.Note that the primary keys are underlined.employees (employee_num, employee_name, contact_num, salary)taskAssignment (employee_num, task_num, task_duration)tasks (task_num, location)Select the list of possible foreign key(s) for the given relations.employee_numemployee_num, task_numtask_numtask_num, task_duration2 pointsUsing the table Students, choose the correct SQL statement that will return the resultant table given in Figure 2.SELECT Age, Country, COUNT(*) FROM Students GROUP BY Name;SELECT Age, Country, COUNT(*) FROM Students GROUP BY Age, Score;SELECT Age, Country, COUNT(*) FROM Students GROUP BY Age, Country;SELECT Age, Country, COUNT(*) FROM Students GROUP BY Score, Country;2 pointsUsing the table Students, choose the correct SQL statement that will return the resultant table given in Figure 4.SELECT Age, Country FROM Students ORDER BY Score ASC;SELECT DISTINCT Age, Country FROM Students ORDER BY Age ASC;SELECT DISTINCT Age, Country FROM Students ORDER BY Score DESC;SELECT DISTINCT Age, Country FROM Students ORDER BY Age DESC;3 pointsBased on the data given in the table in Figure 5,Identify the appropriate query to find the city having minimum rainfall.SELECT cityFROM weatherReportHAVING rainfall = MIN(rainfall);SELECT cityFROM weatherReportWHERE rainfall = MIN(rainfall);SELECT t1.cityFROM weatherReport AS t1, weatherReport AS t2WHERE t1.rainfall < t2.rainfall;SELECT DISTINCT cityFROM weatherReportEXCEPTSELECT DISTINCT t1.cityFROM weatherReport AS t1, weatherReport AS t2WHERE t1.rainfall > t2.rainfall;

What option below did the syllabus tell you about late work?Group of answer choicesIf you do not submit an assignment or graded quiz by the due date, that assignment or quiz will automatically be given a score of zero. If you choose to submit work late, you may still receive points for that late work.Activities are accepted via emailThere are some extra credit journals listed in modules that you may complete to boost your score or to learn more about the various topics.If you fail to meet a stated deadline, your score for that particular activity will be reduced by 60%.

Assignment – STAT8061 This is an independent assignment. Each student is responsible to maintain the integrity of their own work. Sharing/Copying/Crowdsourcing will result with academic penalties. STUDENT INFORMATION Present this assignment using MS Word/PDF for the report and include the Excel file with all tabs created. Each assignment must be upload via the EConestoga portal by the due date/time. LATE SUBMISSIONS: Late penalties will be applied immediately past the deadline Late submissions received will result in the following penalties to your grade for the assessment: o 1 day late - 20% cumulative penalty o 2 days late - 40% cumulative penalty . Assignments later than two (2) calendar days will not be accepted and a grade of zero (0) will be applied Academic Integrity: This assessment must be completed individually. All assignments will be scanned to detect plagiarism and use of generative AI. -All work must be your own and must be written in your own words with sources properly cited. Sentences and paragraphs copied directly from other sources will be processed as Academic Integrity offenses for Plagiarism. -Use of Generative AI, including Co-Pilot, is not permitted in any capacity for this assessment. (*modify and specify parameters when applicable). -Students are responsible for maintaining security of their work and not sharing their work with any other students. -Conestoga’s Academic Offences Policy will be enforced Total mark out of 100. SCENARIO: 1. (15 points) Report format (Introduction to assignment, content page, raw data, answers to all questions with supporting calculation/functions etc., conclusion, proper formatting and spacing etc.). Inclusion of the supporting EXCEL file and also the WORD/PDF file containing the report. 2. Pick your own sample-data for students’ weight (lbs) from two classes (Class 1, Class 2). It is assumed that both Class1 and Class 2 contain 400 students each. a. (10 points) Guidelines for picking raw-data: i. Create continuous data between 100.99 lbs to 179.99 lbs (2nd last digit of all weights should be same as of your section number. For example for section#1 - 125.18, 167.12, 134.10 - for section#3 - 160.31, 154.39, 179.35 - and so on ii. Sample-1: size of 52 to 58 students from class-1 (400 students) iii. Sample-2: size of 46 to 50 students from class-2 (500 students) iv. Keep one-gender’s total between 30%-45% and the other’s 55%-70% in both classes. Gender ratio cannot be same for both samples. v. If you were to create this sample data (from the classes that contain 400 students each) - explain the sampling method (for sample-1 and sample-2) that you would use to create these samples. b. Include your raw data just after “content” page in your report 3. Answer the below questions in a report form. Include all relevant graphs/methods/calculation/rationale etc. in a sequence with your answers. a. (5 points) Is the mean weight of male students in both samples the same? b. (10 po

🎓Final SubmittedGreat work. You successfully submitted a final for Assessment 4: Leadership Portfolio. A PDF copy of your work has been attached in this email 📎. Here’s some important information: ASSIGNMENT:Assessment 4: Leadership Portfolio SUBMISSION TIME:Sun 5th Nov at 9:20 PM

W14 Assignment: Outcome Assessment Mark as doneDue Dec 14 by 9:59am Points 20 Submitting an external tool Attempts 0 Allowed Attempts 1Assignment DescriptionYour individual responses to this survey will be anonymous—please be honest and candid with your answers. You will receive full points in Canvas upon the completion of the survey.Please check your grade page in Canvas for this assignment after completing the survey if you have questions about receiving credit for your participation. Sometimes the assignment may not be marked as completed but you will still receive credit if you see points on your grade page.If you receive an error message when selecting the link, try any of the following:Try to take the survey on a different browser,OR, clear the cache Links to an external site. on your browser,OR, try to take the survey while in incognito mode, Links to an external site.OR log on to a different computer to complete the survey.Any of these steps should resolve the issue. If the issue isn't resolved by trying the steps above, contact [email protected].

CS304 – Object Oriented Programming Assignment No.1 (Graded) Maximum Marks: 20 Instructions Due Date: 29 April 2024 The purpose of this assignment is to give you hands-on practice. It is expected that students will solve the assignment themselves. The following rules will apply during the evaluation of the assignment. ● Cheating from any source will result in zero marks in the assignment. ● The submitted assignment does NOT open or the file is corrupted. ● No assignment after the due date will be accepted. ● Students can submit HTML, Images & Plain text only in this inline Mode. You may also insert an image file/table. ● DOC/pdf File uploading option will not be available) in inline assignment submission. Uploading Assignment Instruction Follow the given instructions to submit an inline assignment. ● You can use MS Visio/ MS Paint for drawing the Class Diagram etc. ● Students can insert the images in the following formats. ● Images and tables can be inserted using the following highlighted option in the interface. Objective & Learning Outcome Objectives: The objectives of this assignment are to: • Identify the main objects (entities). • Find the necessary attributes and functions associated with each object. • Identify the relationships among objects. • Construct a comprehensive class diagram. Learning Outcomes: After completing this assignment, students will be able to: • Develop a UML class diagram. Question (20 Marks ) Scenario: A freelance marketplace is an online platform that connects freelancers with clients who need specific projects/jobs completed. These platforms serve as intermediaries that help both parties find each other, and ensure the secure exchange of services and payments. On the freelance marketplace, there can be two types of users: one is a client who posts the jobs or projects, and the other is a freelancer who bids to complete those projects. After winning the project, freelancers complete the project and submit it. After evaluating the project, the client approves the project, and then payment is released to the freelancer. Based on the above scenario there are the following key features of a freelancing platform: 1. Freelancers create profiles that include their skills, experience, and portfolio of work. 2. Clients post projects or job descriptions, mentioning the skills required, project timelines and budget etc. Freelancers can then decide if they wish to apply or bid for the project. 3. A freelancer can bid on the project. Clients then review these bids and select a freelancer based on factors such as price, experience, and previous reviews etc. 4. Payment may be released to the freelancer only after the client approves the