Reference no: EM133910633

Database and Information Management

Assignment 1: UNIOSE Library Project - Requirement Analysis and Conceptual Design

Background
The University of Newcastle's Institute of Ocean Sciences and Engineering (UNIOSE) offers multiple study programs across several physical locations. The new institute aims to have its library system operational by the end of 2025. To facilitate this, the library system will be developed as a student project within the School of Information and Physical Sciences (SIPS). The proposed library system consists of various modules. You have been selected to design and develop a database for the UNIOSE library. The system requirements should be similar to those of the existing Callaghan campus library.

The UNIOSE library database design and development project is divided into three interlinked assignments:
Assignment 1: Requirements analysis and conceptual database design.
Assignment 2: Logical database design.
Assignment 3: Physical database design, implemented on Microsoft SQL Server using Microsoft T-SQL.
In this first assignment, you are required to develop the data requirements specification and the conceptual database model for the UNIOSE library database based on the business/user requirements provided in this document and discussions in lectures. Your lecturer will act as your client, and you can consult them for further information and clarifications.

Main Features of Business Requirements
Catalogue Services

The primary aim of this service is to develop a web-based searchable catalogue of both physical and virtual resources. It must support searches based on various criteria, including keywords, authors, titles, and subjects. In addition to the physical collection, the library maintains digital copies of theses, books, periodicals, and journals. It also subscribes to online databases, providing access to library members.
Circulation Services

This service facilitates the issuing and returning of library resources. To borrow items, a person must be a member of the library. Different membership types offer varying degrees of privileges.

Hold Services

Members should be able to hold library items, ensuring fair access to as many members as possible. Holds are processed on a first-come, first-served basis.

Acquisition Services
The library consistently updates its resources. Suggestions for acquiring new items are elicited from members.
Analysis of Data Requirements

You may have to identify all the data elements and their attributes required to design the conceptual model.
One of the data elements that is required to carry out the above services is item, which consists of different types such as book, thesis, journal, and online database. They are called subclasses (Please Note: for this assignment, we consider these four subclasses of item only). Each item can have one or more copies. A copy of an item can be a subclass physical copy or a subclass digital copy.

Circulation and Hold Services are concerned only with physical copy, as digital copy access is managed through the proposed library website. However, the digital copy data item is required for Catalogue Services of the library and hence needs to be included in the database design.

As mentioned previously, the UNIOSE library has similar requirements to the Callaghan campus library.

Further details will be discussed in the weeks 2 and 3 lectures. You must incorporate this information into your assignment to complete it successfully. Information or methodologies from outside sources must be properly referenced to avoid plagiarism.

Assignment Tasks (Individual Assignment)

You are required to complete the first two stages of the database design: developing user requirements specifications and creating a conceptual database model based on the business requirements provided in this document and discussed in lectures. Your report should be a single Microsoft Word document containing the following parts. The report must be in Microsoft Word (No mark will be given if the report is submitted in other file formats)

Part 1: Requirements
In this assignment, you are required to develop a user requirements specification truly fulfilling the data requirements (identify what types of data need to be stored in the database), transaction requirements (identify the important and frequent database operations - data manipulation and queries), and business rules (which is based on this document and elaborations in lecture) for the library's database mentioned above. Get Assignment Help from trusted tutors.

Develop a user requirements specification that addresses:

Data Requirements: Outline the major data items, including their names, and short descriptions of what the data is and what is stored in each field. For each data, give its relationship with other related data types and related business rules, and its subclass info if it has.

Transaction Requirements: Detail the data manipulation and queries needed to support future web applications.

Business Rules: Detail the business rules based on this document and lecture elaborations. Sample requirements documents are discussed in weeks 2 and 3 and are available in the appendices of your main textbook.

Part 2: EER Model with Data Dictionary
Draw an EER model for the requirements identified in Part 1 using UML notation. Include the EER diagram in your report. Note: in the report, you must put your whole EER inside no-more- than 2 A4-sized pages. It is strongly suggested that you put your EER within one page. If your EER is in more-than-2 pages, 10 marks (out of 150) will be deducted.

You also need to submit your original EER file, as well as the report in Word file.

The EER model should be accompanied by a data dictionary that includes:
Entity Type Table
Relationship Type Table
Attribute Table

Assignment submission format for the EER Model with Data Dictionary part: The document
MUST have the following sections:
EER Model
Documentation - Data dictionary details (description of entities, relationships and attributes)

The lecturer will discuss the details of the requirements in class as well as act as the client of the system. You need to implement all the details mentioned in lecture as well as described in this document and the marking scheme document. You are encouraged to ask questions to the lecturer and tutor to clarify requirements.