Skip to main content

Posts

Showing posts with the label Hardware

MediRAY chain of pharmacies database design & implementation with Queries

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

Hardware and Software Project - Uxbridge College project solution

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