Computer Science Projects

Problem Statement: McNeese bookstore would like to provide online shopping service to students starting next semester. Students will be able to buy stuffs from the following categories: (1) books; (2) office supplies; (3) snacks; (4) cloths; (5) sport equipment. McNeese bookstore hires you to design a database as part of the backend server for the online service. Here are some of the basic system requirements: There are at least 20 items under each category The database needs to maintain the details of stocks such as their id, name, quantity, and category, etc. The database needs to maintain the details of customers such as their name, address, id, or payment information, etc. The database needs to be created by using MySQL, and SQL language. Some general functions in SQL language (such as how to search to an item, how to modify the quantity, etc) should be provided to McNeese bookstore as APIs so that customer can use them in the future. Get Project Solution by contactin...

Decision Tree Develop a decision table or a decision tree to describe the steps in the purchase of a book using a credit card from Amazon.com. Entity Relationship Diagram Develop ERDs to describe a small book publishing company.  You can use the methodology posted on COL as a guide to your process. Design Improvements & Issues Find a web site you think is particularly poorly designed and critique it using the principles we have discussed in class to explain what is wrong with it. Get Project Solution by contacting us - via WhatsApp: +92-324-7042178 - via email: codelogixstudio@gmail.com

A database is required for the Old Print, a web-site that specialises in books printed before 1950. While the site is open to the public, certain services are only available to members. Each member has a unique membership number (N 8 0) recorded along with their name (C), address (A), email address (S 30) and expiry date (D). A member might also have a phone number recorded (S 14). Any visitor to the site can check for what books there are copies currently on offer. Each book (offered now or in the past) has its unique ISBN (S 12) and title (S 70) recorded along with an assigned category code (S 3). For each possible category code such as 'SFI', a description (S 30) such as 'science fiction' is recorded. The book's one to many authors are identified along with its publisher, edition (N 2) and the publication date (D). Each copy of a book has a unique inventory number (N 8 0) recorded along with a price ($ 4) and the date (D) when it became available. There may be ...

Monash Library Services (MonLib) The local Monash Municipality maintains several libraries for its residents across the municipality. For each branch Monash Library Services assigns a branch code (an incremental number for each branch with the first branch using a code of 100). The branch name, address and contact phone number are also recorded. Each branch is assigned a manager. Due to the small size of some of the branches a particular manager may manage several branches. Each manager is assigned a manger id. Monash Library Services record a managers name and contact phone number. All managers are assigned one particular branch as their home branch. Monash Library Services maintain records of current loans of books to borrowers. Each borrower is identified by a borrower number and each copy of a title by a barcode number (the library may have more than one copy of any given title). When a borrower first registers to borrow books the branch where they register is recorded as their...

As an analyst what approach would you take in identifying business needs for an organization?  What type of IT projects would make good use of your skills? Why?  What advice would you give new analysts who are inexperienced and beginning the planning phase of a new project? Give at least two pointers and explain why you think it is important for a rookie analyst to know.  Requirement Gathering (Chapter 3) Which one requirement elicitation technique are you most comfortable with to use? Why?  Which one requirement elicitation technique seems least effective in your opinion? Why?  What is your opinion on use cases?   How might you make use cases work better?   Data Flow Diagrams  What do you think are the three most difficult parts to understanding DFDs?  What advice would you give a new student who is learning the DFD process?  The last element of the analysis phase describes the logical data analysis – creating...

Practical Work Week 2 In this module, you are required to design and develop a database using MySQL Workbench. This week you should: formulate a database project proposal together with one of your classmates. This proposal will be due for submission on Moodle in week 3. You are also required to submit a hard copy of your proposal in your practical class. you may use MySQLWorkbench on the college machines or install the application on your own laptop. Please note: The proposal that you submit will need to support a database with minimum of 15 tables so it is important that you choose an idea which will give you the scope for such a database design. You should use your practical hours to ask for advice on choosing a suitable idea. Practical Work Week 3 At this stage you should: use the Sakila example provided with Workbench to familiarise yourself with the operation of the DBMS. create a complete ER model in Workbench for your team project. (Min. 15 tables) create a dat...

A charter company owns boats that are used to chart trips to islands. The company has created a database to track the boats it owns, including each boat’s ID number, name, last maintained date, seating capacity, purchased year, and cost per hour used. The database also keeps information about each island, such as its unique ID, name, population, ticket price per person, and overall tour hour per trip. The database also maintains information about each captain it employs and assigns to trips, such as captain ID, Social Security number, first name, last name, street, city, state, zipcode, phone number, and date of birth. In addition, all information about each trip, including trip ID, the date that the trip takes place, and the number of people on the trip, is also kept in the database. Each trip takes only one boat, but a boat may be used for multiple trips on different dates. A particular trip travels to only one island, but an island may be visited by different trips. Each particula...

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

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

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