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

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

Object Oriented Programming - JavaDiv I – Batch 2“Teacher Assessment - College”Note : Marks : 251. Announcement Date: 30-11-2023.2. Due date: 06-12-2023 till 08:00 pm.3. The assignment to be done “individually” or with group of “three students” maximum.4. Assignment must be implemented in “Java” only.5. Assume data types and data, wherever it is required.6. Though viva will be at different times for different students, the submission deadline is same forall.7. No Copying / sharing of code are allowed for this assignment. If any such case identified, theoriginal author and person who has copied both will be “penalized” equally and “zero marks”will be awarded.8. Dates for assignment viva will be announced later.Task :A. Develop a JDBC project for relation “College”. Use PostgreSQL as database.B. Write a “POJO class College” for private attributes given in following table with mentioned “keyconstraints”. Constructor, getters, setters and toString method must be there.C. Create a controller class for following methods. Use SQL query only to perform operations in allmethods. Create relation using SQL query only. Enrollment number must be auto generated seriallyfor all students.1. Create student (student name, division, gender, marks).2. Print student (enrollment no). {Print specific student data.}3. Calculate grade (student name). {Marks = 75 to 100 Grade A, Marks = 60 to 74 Grade B, Marks= 40 to 59 Grade C, Marks = 0 to 39 Grade D}4. Find students by gender (gender). {Print specific data.}5. Add Bonus marks (enrollment no, bonus marks). {Add bonus marks in original marks.}6. Change division (student name). {Change division and print.}7. Print students in range (min marks, max marks). {Print selected data.}D. Create a service class for calling all above methods in “menu driven” pattern.Relation :- CollegeEnrollmentNumber (PK)Student Name(NN) Division (NN) Gender (NN) Marks (NN)… ……Mr. Akhilesh LungeFaculty

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

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;

BC220415117: SYEDA LAIBA SHAH Time Left 89 sec(s) CS401 - Computer Architecture and Assembly Language Programming (Quiz No. 1) Quiz Start Time: 06:24 PM, 30 April 2024 Question # 5 of 10 ( Start time: 06:25:48 PM, 30 April 2024 ) Total Marks: 1 Which of the following is the extension of object file? Select the correct option .exe .lst .com .asm