KL7011 - Advanced Databases And ER - EER Diagram - Computer Science Assignment Help

Assignment Task

Assignment Questions

Part 1

This part is based on the LMS scenario as described in the Appendix.

(A) Using entity-relationship (ER) and enhance entity-relationship (EER) modelling, produce a conceptual design for the database to support the LMS required by NCL.

(B) Convert the ER / EER diagram from Part 1(A) to produce a logical relational schema using ER / EER to relational mapping.

(C) Based on your logical design from Part 1 (B) and the information available in the scenario, produce an SQL script file using Oracle 11g/12c/higher.

Part 2

This part is based on your answer / solution to Part 1, i.e., design and implementation of the database for the LMS scenario.

(A) Populate the database with some sample data (e.g., data similar to the data kept about books and other bibliographic items within Northumbria University Library).

(B) Answer the following queries (retrievals) using SQL.

1. Display details of the top 10 most frequent users (members) of the library with the number of books/titles/items they have borrowed in the past 18 months.
2. Display details of the top 20 most frequently borrowed titles/books/items of the LMS with the total number of borrowings in the past two financial years.

This (KL7011) Computer Science Assignment has been solved by our Computer Science 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.