FIT9132 - Introduction to Databases - IT Assignment Help

Assignment Task

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.

2. Based on your assignment 1A conceptual model, your markers feedback, your reading of this case study and the normalisations you carried out in step 1 above, prepare a logical level design for the Animal Doctors database.
- The logical model must be drawn using the Oracle Data Modeler. The information engineering or Crow’s foot notation must be used in drawing the model. Your logical
model must not show datatypes.
- All relations depicted on this model must be in 3NF
- You are required to add at least one surrogate key to your design (you are free to select the most appropriate relation to make this change in)
- All attributes must be commented in the database (ie. the comments must be part of the table structure, not simply comments in the schema file).
- Check clauses/look up tables must be applied to attributes where appropriate.
- You MUST include the legend as part of your model.
- Note that your GIT repository must clearly indicate your development history with multiple commits/pushes as you work on your model.

This FIT9132 - IT Assignment has been solved by our IT 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.