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, but not needed.) how much a tour has made.    wh

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