Computer Science Projects

Martin Lemieux Budget Analysis Martin Lemieux is interested in using Microsoft Excel to create a personal home budget for himself. He has provided you with his information for six months so you can help him get started with his budget spreadsheet. He would like to see how much he spends each month and how much he spends for six months for each expense category. He also wants to know how much money he will have left over if he takes a new job that generates more income. Creating the spreadsheet Start Microsoft Excel, start a new Blank workbook and then type Martin’s Budget in cell A1. Save the spreadsheet as Tutorial-1_Last Name_Personal Budget.xlsx. (Replace “Last Name” with your last name.) In cell B2, type January, then use the fill handle to enter the months from February to June. Enter Total Expenses in cell H2. Starting in cell A3, enter the labels and values shown below, resizing column widths as needed. Select the range B4:B14, then use the fill handle to fill the r...

Program Description Write a program that reads positive numbers (integers) and stores them into an array. Write a method to prompt for the input values. (sentinel terminated) Write a method to print the array. Write a method that returns the value of the smallest number. Write a method that returns the value of the largest number. Write a method to find the location of a number (array index + 1) Write a method to compute the average of the numbers in the array. Write a method to output the results. The input prompt example: Enter at least 10 unique positive numbers (integers) terminated with a sentinel value (-1) Expected Output Amount of numbers read: 10 Numbers read: 12, 33, 41, 1, 4, 10, 7, 21, 66, 50 Smallest number was 1 in location 4 Largest number was 66 in location 9 Average was 24.5 Output Screenshot Download solution now Buy now CONTACT DETAILS For any other questions or other tasks please feel free to contact me via email: mhassnainjamil@gmail.com via WhatsApp: +92-324-70421...

Program Description Write a program that reads positive numbers (integers) and stores them into an array. Write a method to prompt for the input values. (sentinel terminated) Write a method to print the array. Write a method that returns the value of the smallest number. Write a method that returns the value of the largest number. Write a method to find the location of a number (array index + 1) Write a method to compute the average of the numbers in the array. Write a method to output the results. The input prompt example: Enter at least 10 unique positive numbers (integers) terminated with a sentinel value (-1) Expected Output Amount of numbers read: 10 Numbers read: 12, 33, 41, 1, 4, 10, 7, 21, 66, 50 Smallest number was 1 in location 4 Largest number was 66 in location 9 Average was 24.5 Output Screenshot Download solution now Buy now

Case study Re-read the description of the Pet Net case in Assignment 1 if you need to refresh your memory. Elizabeth and Jeremy Trellis are pleased with your work so far and asked you to go on to implement your design. They have some additions to the original specifications that you should note: They would like to extend the services that participants can offer to include dog walking, dog grooming and dog training. These services would operate in the same way as the boarding, with the services being offered and bookings made between owner and service provider. Potential dog walkers would state whether they are available for regular walks or one-off (or both), and whether they are available for long (>5km) walks. Potential dog groomers would state what sort of cuts they can provide. Dog trainers would describe whether they offer basic, intermediate or advanced training. In each case the dog walker/groomer/trainer states the price(s) for the service(s) they offer. Of course, a...

Analysis of Student Payments Mountainview Language School in Denver, CO, is a small school that provides language training in English, Spanish, and French to students from all over the world. The school keeps track of its student records in Excel. You’ve been asked to work with the current spreadsheet and improve it so that information and issues can be analyzed and tracked. You use advanced IF functions and a VLOOKUP table to calculate data related to student payments, and then you use the COUNTIF, SUMIF, and AVERAGEIF functions to analyze the payment data. Start Excel and open Tutorial 7_StudentAccounting.xlsx. Save the spreadsheet as Tutorial 7_Last Name_StudentAccounting.xlsx. (Replace “Last Name” with your last name.) In cell K4, add a new column called Owing. Note that the new column is formatted the same way as the rest of the table because the data is contained in an Excel table. In cell K5, enter an IF function that enters “Owing” in cell K5 if the value in cell J5 (Ba...

1. Introduction Operating Systems have a need for extremely compact data structures, as often these need to be stored wholly in memory. Examples of this are free memory lists, page tables and disk space bitmaps. This  practical Case Study will refresh your knowledge of bit operations, necessary to manipulate such compact data structures. We will use a simple variant of the card game poker as the inspiration for our compact data structure. In this exercise, you will model a deck of playing cards as a bit 1eld. Only six bits arerequired to fully describe a card, two for the suit and four for the value. An extra bit as been added to the structure to encode the colour of the card. A second bit 1eld will be used to store the number of pairs contained in a hand. Read this section fully before attempting any of the exercises. These instructions contain some background information, the task to perform, sample code and some system documentation extract. 2. Structure of the bit 1elds ...

A Technology Budget SecureWorks Inc is a small computer security contractor that provides computer security analysis, design, and software implementation for the U.S. Government and commercial clients. SecureWorks competes for both private and U.S. Government computer security work by submitting detailed bids outlining the work the company will perform if awarded the contracts. Because all of the work involved computer security, a highly sensitive area, almost all of SecureWorks’ tasks require access to classified material or company confidential documents. Consequently, all of the security engineers (simply known as “engineers” within the company), have U.S. government clearances of either Secret or Top Secret. Some have even higher clearances for the 2% of SecureWorks’ work that involves so called black box security work. Most of the employees also hold clearances because they must handle classified documents. Leslie is SecureWorks’ human resources (HR) manager. She maintains all...

A Technology Budget Tally is a start-up website development company located in Seattle, Washington. The company currently has 7 employees and is looking to hire 6 new employees in the next month. You are in charge of purchasing for Tally. Your first task is to purchase computers for the new employees. You want to look into 3 different manufacturers: Dell, HP, and Apple. Your budget is $550,000 to purchase the following: New computers for all employees – for old and new, 2 monitors each. 2 high-end servers  5 color printer/scanner combination Desks for all the new employees (not manufacturer specific, just make sure the desk will hold the computers and monitors. Software: (Not necessarily manufacturer specific, just make sure it is compatible with the brand of computers etc you are purchasing). Operating system for the computers Visual studio professional Virus software MS office SQL Server Database Keep in mind this is for a business and not for home usage. Look ...

Modify your existing file server to support sockets and accept an infinite number of incoming connections. Get Project Solution by contacting us - via WhatsApp: +92-324-7042178 - via email: codelogixstudio@gmail.com Download Now Buy now

Scenario: You are the database designer and developer for a donut shop that wants to create a smartphone application where customers an order donuts. First, you will design a normalized entityrelationship (E-R) logical database model to store data related to the customer, donuts, and donut order. Next, you will create four tables with primary and foreign keys that are derived from your ER model. Once the tables have been built, then you will create views and indexes to protect and fine-tune query performance. You will populate each of the tables with sample data. Finally, you will create both a simple “select-from-where” (sfw) query and a complex join query to produce meaningful reports on individual donut orders and summaries to determine which donuts sell the best. Requirements: A. Construct a normalized model to represent the donut shop smartphone application database that supports the scenario above by doing the following: Using the attached “Sales Order Form” (unnormalized ...

Relational Algebra A database records information about athletes competing at the Olympics. An athlete competes for a particular country in one or more events. Events take place at a scheduled day and time in a particular venue. The result (rank) is recorded for all athletes in the final of the event. The medal (gold, silver or bronze) is also recorded for the medal winners in the event. Note that we are not considering team sports or heats in this example – only individuals competing in the finals. The schema for this database is as follows: (Note that primary keys are shown underlined, foreign keys in bold). ATHLETE (AthleteNo, AthleteName, CountryName) COUNTRY (CountryName, NumberOfCompetitors) EVENT (EventName, ScheduledStart, VenueName) VENUE (VenueName, City, Capacity) FINAL (AthleteNo, EventName, Rank, Medal) Provide relational algebra (NOT SQL) queries to find the following informaList the name and country of all athletes. List the event name and scheduled start...

Database Technology Repeat CA ERD (Entity Relationship Diagram) i. Identify each of the entities ii. Identify2-3 attributes for each entity with a key attribute iii. Name the relationships for each of the binary pairs iv. Identify the degree of relationship for each of the binary pairs v. Decompose any many to many  relationships vi. Draw the completed Entity Relationship Model A restaurant manager wishes to set up a database to record the details of its customers, reservations for tables in the restaurant and the employees assigned to tables. Screenshot For each customer the database will record -- a customer number (unique), name, address and phone number. The details to be recorded for each table include - table number (unique), capacity. Customers make reservations for tables. The requested time and date of the reservation is recorded along with a unique reservation number. Each reservation is made by one customer and books one table. A customer will make a number of rese...

Goal: In this assignment, we want to implement the operational semantics of rst order languages and get a feeling for their importance for databases. Problem Statement: For this goal, you write an interpreter for formulae of the rst order language. The formulae used here have a free variable and are used to query a database that is given as part of the input. The query result is comprised of those values for the free variable that make the formula true. In order to make the interpretation of the formulae easier, we represent formulae in this assignment not in the in x notation that we use otherwise but in Polish notation, which eliminates parentheses and the need for operator precedence, and also makes the processing of the expression tree easier. As Boolean operators we use only & ; _;:. To make it possible to use predicates without parentheses, we furthermore require that every predicate name is used only for a single arity, i.e. if "mail" is used for a ternary predicat...

Shopping Cart Application: Using the techniques you learned in Section 29.8.2, create a simple shopping cart application. Display a list of books as an h:selectOneRadio element. When the user submits the form, store the user’s selection in a @SessionScoped managed bean. Allow the user to return to the list of books and make additional selections. Provide a link to view the shopping cart. On the shopping cart page, display the list of selections the user made, the price of each book and the total of all books in the cart. Code Snapshots: Output Screenshots: Home Page: Shopping Cart Page: Buy now CONTACT DETAILS For any other questions or other tasks please feel free to contact me via email: mhassnainjamil@gmail.com via WhatsApp: +92-324-7042178 via skype: hassnainjamil1

Background The arithmetic expressions considered in this project consist of non-negative integers, operators "+", "-", and "*", and parentheses "(" and ")". Arithmetic expressions are usually written using the infix notation, in which operators appear between the two operands on which they act (e.g., "2 + 2"). The evaluation of expressions in infix notation is done according to the standard order of operations: multiplications must be done first, from left to right, then all additions and subtractions, again from left to right. Parentheses can be used to change the order in which operations must be performed, e.g., the expression inside the innermost parentheses must be evaluated first, etc. Since each of the considered operators takes exactly two operands, such an arithmetic expression can be represented as a proper binary tree whose internal nodes are associated with the expression's operators and whose leaves are associ...