B7IS109 Library Management System Assignment Report : SQL Server Case Study for Normalised 3NF Database Design

Published: 24 Jul, 2025
Category Assignment Subject Computer Science
University Dublin Business School Module Title Database Design and Cloud Technologies
Assessment Type Report
Academic Year 2024-25

B7IS109 Assignment Objectives

  • To develop/analyse a set of requirements for a database system.
  • To develop an Entity Relationship Diagram (ERD) and a normalised schema.
  • To implement the database system in SQL Server

B7IS109 Assessment Task (100 Marks) – Weighting (70%)

You are tasked with developing and designing a new database system for the list below or a company/business of your choosing. The implementation of your system must be carried out using MS SQL Server.

Library Management System

  • A database to manage books, borrowers, lending history, due dates, and fines.

Online Ordering System for a Restaurant

  • A system for customers to order food online, track orders, and manage payments.

Student Enrolment System

  • A database to manage student records, course registrations, and grades.

Event Management System

  • A system to handle event registrations, attendee information, and ticket sales.

Inventory Management System

  • A database to track products, stock levels, suppliers, and purchase orders.

Hotel Booking System

  • A system for managing room reservations, guest information, and billing.

Online Learning Platform

  • A database to manage courses, instructors, student enrolments, and progress tracking.

Medical Appointment System

  • A system to manage patient appointments, doctor schedules, and medical records.

E-commerce Product Catalogue

  • A database to store products, customers, orders, and payment details for an online store.

Movie Rental System

  • A system to manage movie rentals, customers, and overdue fees.

Requirements

Report (35 Marks)

The report must include the following:

  • Background for the development of the chosen database system. (Why the Database is needed) Scope includes requirements for the database system to be developed. (What should it be able to do) (5 marks)
  • An Entity Relationship Diagram (ERD) of the system must include a minimum of 4 entities displaying all the relationships with cardinalities and all the constraints. The model (relational schema) of your database system must fulfil the requirements of 3NF. Use Draw.io or LucidChart to develop the ERD. (15 marks)
  • Evaluation of a suitable cloud solution for your Database.(7 marks)
  • Outline 2 security threats posed to a database and how they can be mitigated (6 marks)
  • Appropriately structured report showing precise information. (Cover page, Table of Contents, Headings, etc) (2 marks)

(Total: 35 marks)

Achieve Higher Grades with B7IS109 Assignment Solutions

Order Non-Plagiarized Assignment

Completed Database System (using MSSQL Server) (65 Marks)

Consider the ERD created.

1. Create the relevant tables with appropriate relationships in MS SQL Server using the CREATE TABLE statement. (6 Marks)

2. Ensure appropriate Data types are used. (5 Marks)

3. Populate the tables with a minimum of 5 records using INSERT INTO SQL Statements. (5 Marks)

4. Create the following parametric stored procedures:

  • Inserting new values for ONE table
  • Deleting values from ONE table
  • Search BETWEEN two dates
  • Use of the “LIKE” operator
  • A parametric Stored Procedure that would support the business (25marks)

5. Create 4 Views that would be beneficial for the business. Views should consist of:

  • At least 1 using a JOIN.
  • At least 1 listing all items from any table in order of some attribute
  • At least 1 using the “DISTINCT” operator
  • At least 1 using “Aliased” column names
    (20 Marks)

6. Scripts for your SQL server database for structure and data. (4 marks)

(Total: 65 marks)

Instructions for Submission

You are required to:

  • Create a folder with yourNameDBCA.
  • Include the report in the folder.
  • Develop the scripts for your SQL server database and include them in the folder.
  • Compress the folder and upload it on Moodle Page B7IS109 using the specified link.

Note: Your SQL server database must be available in your SQL Server Account until you receive your results for this module.

B7IS109 Assessment Criteria

Criteria/Mark < 40 40 – 49 50 – 59 60 – 69 70 +
Report Insufficient or incomplete report with poor or incomplete data model, no/poor normalisation, poor explanation, etc. Some, but insufficient and poorly written report with a poorly developed data model; some normalisation and explanation are not enough to meet the requirements Sufficient explanation with data model with normalised schema that solves the problem, but lacks attention to good report writing skills Well-structured and well-written report with good specifications and data model with normalised schema Excellent solution to problem proving originality, creativity and evidence of research – very well written with excellent data model and normalised schema to 3NF
Database System with MS SQL Server Less than four tables not properly structured, queries without the required features that do not meet business requirements, no/poor implementation of stored procedures. Four substantial tables demonstrating some structure of data, queries with some required features that meet some business requirements, some implementation of stored procedures. Four substantial tables with some structure, queries with most required features that meet most business requirements, implementation of stored procedures, but not as appropriate as required. Four substantial and structured tables with appropriate record queries with all required features that meet the business requirements, good implementation of stored procedures. Excellent database system that meets all the business requirements, required features, etc.

General Assessment Submission Requirements for Students:

  • Online assignments must be submitted no later than the stated deadline.
  • All relevant provisions of the Assessment Regulations must be complied with.
  • Extensions to assignment submission deadlines will not be granted, other than in exceptional circumstances. Please note lecturers DO NOT grant these extensions.
  • Students are required to retain a copy of each assignment submitted, and the submission receipt.
  • Assignments that exceed the word count will be penalised.
  • Students are required to refer to the assessment regulations in their Student Guides and on the Student Website.
  • Dublin Business School penalises students who engage in academic impropriety (i.e. plagiarism, collusion and/or copying). Please refer to the attached referencing guidelines for information on correct referencing.
  • Late submissions will be penalised by 2 marks per day.

Take Our academic assistance & Get 100% Plagiarism-free papers

Buy Today,Contact Us

Stuck on your B7IS109 Database Design and Cloud Technologies? Don't worry! Our Computer Science Assignment Help service is the best for you. If you need help with assignments, our expert PhD writers will provide you with original content. And yes, you will also get free assignment samples which will give you a perfect idea of ​​how to write a top-quality assignment. Don't worry about the deadline as we guarantee on-time delivery. Contact us now for high-quality and plagiarism-free work and boost your grades!

If you want to see the related solution of this brief then click here:- Database Design

Workingment Unique Features

Hire Assignment Helper Today!


Latest Free Samples for University Students

RBP020L063H Leadership and Change Management Assignment Sample

Category: Assignment

Subject: Management

University: University of Roehampton

Module Title: RBP020L063H Leadership and Change Management

View Free Samples

HRMM080 Ethical and Responsible Leadership AS2 Reflective Portfolio Sample

Category: Assignment

Subject: Management

University: University of Northampton

Module Title: HRMM080 Ethical and Responsible Leadership

View Free Samples

ACAD1346 The child’s live Experience Developing Confidence Learners Assignment Sample

Category: Assignment

Subject: Education

University: University of Greenwich (UOG)

Module Title: ACAD1346 The child’s live Experience Developing Confidence Learners

View Free Samples

NUR7011 Developing Healthcare Leaders Assignment Sample | BPP

Category: Assignment

Subject: Nursing

University: BPP University

Module Title: NUR7011 Developing Healthcare Leaders

View Free Samples

Project Management, Leadership and Skills: Planning & Control Portfolio Example

Category: Assignment

Subject: Management

University: University of Salford Manchester

Module Title: Project Management, Leadership and Skills: Planning & Control

View Free Samples
Online Assignment Help in UK