MIS602: Data Modelling and Database Design - ABC Library - IT/Computer Science Assignment Help

Assignment Task:

Context:  
The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your  understanding of data and database management and its relevance with in business context. It also introduces  you to some of the key features of database management system and designing database systems that will feature  in later modules of this topic. In order for you to do well in this subject, it is imperative that you undertake all of the  learning activities in the modules. The learning activities are presented as a way of scaffolding your learning so  that you can attempt the building blocks of the assessments and be in a safe environment to fail and to learn from  them. Therefore, doing your learning activities and seeking feedback from them from peers and from the learning  facilitator is the single best way of preparing for doing well in this assessment.  
Introduction:  
This assignment is based on the following scenario: 
ABC library is a small community library in the northern suburbs of Adelaide. In the recent years, its collection  of books and the number of registered users have increased significantly facing difficulties in manually handling 

its main functions efficiently. To improve its services, the senior management of the library has considered a  computerized library management system.  
The library has a rich collection of books with different genres such as fiction, biography, and history to name  a few. The main functions considered for computerizing include searching of book collection based on author  name, book title and genre. For this, the system should allow common functions including add, delete and  modification of book details. Similarly, the library also wants to keep records of all the transactions— book  issue and return. Finally, the system should allow the library staff to view all transactions and associated  borrowers (library members) for each transaction, transaction date and the library staff who handled each  transaction. 
Submission Requirements and Instructions: 
This assessment comprises of TWO parts. 
PART I 
Requirements: Based on this scenario, you should identify key business data objects and their attributes and  define them as columns in a spreadsheet using MS excel or similar software. For this you are required to create  multiple versions, ideally one file with 4 sheets with each sheet numbered with the version number, of the  spreadsheet file as per below instruction:  
• Version 1 (V1.0): List all the data objects and their attributes as columns, and then add at least 10 rows  of data.  
• Version 2 (V1.1): Update last 2 records (highlight in blue) and add 5 additional records (highlight in  yellow) to each data object identified. 
• Version 3 (V1.2): Add 2 new attributes (highlight in red) to each data object identified. 
• Version 4 (V1.3) : Remove 1 existing attribute from each data object and add 5 more rows of data (highlight in green). 
 

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