Scribd
Upload
7 views2 pages

Day 4 Introduction to Assignment 1

The coursework requires an evaluation of different database management systems (DBMS) for a Star Trek Games rental shop, focusing on two aspects: rentals and catalogue. Students must analyze the scenario, match suitable DBMS types, create a strengths and weaknesses table, and highlight features that make each DBMS appropriate. The new system should efficiently manage game rentals, member registrations, and provide an electronic catalogue accessible via various platforms while tracking rental history and customer reviews.

Uploaded by

Alin Linca
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views2 pages

Day 4 Introduction to Assignment 1

The coursework requires an evaluation of different database management systems (DBMS) for a Star Trek Games rental shop, focusing on two aspects: rentals and catalogue. Students must analyze the scenario, match suitable DBMS types, create a strengths and weaknesses table, and highlight features that make each DBMS appropriate. The new system should efficiently manage game rentals, member registrations, and provide an electronic catalogue accessible via various platforms while tracking rental history and customer reviews.

Uploaded by

Alin Linca
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Faculty of Computing, Engineering & Media (CEM)

Coursework Brief 2023/24

Assessment 1 (30% of the total marks)


You are required to evaluate different database management systems against all the different
aspects of the following scenario to determine which DBMS is suitable for each part.

In order to come to a decision you will:


 need to extract various aspects of the scenario
 Match a suitable DBMS for each part
 produce a table with strengths and weaknesses of DBMS type. For this you will need to
consider all the finer details of the scenario
 highlight features of the DBMS which make it suitable

Finally, you will conduct your research into available DBMS implementations corresponding to
your choices and present your findings

Business Description (Scenario) for the Coursework


You have been asked by the manager of the Star Trek Games rental shop to replace their existing
system for recording rentals. Information about the shop is provided below.

Note: the following information was collected during an investigation of the Star Trek Games Rental
Shop.

Star Trek Games Rental shop holds numerous games from a number of different developer
companies. Previously the shop kept records of the rentals using a system originally intended just
for PC games but this is no longer commercially supported. The manager of the shop wants to
replace the old system with a more efficient and useful one. The new system needs to deal with
games of different types such as Wii, Xbox, PlayStation, etc.
There are two ‘aspects’ (these are complementary sub-systems that make up the system)
required for the new system: the rentals and the catalogue. The rental aspect should keep track of
the shop’s membership and games rented to them. The catalogue aspect should hold product details
of the games including developers as well as any reviews and highlights.
The distribution companies which produce the games give their own unique catalogue number
to each different game. Some games are in sets containing more than one component part. Many of
the games are popular and there is often more than one copy of the same game held by the shop.
The number of copies depends on popularity and demand. Every individual copy of a game is
identified by a unique stock number, which is allocated by the manager of the shop when the item
comes into stock. A full set of component parts for one game counts as a single stock item.
Anyone who wants to rent a game must first register their details to become a member. Each
rental is for a specified period agreed at the time of rental (up to a maximum of 2 weeks), after which
it can be renewed provided that there is no outstanding reservation for the same item. Normally a
maximum of 3 games can be rented at the same time by one member. The issuing, renewal and
return of games is carried out at the shop counter by a shop assistant.
The cost of each rental is based on a scale of daily rates. Very new games are usually charged
at the highest rate and there are a number of rates for other games. Renewals are charged at the
same daily rates as the initial loan. If a member wants to rent a game and all the copies are already
on loan, then they may make a reservation. If rentals are returned late then additional charges will
be made for the extra days at twice the normal daily rate for the item.
In order to ensure that additional copies are obtained for popular items, the manager wants to
keep track of the rental history of games and will require various reports on the rentals. For audit
purposes it will also be necessary to keep a record of each rental by a member after the game has
been returned.
The manager of the shop wants to provide members with access to an electronic catalogue of
the game collection via a terminal in the shop, a mobile app and a website. This should allow a
member to browse by genre, or to look for a specific game, or to search in different ways such as by
release date, age rating or category. To make this into a useful resource the manager would like to
hold brief product details as well as reviews of games where appropriate. The catalogue may
eventually be made available to borrowers via the Internet.

Branches all over the world have been monitoring the success rate of Star Trek Games and
would like to open franchises in Europe, Asia and Africa. Success for this venture can only happen if
the catalogue and the rental facility software is made available to this these franchises.

Customers are given incentives to review games so it is necessary to identify active customers,
and to keep track of the number of reviews submitted within a given time period. Target figures are
required for customers who make the most rentals and then to report on review per rental.

Incentives such as free cinema tickets, tickets to events and free rentals may be offered
depending on customer loyalty.

You might also like