IMAT2428: Database Management System Information 2022

Running head: IMAT2428: DATABASE MANAGEMENT SYSTEM
IMAT2428: Database Management System
Name of the Student
Name of the University
Authors note

IMAT2428: DATABASE MANAGEMENT SYSTEM
1
Functional Requirements for Star trek Games
Proposed system will be able to assign unique IDs for the customers as well as to the
employees of the organization to track their activities.
The proposed information system shall allow different members in order to search game
information.
The system shall allow members to rent games and record the issue and return date for
specific rentals.
Proposed system prompt notice for the rented Games that exceeded the assigned return
date.
It shall allow the employees to calculate the overdue fines as well as record the payment
of the overdues.
Employees of the organization will be able to process returned games in order to
maintain the stock with the real time data.
The system shall be able to manage the stock level of the specific games in the database
that will be used as the back end of the system.
The system should be able to track the number of rentals for a member id as stored
previously.

IMAT2428: DATABASE MANAGEMENT SYSTEM
2
Initial ERD Design

IMAT2428: DATABASE MANAGEMENT SYSTEM
3
Normalization of the Tables
Rental Table
1NF 2NF 3NF
RentalID RentalID
MemberID
51456
51231
45632
StockNumber
51456
51231
RentalID
MemberID
51456
51231
45632
StockNumber
51456
51231
StockNumber
6623 StockNumber
Issue date
ReturnDate
RenewDate
MemberID
51456
55347
MemberName
DateCreated
ActiveStatus
MemberID
51456
51231
45632
StockNumber
Issue date
ReturnDate
RenewDate