COM-5005 - Database Implementation - Vets R Case Study - IT Assignment Help

Assignment Task

Learning Outcomes: After completing the module you should be able to:

1. Demonstrate a critical understanding of the tools and techniques to support database development.

2. Justify the design and development of the application and critically evaluate the implementation and approach.

3. Design and implement a database system meeting the needs of both the user and the client.

4. Develop appropriate SQL statements in order to efficiently create, manage and interrogate data within the database application.

5. Use appropriate database development techniques to solve loosely defined problems.

SCENARIO - Vets R Us are a nation-wide network of veterinary practices, spanning the whole of the United Kingdom. There are currently over 1,000 branches, with each local practice based in a town and covering an area of 10-20 miles radius. The head office is in London where the company board and CEO are based, along with all core business functions. Around 700 branches are privately-owned franchises under the “Vets R Us” banner, with the remaining branches being 100% owned by the parent company. The company is aggressive and always looking to expand and so the franchisee operation is actively promoted at all times. The company regularly attend franchise conventions, trade fairs and advertise in specialist publications like ‘The Modern Vet’ – aiming to attract younger vets to set-up their own business and become part of the ‘Vets R Us’ family. Each practice – franchise or corporate – has a typical make-up of around five to eight fully qualified vets supported by ten to twelve veterinary nurses and four to six admin and support staff. Every practice operates 7 days a week with 24 x 7 emergency callout as backup. All practices have at least one van at their disposal to collect animals. Franchised practices are private businesses so they will each have their own owners, shareholders and directors who take expenses, salaries, bonuses and dividends – that is their business – but they must pass on 15% of monthly turnover to the parent company as part of the franchise agreement (in addition to the initial £250,000 joining fee). In return, the local franchisee gets full IT installation and support, bulk discount opportunities when buying supplies, access to the in-house accountancy and payroll services to pay their own local staff and, most importantly, the brand recognition of being part of the largest vet chain in the world. Some franchisees actually have a chain of franchised practices – effectively a chain within a much larger chain. This is how all franchises work.

Assignment Task

Question 1 - (a) Develop a semantically rich data model that captures the above scenario in the form of an entity-relationship diagram (ERD). You should note (and number) all assumptions you make about the data and the reasoning behind your design choices. Also, include (and number) any appropriate constraints and a list of entity types showing their attributes and identifiers.

(b) Once your ERD is complete, you should look for opportunities to use the entity sub-typing concept and thus develop an EERD (Enhanced ERD).

Question 2 - (a) Once you are satisfied that the EER diagram is a good representation of the organisation’s data requirements, produce a logical design by mapping the EER diagram to a set of relations, showing all primary and foreign keys clearly.

(b) Now produce a normalized relational model by checking each relation is in third normal form (3NF). You should clearly annotate and explain this process.

 (c) Under what circumstances would it be necessary to de-normalize this model?

This COM-5005 - 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.