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

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

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

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

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

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

On February 18, 2001, Robert Philip Hanssen was arrested and charged with committing espionage on behalf of the intelligence services of the former Soviet Union and its successors. He pled guilty to 15 counts of espionage on July 6, 2001 and was sentenced to prison without the possibility of parole. Hanssen is considered the most damaging spy in FBI history. At the time of the arrest at a park in Vienna, Virginia, Robert Philip Hanssen, age 56, was clandestinely placing a package containing highly classified information at a pre-arranged, or “dead drop,” site for pick-up by his Russian handlers. Hanssen had previously received substantial sums of money from the Russians for the information he disclosed to them. Hanssen was charged in a criminal complaint filed in Federal court in Alexandria, Virginia, with espionage and conspiracy to commit espionage, violations that carry a possible punishment of life in prison, and under certain circumstances, the death penalty. Following the arr...

United Community Bank Database Requirements The Project The United Community Bank (UCB) is a well established regional bank operating primarily in South England, but with several branches in key cities and towns in the North. The last 5 years saw the bank transform into a fully computerised bank. Keeping in pace with its philosophy of responsive customer service, UCB decided to offer online banking services to its customers. The new online banking service would fully integrate with the core banking solution already implemented at the bank. The online banking service is open to savings account customers and current account holders. The basic entity for explaining all operations in the bank is the customer. A customer may have one or more accounts in the bank spread across one or more branches. Customers open bank accounts with a specified opening balance and thereafter may either deposit funds into the account or withdraw amounts from them. For each customer the system wants to reco...

Context A tour management agency runs concert tours.  It sets up tours by bands.  On a tour, a band gives concerts at venues on various dates. Only one band goes on a tour, and a band goes on only one tour at a time.  Tours have names. A band has musicians as members.   A band also has a music style, such as “heavy metal” or “folk”. There are several tour dates on a tour.  Each occurs at a venue, on a particular date. At each date, a certain amount of money is received in ticket sales. Each venue has a cost for hiring it.  Each concert yields a certain amount from ticket sales.  The difference between the cost and the ticket sales is the profit on the concert. What a Database will be used for? The management agency wants a database about its business.  It wants to be able to find out such things as which tours it has arranged.  (Assume that all tours have finished - covering tours that are still going on is an easy extension, b...

MediRAY Chain of Pharmacies The MediRAY chain of pharmacies has decided to develop a database system to store information of their prescriptions, patients, doctors and related details . They have given the development to your company and your manager has handed over the task to you. Below are the requirements Patients and doctors are persons identified by the personal identification number. The person has address, email and phone number. Patients have patient number (the hospital and the patient number used here ), and their names, addresses, and ages must be recorded. Doctors have doctors registration number. For each doctor, the name, specialty, and years of experience must be recorded. Each pharmaceutical company is identified by name, address, email and has a phone number. For each drug, the trade name and formula must be recorded. Each drug is sold by a given pharmaceutical company, and the trade name identifies a drug uniquely from among the products of that company. If...

James River Jewelry James River Jewelry wants to expand its database applications beyond the recording of purchases and purchase awards The company still wants to maintain data on customers, purchases, and awards, but it wants to include other data as well. Specifically, James River Jewelry wants to record artists and styles and keep track of which customers are interested in which artists and styles. James River Jewelry sells most of its jewelry on consignment, so the company does not pay the artist of a piece of jewelry until it is sold. Typically, the company pays artists 60 percent of the sales price, but the terms are negotiated separately for each item. For some items, the artists earn a larger percentage and for others, they earn less. Artists and James River Jewelry personnel agree on the initial sales price at the time the item is brought to the shop. When an item has been in the shop for some time, James River Jewelry may reduce the price; sometimes it renegotiates the sa...

Project Introduction Thank you for your application for the role of Database Administrator (DBA) at OurCompany Inc.! We are currently reviewing applicants and would like to congratulate you on making it past the first round of screening. As part of our company’s hiring policies, we require that applicants for this role submit an assessment of their competencies. The assessment will comprise of the following deliverables, to be produced and returned to OurCompany within 48 hours of issuance; Database Analysis and Design - ERD During your role as DBA you will be required to perform requirements analysis to determine what type of information needs to be stored, and understand the operational needs of the database. For this assessment we have provided you with a transcript of an interview with a client, found in Appendix A. You will need to read this transcript and synthesize the needs of the database based on the client’s responses to the interview questions. Based on your underst...

Bank Corp Business Requirements BankCorp Ltd. offer Wealth Management and Investment Services to its Personal and Corporate clients. Currently, data is stored in a number of systems across the company. This leads to “double keying” and as a result inefficiencies and errors. They want to create a single database to consolidate all these details into one single source. They do not have any IT staff and they do not have the space or ability to look after any infrastructure on premise. They want you to design and develop the database only. Any data migration tasks will be taken care off in a future different project. The data model must be designed to meet 3NF (Third Normal Form) requirements. In terms of the key entities they have given you the following list: 1 Customers 2 Accounts 3 Securities 4 Associations A customer can have many accounts and an account can be secured by many securities. A customer can be associated to another customer in the bank e.g. a Property Developm...

Project Description This project came about due to a growing need for the members of Rosslare Football club to obtain information on match fixtures, results and for general club information and announcements. Since the introduction of junior teams, parents and members have requested more information regarding the club. The new system will also allow members and non-members to purchase club merchandise and to make donations to the club. The club chairman and the committee will oversee that all objectives and they will ensure they are met. Functional requirements The main functions of the new proposed system are: Member registration and login Inserting, deleting and inspecting members details Inserting and amending match fixtures, results and club details Altering system passwords High-Level Requirements The new system must include the following: Ability to allow both internal and external users to access the application without downloading any software Ability to i...

There are the following tasks for this project Database general concepts In your presentation/report explain the followings: What is a database? Flat file database, its advantages and disadvantages and the circumstances in which flat file database may be used giving an example Relational database, its advantages and disadvantages and the circumstances in which relational database may be used giving an example Differences between flat file and relational database Entity type and entity giving examples Attributes giving examples Types of relationships giving examples Trust dental orthodontics database design ERD & implementation The table below lists a part of dentist/patient appointment data of Trust dental orthodontics. A patient is given an appointment at a specific time and date with a dentist located at a particular surgery. On each day of patient appointments, a dentist is allocated to a specific surgery for that day. There are 5 surgeries under the management ...