Database for Travel Jabs Clinic Guidelines The work consists of the design, implementation and population of a small database system that will form the basis of the report to be handed in. The invoice does not include the details of a patient appointment (first name and last name) but the details of a patient appointment are recorded on the invoice.
| 7 pages
| 1450 words
| 283 views
Trusted by 2+ million users, 1000+ happy students everyday
CI5310 Database & UML Modelling – Coursework 1 2016/17Database Design & Development(This coursework is worth 25% of the module)Submission Date:Please submit your report via the Digital Dropbox on StudySpace.Deadline: Friday, 16th December 2016 by 11:59pm.You must use the report template which can be downloaded from the assignments folder on StudySpace. If you do not use the template, your report will not be marked. 1
GuidelinesThe work consists of the design, implementation and population of a small database systemthat will form the basis of the report to be handed in.You will be expected to work on your own and should submit deliverables arrived atindependently using your own knowledge and effort. Plagiarism is presenting somebody else’s work as your own. It includes: submitting jointcoursework as an individual effort; copying another student’s coursework; stealingcoursework from another student and submitting it as your own work. Suspected plagiarismwill be investigated and if found to have occurred will be dealt with according to theprocedures set down by the University. Please see your student handbook for further detailsof what is/isn’t plagiarism.You must meet all deadlines set. Failure to do so will result in a penalty - ALL work receivedafter this time will be recorded as LATE.2
Database for Travel Jabs ClinicGuidelinesThe work consists of the design, implementation and population of a small database systemthat will form the basis of the report to be handed in.You will be expected to work on your own and should submit deliverables arrived atindependently using your own knowledge and effort. Help can be obtained from theworkshop supervisor or other students if you are stuck. Such assistance should be strictlylimited to general advice and should not address a specific solution to the problem. Anyduplication of table design and/or data – from other students’ work - will be treated asplagiarism.Travel Jabs Clinic DatabaseA company called Travel Jabs provides private travel immunisation throughout the UK. Thisservice is provided through various clinics located in the main cities of the UK. The Directorof Travel Jabs is concerned that there is a lack of communication within the company andparticularly in the sharing of information and resources across the various clinics. To resolvethis problem the Director has requested the creation of a centralised database system toassist in the more effective and efficient running of the practice. The Director has providedthe following description of the current system.System Overview:Travel ClinicsTravel Jabs has many travel clinics located in the main cities of the UK. The details of eachclinic include the clinic number, clinic address (consisting of the street, city, county, andpostcode), email address, telephone and fax numbers. Each clinic has a Manager and anumber of staff (for example, nurses, secretaries, cleaners). Each member of staff reports toonly one manager. StaffThe details stored on each member of staff include the staff number, name (first and last),address (street, city, county, and postcode), home telephone number, date of birth, gender,job description, national insurance number and current annual salary. 3
Found this document preview useful?
You are reading a preview Upload your documents to download or Become a Desklib member to get accesss