FIT2094 : Full Database Model and Implementation Animal Doctors (AD) - Management Assignment Help

Assignment Task:

Task:

The Animal Doctors management have indicated:
? they do not require the clinic addresses or any phone numbers to be broken down into component attributes
? they would like to be able to easily expand:
? the vet specialisations, as they employ further vets with new specialisations, and
? the types of animals, as they treat a new type which they have not previously seen
? the services which are provided during a visit are identified by a service code and have a standard service cost which must be recorded as part of the database. Every visit incurs at least one service charge. During a visit (treatment of a patient - the animal) the servicing vet may vary the service standard cost depending on their professional judgement,
? the drugs which are provided during a visit have a standard cost which must be recorded as part of the database, however like services this cost may be varied by the vet for a particular visit
? when a drug is used as part of the visit (eg. an injection that the vet gives the patient in the clinic) the frequency is not recorded (frequency is only used only for drugs given to the owner to be administered to their pet following the visit eg. a twice daily antibiotic tablet), and
? management would like a count maintained, as part of the stored database data, which indicates how many times a given specialist vet has serviced a visit in a clinic which is not their home clinic.
Animal Doctor have provided several forms, depicted below, which they make use of, showing some of the data they wish to record:
? a sample 'Pet Ownership Details' which shows pets owned by a specific owner, and the owner’s preferred vet, and
? two samples 'Visit Invoice'.

Task to complete:
1. Perform normalisation to 3NF for the data depicted in the sample AD reports. Note that only one normalisation is required for the Visit Invoice, you have been provided with two samples so you can appreciate some of the variety which occurs.

The approach you are required to use is the same approach as shown in the normalisation tutorial solution. The normalisation must be carried out form by form, beginning by you representing the document you are working on as a single UNF form and then moving through 1NF, 2NF and 3NF.

During normalisation, you must:
? Not add surrogate keys.
? Include all attributes (you must not remove any attribute as derivable)
? Clearly show UNF, 1NF, 2NF and 3NF.
? Clearly identify the Primary Key in all relations.
? Clearly identify all dependencies at the various normalisation stages (Partial at 1NF, Transitive at 2NF and Full at 3NF). You should use the same notation as depicted in the normalisation sample solutions, for example:
attr1 -> attr2, attr3
If none exist you must note this by stating:
No partial dependencies present and/or
No transitive dependencies present
? If required, carry out attribute synthesis.
The attribute names used in your normalisation and those on your subsequent logical model must be the same.

This  FIT2094  Management Assignment has been solved by our Management experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.