Computer Science Projects

Coach Café The Coach Café is a small neighborhood café that serves vegetarian breakfasts and lunches. The owner of the café, Keith Watson, started the café with $50,000 of his own money. Now that he’s up and running, he realizes that he needs additional financing. His parents have offered to loan him an additional $50,000 to be repaid within five years. Keith needs to analyze the loan payments and terms to ensure he can make the payments required. He has started a workbook and asks you to complete a Loan Analysis and Amortization Schedule with data related to the loan. Start Excel and open Tutorial 8_Coach CafeLoan Analysis.xlsx. Save the spreadsheet as Tutorial 8_Last Name_Coach CafeLoan Analysis.xlsx. (Replace “Last Name” with your last name.) In the Loan Analysis worksheet, in the range C7:J10, enter or calculate the loan analysis data you will use as the basis for additional calculations. Kevin wants to borrow $50,000 over a period of 5 years and make 12 payments each year. ...

Part 1. Entity-Relationship modeling A veterinary practice called NI-Pet provides health care for domestic pets in Northern Ireland. You have been approached by its director for the design and implementation of a relational database system that will assist in the efficient running of the practice and improve resource management and information sharing within the practice. The requirement collection and analysis phase of the database design process provided the following requirements: The practice has many clinics located in the main cities of the country. Information stored on each clinic include the clinic number, clinic address (consisting of the street, city, and postcode), and the telephone and fax numbers. Each clinic has a number of staff (for example, vets, nurses, secretaries, cleaners). The clinic number is unique throughout the practice. A staff member is allocated to one clinic and may or may not have an employment history or dependents. Some more experienced staff may a...

The company has 7departments: Sales, Finance, HR, Support, R&D, Design and IT. There are 50 employees within the various departments.  The company has some large clients, including Sony, HP, Dell, Apple, Novell, Oracle and Sun.  The company products include 5 different PCI components, 3 different infra-red scanners and10 different Bluetooth devices.  Salary and sales information should be in the database as well. Once the database has been created, you need to pull relevant information for Management. Management would like an overview of sales between 10 000 and 30 000 and also between 40 000 and 200 000.  They also want to know which companies are purchasing products for more than 250 000 per month and which salesmen are linked to those clients. This database is very important to the company and therefore you need to ensure that there is redundancy. This means that the company needs at least 1 Master database server and three slave servers. Since the co...

Task Specification You are required to finish all the following 4 tasks: Task 1 (SQL): This task requires you to write Oracle SQL DML statements. For each of the following, give the Oracle SQL DML query which fulfils the request: a) List the IDs and names of all sandwiches, sorted alphabetically on the sandwich name.  b) Return the number of stores in Bristol (i.e. where the postcode of store starts with BS). c) For each pending (has not been completed yet) order, list the OrderID, the sandwich name used in the order and the name of the bread used in the order. The result need to be sorted by order date, most recent first in the first instance and then by sandwich name alphabetically. Task 2 (PL/SQL) (3 Marks): This task requires you to write Oracle PL/SQL code: a) Write a stored procedure that receives as input 2 dates representing start and end of an interval, and displays the IDs and order dates of orders placed in that time interval, sorted according to the date of ...

Requirements Our Bank Simulator will consist of information about customer Bank Accounts. I have simplified the requirements for this assignment to set boundaries on your time. The Bank Simulator consists of a dynamically allocated array of BankAccounts of two types – either Savings accounts or Chequing accounts. A bank account consists of an account number (between 100 and 999), customer and a double balance. A Savings account has two additional fields - a rate of interest and a minimum balance amount (at the end of the month, the customer is given interest based on their account balance as long as the account balance is more than the minimum balance amount). A Chequing account has one additional field compared to a Bank Account – that is the monthly fee that is deducted. The Simulator will give the user – presumably the user is a bank employee – a menu of choices of actions (ie this is not simulating a customer using a bank machine). These actions will include adding a new Ba...

1 Overview of the Assignment The assignment builds on the BrizzleSarnies database you designed in Assignment 1. The physical database schema which you must use for this assignment as well as some sample data can be found in the associated BrizzleSarnies.sql script which can be downloaded from Blackboard (next to the assignment specification). The tables also exist under the SHARED schema on the university’s Oracle server. Note that you only have SELECT access on the tables in the SHARED schema so you cannot update the tables. To test tasks which require updating the tables, you have to run the associated script in your own schema. The logical schema of the database can be found in Appendix A. Note that when marking your work, we will be using the same database schema as in BrizzleSarnies.sql, so you are not allowed to alter the structure of the tables. The assignment requires you to finish 4 tasks related to the implementation, testing and evaluation of a database application, and ...

You need to create a company database. The company has 7departments: Sales, Finance, HR, Support, R&D, Design and IT. There are 50 employees within the various departments. The company has some large clients, including Sony, HP, Dell, Apple, Novell, Oracle and Sun. The company products include 5 different PCI components, 3 different infra-red scanners and10 different Bluetooth devices. Salary and sales information should be in the database as well. Once the database has been created, you need to pull relevant information for Management. Management would like an overview of sales between 10 000 and 30 000 and also between 40 000 and 200 000. They also want to know which companies are purchasing products for more than 250 000 per month and which salesmen are linked to those clients. This database is very important to the company and therefore you need to ensure that there is redundancy. This means that the company needs at least 1 Master database server and three slave servers. S...

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 ...

Founded in 2002, Analytics Software provides innovative search software, accessibility testing software, and usability testing software. All serve as part of its desktop and enterprise content management solution for government, corporate, educational, and consumer markets. The company’s solutions are used by website publishers, digital media publishers, content manager, document managers, business users, consumers, software companies, and consulting companies. Analytics Software Instructions: 1) Open Tutorial 6_InDepthAnalysis.xlsx. 2) Save the spreadsheet as Tutorial 6_InDepthAnalysis_Last Name.xlsx. (Replace “Last Name” with your last name.) Weekly Analysis Tab 3) Create a new worksheet tab and name it Weekly Analysis 4) Copy the table provided in Growth, Trends, Forecasts worksheet. 5) Create two pivot tables in the Weekly Analysis worksheet. 1 pivot table using Date and Sales Volume Group by 7 days so you have a sum of Sales Volumes for each week.  1 pivot table...

Recently it was announced by the Government of Cicada that Tulips would be legalized for consumers and businesses. Your company has been hired by the Government of Cicada to design the database to be used for monitoring this new industry. As the resident database designer at your company, you have been assigned to interviewing Mr. Colin Mochrie, the Government of Cicada’s representative in charge of the information infrastructure projects surrounding the new legal Tulips industry. Based on the transcript below, develop the complete ERD for this database with all relevant labels. Using the attached excel file, perform a full normalization of the sample data with all steps and relevant labels. Note: the flat file may be incomplete, so not all the data is represented in it.  Interview Transcript Nice to meet you Mr. Mochrie, thank you for taking the time to do this interview with me. It will really clarify things and help gain an understanding of the functional requiremen...

Dog Registration Database Objective Track data for dogs, owners and violations Create an ER diagram Create searches and output using relational algebra Background The Yorkie’s Dominance: We Analyzed Every Dog Registration in New York, New York Times, February 10, 2018. Database Design Your design must track the at least following categories Dog owner information including name, address and email. Dog owners can own many dogs. Dog information including dog name, breed, gender, weight, age, photos and owner. Track current and previous dog owners. A dog can have many photos. Dog owners can receive tickets with violations including dog, owner, violation type, fine, date of violation and current status of violation. One ticket can include many violations. Identify and create the following in your database design Entity Relationship (ER) diagram Relations Degree Primary and foreign keys Domains Relationship between entities Relationship type Attributes Cardi...

Recently it was announced by the Government of Cicada that Tulips would be legalized for consumers and businesses. Your company has been hired by the Government of Cicada to design the database to be used for monitoring this new industry. As the resident database designer at your company, you have been assigned to interviewing Mr. Colin Mochrie, the Government of Cicada’s representative in charge of the information infrastructure projects surrounding the new legal Tulips industry. Based on the transcript below, develop the complete ERD for this database with all relevant labels. Using the attached excel file, perform a full normalization of the sample data with all steps and relevant labels. Note: the flat file may be incomplete, so not all the data is represented in it.  Interview Transcript Nice to meet you Mr. Mochrie, thank you for taking the time to do this interview with me. It will really clarify things and help gain an understanding of the functional requiremen...

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

The Voice London Show Setup. In Part 2, based on a given ER diagram and a set of requirements, you will implement a relational model for a television talent show named TheVoiceLondon. Then, you will have to perform different data manipulation and retrieval operations on the database. On KEATs you will find a .zip containing template SQL files to edit for your Part 2 submission. Requirements. A television channel has decided to create a simple database to register payment information about its most successful show ‘TheVoiceLondon’. In this show, there are contenders that compete to represent the UK in Eurovision. These contenders are coached by famous artists (namely the coaches). Contenders can be formed by a group of participants or a single participant. Both coaches and participants are paid based on the number of shows they attend. For each coach and participant, the database sores their id, name surname, date of birth, phone, gender and daily salary. For each contender, the d...