Games Rental System

This is our project for the Introduction to Database Systems course taken during fall 2022 semester.
A Game rental Software Application using C# programming language

Description:

A game rental system provides an easy and cost-effective way to try out new games without having to buy every one.

Game rental is a risk-free way to try new games . Because it's so much cheaper than buying.

Each game has a vendor who has the responsibility of developing the game.

The admin of the system is responsible for adding the games to be rented out by the clients.

A games rental system should include the following functionalities :
- Signing up a new user ( e.g. admin , client )
- Updating a user details
- Adding a game ( by admin )
- Updating a game details ( by admin )
- Browsing games Showing a list of games that satisfy certain criteria ( e.g. year , vendor , category ... )
- Performing operations on games : renting , returning .

Project Steps

First:

We draw the ERD for this project using PowerDesigner
Here is the link of the --> ERD

Second:

We converted the ERD to physical model (DDL scripts)
Here is the link of the --> SQL Script

Third:

We developped the software application using C# and connected the database to be able to perform all the application functions like: sign-in, add game, update game and browse all games that are stored in our database.

Some screenshots:

Setting up the environment 🛠

1. Create a database in Microsoft SQL Server and name it 'Game-Over'.

2. Open the SQL Script and execute all the Queries in Game-Over database.

3. Open the Solution file and change the 'Data Source' value in the _sqlcon string in "sqlCon.cs" file to the name of your server.

internal class sqlCon
    {
        static string _sqlcon = @"Data Source=SeverName; Initial Catalog=Game-Over; Integrated Security=True";
        public static string sqlcon
        {
            get => _sqlcon;
        }
    }

3. You have successfully created the database and linked it to the C# Code.

To Run the Program here is the default user name and password:
username: michael
password: michael1234