COM4015 Introduction to Databases Assessment Brief 2026 | Arden University

Here you can see the assignment sample list of Arden University

COM4015 Assessment Brief

Learning Outcomes (LO)

By completing this assessment, you will have shown and be assessed on all four of the learning outcomes:

1. Demonstrate a knowledge and understanding of databases and data management systems.
2. Understand key principles of relational database design
3. Apply knowledge and understanding of database development to design and implement, a relational database solution.

Graduate Attribute

4. Discipline Expertise: Knowledge and understanding of chosen field. Possess a range of skills to operate within this sector, have a keen awareness of current developments in working practice being well positioned to respond to change

Task Summary

You have been assigned as a database developer to create a database design for the loans system at Lantern Library. You have also been tasked to implement the Lantern events reservation Database.

• Task 1: Propose the design of a relational database for Lantern loans system
• Task 2: Implement the database for Lantern events booking system.
• Task 3: Test the implementation of the Lantern events booking database.

Please make sure to use your university-allocated database account to answer the questions of Task 2 and 3, otherwise, your assignment work will not receive any marks for the tasks.

Provide execution screenshots in the report evidencing each step of your work, as well as text-based copies of any SQL. Also, ensure your username is included in all the screenshots of the database execution evidence to verify it is your work.

Assignment Instructions

Task 1: Lantern Loan System Database Design

Lantern library is a mid-sized library that offers a wide range of services to the local community. Customers can loan books, journals, magazines, DVD’s and Vinyl records. The library works with other libraries to offer inter library loans

A member should be able to make a loan for any number of items at one time. To make a loan members take items to a staff member who checks the items into a loans database. The library would like the database to be accessible via a web application and would like all items to be categorised. The library would also like to keep records of publishers who they purchase books from. Members will be charged fines for books that go past their due date which should be recorded.

To improve their library operations the head librarian would like you design a database which will streamline the loans system at Lantern.

a. Logical Model

Based on the scenario, create a logical model for the database using a crow’s foot style Entity-Relationship Diagram (e.g., Barker/UML, do NOT use the Chen diagramming style).

Make sure to normalise the data to 3NF, adding keys and identifier columns as appropriate. Annotations for the normalisation process are required to prove that all the entities are in 3NF. Make sure to note any assumptions made along with their reasons.

b. Physical Model

Using your logical model as a basis, create a physical model Entity-Relationship diagram using crow’s foot notation for the Lantern loans relational database. Make sure to use appropriate naming conventions and to identify data types, keys, and constraints. Note any assumptions made or further changes to the structure beyond those in the logical model.

Task 1: (900 Words equivalent)
(30 Marks)
(LOs: 2,4)

Task 2: Create The Lantern Events Booking Relational Database

Lantern library is rolling out a system to manage events booking in the library premises. The system tracks the type of event, rooms, event bookings, and payments. To support budgeting and analysis, each event is categorized and costed.

The head librarian has recently approved the design of the events booking System, which is given as the physical model Entity Relationship diagram in the figure 1. To improve the management of events booking, the head librarian would like you to develop this relational database and prove its functionality.

a. Based on Figure 1. Lantern events booking system physical model entityrelationship diagram, create the database using appropriate SQL in the database account provided by Arden University.

COM4015 Figure 1. Lantern Events Booking System physical model entity-relationship diagram

b. Insert 12 Events in the Events table using the sample data in Table 1 below.

• • Event type descriptions from table 1 should be used in the EventType table and the foreign key related back to the Event table.
  • Insert 6 members, 6 rooms, 6 room payments, 6 feedback, 6 event bookings and 6 staff.
  • Please include meaningful records for all tables. The given number of records are the minimum requirements for the database, you are allowed to add more data as required.
  • Larger amounts of relevant and accurate data will receive higher marks. Please consult marking matrix for further details on number of records and types of data.
  • The booking status in the EventBooking table should have the values Confirmed, Cancelled and Waitlisted.
  • Ratings for the member feedback should be between 1 and 5.

Table 1: Lantern Events Table

c. Display all the tables with the meaningful inserted data.

 Task 2: (1200 words equivalent)
(40 marks)
(LOs: 3,4)

Task 3: Test Implementation Of Lantern Events Booking Database

Using the Lantern events booking database from Task 2, provide solutions to the following four problem cases in the form of SQL code and a brief explanation of your reasoning. Include screenshots of SQL queries execution and its results along with your schema, evidencing this in each of the cases mentioned below. Ensure your schema or username is included in every screenshot to verify it is your code.

Case 1

List the rooms booked for each training event showing the room name, the event name and the event date.

Case 2

To demonstrate the efficiency of searching to the head librarian, create searches based on the criteria mentioned below.

a. Find all the events in the database sorted by event type. Show the event name, event date and event type description.

b. Find events based on price. For example, events with ticket cost less than £5.

Case 3

The events that Lantern Library offers have changed. Write the queries to reflect these changes in inventory. Please show screenshots of database records before and after to show changes in the state of the database.

a. The Family Reading Picnic has been renamed Community Reading Picnic and the ticket price has been changed to 20 pounds. Update the database accordingly.

b. The Local History Lecture will no longer be running. Remove the Local History Lecture record to reflect this.

Case 4

Write queries to perform the following operations.

a. Find the number of bookings for each event type showing the most popular to least popular. Show the event type description and the number of bookings.

b. Find the amount of money made for each event from bookings made. Show the event name and amount of money made from bookings. Show the earnings in descending order. Earnings will only be on bookings that were confirmed.

c. Find the total amount of potential earnings for each of the rooms that have been booked. Show the room name and the amount of potential earnings for that room.

Task 3: (900 words equivalent)
(30 marks)
(LOs: 1,4)

End of questions

Reminder

Make sure to use your university-allocated database account to answer the questions of Task 2 and 3, otherwise, your submitted work will not receive any marks for the tasks.

Provide execution screenshots along with their output in the report evidencing each step of your work, as well as text-based copies of any SQL. Also, ensure your username is included in all the screenshots of the database execution evidence to verify it is your work.