University : Northumbria University UniLearnO is not sponsored or endorsed by this college or university.
Subject Code : KL7011
Assignment Task:

Task:

Mapping to Programme Goals and Objectives
This assignment covers the following learning outcomes for the module:

Knowledge & Understanding:
1. Demonstrate critical understanding of the entire data life cycle and classical database engineering processes and approaches, and non-traditional database systems Intellectual / Professional skills & abilities:
3. Critically analyse, select, apply and evaluate advanced data modelling, database design, implementation and manipulation methods, techniques and tools to a complex data management problem Personal Values Attributes (Global / Cultural awareness, Ethics, Curiosity) (PVA):
5. Develop critical awareness of the responsibilities of database developer with respect to professional, legal, security and ethical issues individually or as part of a team

 

Assignment Questions
Part 1 (40 marks)

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.

(15 marks)

 

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

(10 marks)

Notes for Part 1 (A & B)
 The ER/EER diagram should show all relevant entity types, relationship types, attributes, primary keys, and structural constraints. Note that not all keys are identified/mentioned in the scenario, so you are required to identify/devise appropriate primary keys for all the entity types. Your ER/EER diagram must not show/include any foreign keys or any such attributes that represent foreign keys as these are logical and not conceptual concepts.

 As part of the mapping process, for each relation, you should identify appropriate primary keys as well as foreign keys (if applicable). Furthermore, you need to make sure your relations obtained from mapping your ER/EER diagram are in the 3 rd normal form.

(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 (15 marks)
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). (10 marks)

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

(5 marks)
q1) 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.
q2) 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.

 

Part 3 (35 marks)
This part is based on your answer / solution to Part 1 (A), i.e., conceptual design of the database for the LMS scenario.

(A) Choose and justify what aspects of LMS conceptual design would be better off if implemented using object-relational database; then provide logical design and implementation of the subset of the LMS using ER/EER to object-relational mapping and object-relational features of Oracle Database System; populate the object-tables with sample data and demonstrate your choice of design and implementation by running two complex queries on your object-tables.

(20 marks)
(B) Analyse the conceptual database design from Part 1 (A) and the LMS scenario in the Appendix and propose what aspects of the LMS database would benefit from incorporating NoSQL Database concepts. Illustrate your answer with code from a representative code from NoSQL Database implementation.

 

Part 4 (10 marks)

Consider the LMS scenario in the Appendix. Produce a report for the Mayor of the Newbigging Council elaborating on professional, legal, ethical and security issues that need to be considered and make recommendations that you think are appropriate for LMS.

(10 marks)

The report should be concise and comprehensive and in the region of 800-900 words. You should use Harvard style of citation and referencing by following the guidelines in Pears and Shields (2008).

 

This KL7011: IT Assignment has been solved by our IT Experts at UniLearnO. 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.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Pearl
  • Posted on : December 21st, 2018

Whatsapp Tap to ChatGet instant assistance