CI5310 Database & UML Modelling – Assignment

Added on - 18 Sep 2019

  • 7

    pages

  • 1450

    words

  • 56

    views

  • 0

    downloads

Showing pages 1 to 3 of 7 pages
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 DigitalDropbox on StudySpace.Deadline:Friday, 16th December 2016 by 11:59pm.Youmustuse the report template which can be downloadedfrom the assignments folder on StudySpace. If you do notuse 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.Plagiarismis 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 calledTravel Jabsprovides private travel immunisation throughout the UK. Thisservice is provided through various clinics located in the main cities of the UK. The DirectorofTravel Jabsis 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 Jabshas 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
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document