Computer Science Projects

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

Scenario You are a consultant for a local IT & Networking company called ‘Uxb-Com’ which specialise in providing professional solutions to various types of companies who are looking for support for their IT infrastructure. Your work mainly involves dealing with client equipment, which comes into the main ‘Uxb-Com’ office for servicing and fixing of faults.  You can also be involved with ensuring this equipment is correctly serviced ready for re-distribution to the clients. ‘Uxb-Com’ is also actively involved in promoting employment links with the local area and part of this drive involves the development of an apprenticeship scheme; providing the opportunity for a selected group to work   in their premises and to learn about their systems and procedures in relation to PC maintenance.  Some of your work may also involve ensuring this scheme runs as effectively as possible. Task 1 - Hardware Your first task involves preparing documentation for t...