Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

MN405 Data And Information Management

tag 0 Download 3 Pages / 721 Words tag 21-10-2020


  1. The schema for the LibraryDB database is given below. LibraryDB is a database that keeps track of information about the books and their circulation in a library. 

The primary keys are underlined. The foreign keys are denoted by asterisks (*). 

Borrow (transactionID:text, personID*:text ;borrowdate:date, returndate:date)

Book    (ISBN:number, title:text, Volnumber:number, year_published:numeric, NoofCopies:number; Price:number; PublisherID:text)

Person (personID:text, firstname:text,  lastname:text, address:text, city:text,

       postcode:txt, phonenumber:number)

publisher (publisherID:text, publisherfullname:txt) 

Description of the schema 

borrow -- keeps track of the check-ins and check-outs of the books. 

person -- keeps track of the people who borrow books from the library.

book -- contains information about the books that are available in the library.

publisher -- keeps track of the publisher information. 

  1. Implement the above described database in MS Access. You are required to create the above 4 tables with the given attributes. Name the database as ‘LibraryDB ’ .(5 Marks) 
  1. Populate all tables with suitable data (at least 3 records per table- suitable to answer given queries) using the following SQL statements or data sheet view in MS Access.

INSERT into TableName

VALUES (“..”,”..”,.....)  (5 Marks) 

Write SQL queries for the following questions and execute the queries on the ‘LibraryDB’    database you created in MS Access.                      

Prepare a list of ISBN number, title, Volnumber, NoofCopies of all Books in the library.  (5 Marks)

  1. Assume that you want to count how many books in the library which are older than 10 years (i.e year_published is before 2008). Write a query to find the number.  (5 Marks)
  1. Display details of all books that cost more than the average price of the books in the library.

(Hint: use sub-query).  (5 Marks)

  1. Display details of all books which are published in year 2017 and published by “ACER Press” publishers (publisherfullname is “ACER Press”)

(Hint: you may need to join Book table and publisher table)  (10 Marks)

Create a new table named “Borrower” that includes personID, firstname, lastname, address of the borrower, borrowdate and returndate.

Hint : you may need to join 2 tables Person and Borrow.   (5 Marks)

Sales tracking is important in many online stores. Figure 1 shows the ER diagram that captures important information in the tracking of sales in a Bookstore.  Specifically, the ER diagram captures relationships between authors, Books, customers, publishers, warehouses and shopping-basket.                                                       Figure 1: Bookstore ER Diagram

  1. Convert the ER diagram into a relational database schema. Be certain to indicate primary keys (underline).

Eg         Book (ISBN: NUMBER; title: text,.....) (5 Marks) 

  1. Identify 2 attributes in the ER diagram of figure 1 that might represent a composite attribute, and explain why/how it might represent a composite attribute. (4 Marks) 
  1. Determine the cardinality of the relationships (listed below) in the above ER diagram. The cardinality shows how much of one side of the relationship belongs to how much of the other side of the relationship. Write the business rule that you would use to mark the cardinality, as shown in the example given in figure 2.

(5x3=15 Marks)

  1. Book—Author
  2. Book – publisher
  • Book – Warehouse


 Relationship between      shopping-basket ---  Customer

Business rule:

A customer may submit any number of orders on to the shopping-basket. However, each order must be submitted by exactly one customer.

Figure 2: Example of cardinality of business rule for the ‘shopping-basket --- Customer’ relationship  

  1. Prepare a brief report on the following “Big data technologies”. (6 Marks)
    1. Hadoop
    2. MapReduce

Use the following heading for writing the report for each topic:

  1. Introduction
  2. Capabilities and Limitations
  3. Conclusion 

Marking criteria:

Marks are allocated for each part as below:

Marking Rubric for Assignment 1 -Total Marks 100





Very Good












Q1. Model organisational information requirements using conceptual data modelling techniques and Query Writing



(40 marks)


Evidence of accurate and well-

written queries

Evidence of good query writing skills.

Generally relevant.

Demonstrated reasonable query writing skills.

Did not demonstrate evidence of understanding the topic.


Q2. Convert the conceptual data model  into relational data model.


(24 marks)

Demonstrated   excellent ability to think critically.



Demonstrated an ability to think critically.



Demonstrated reasonable   ability to think.




Demonstrated   some ability to think critically but not complete.



Did not demonstrate ability to think critically.



Q3. Model organisational information requirements(with Big data technologies)


(6 marks)

Demonstrated   excellent knowledge on the topic



Demonstrated good knowledge on the topic.



Demonstrated reasonable   knowledge on the topic




Demonstrated   some knowledge on the topic.



Did not demonstrate any knowledge on the topic.

Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Unique Document

Under Evaluation

Get Money
into Your Wallet

Total 3 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Data And Information Management. Retrieved from

My Assignment Help (2020) Data And Information Management [Online]. Available from:
[Accessed 01 December 2022].

My Assignment Help. 'Data And Information Management' (My Assignment Help, 2020) <> accessed 01 December 2022.

My Assignment Help. Data And Information Management [Internet]. My Assignment Help. 2020 [cited 01 December 2022]. Available from:

Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!


Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on then please raise the content removal request.


5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

callback request mobile
Have any Query?