Assignment - Creating a 3-tier web application for an on-line videogame shop

Description - VideoGameManager (BSM) is a web application to support a videogame stores in managing inventory and sell videogames.

Implementation - The application must be implemented in Python, using the PonyORM and Bottle packages, and the skeleton template provided on Moodle. All the modules functionalities should be implemented in the order presented in this document (no exceptions!!!).

Data requirements - The system has the following tables:

1. VideoGame: id, title, software_house (from the software_house table), genre (from the genre table), year, operating system (from the operating_system table), price.

2. Software_house: id, name, country.

3. Genre: id, name.

4. Operating_system: id, name.

5. Customer: id, name, lastname, phone number, address, city, country.

6. Order: id, customer (from the customer table), videogame (from the video game table).

Functional requirements - The system has 6 different modules with the following functionalities:

1. VideoGame module

a. List all the videogames in the system.

b. Add a videogame to the system.

c. Edit a videogame in the system.

d. Delete a videogame from the system.

e. Search a videogame in the system by title, software_house, or genre.

2. SoftwareHouse module

a. List all the software house in the system.

b. Add a software house to the system.

c. Edit a software house in the system.

d. Delete a software house from the system.

e. Search a software house in the system by name, and country.

3. Operating System (OS) module

a. List all the OS in the system.

b. Add an OS to the system.

c. Edit an OS in the system.

d. Delete an OS from the system.

e. Search OS in the system by name.

4. Genre module

a. List all the genres in the system.

b. Add a genre to the system.

c. Edit a genre in the system.

d. Delete a genre from the system.

e. Search genre in the system by name.

5. Customer

a. List all the customer in the system.

b. Add a customer to the system.

c. Edit a customer in the system.

d. Delete a customer from the system.

e. Search customers in the system by name or country.

6. Order

a. List all the orders in the system.

b. Add an order to the system and compute the total cost.

c. Edit an order in the system.

d. Delete an order from the system.

e. Search orders in the system by customer or order id.

Presentation - Each student will present their implementation in the lab, showcasing all the functions of the system. Each student should be able to answer questions regarding the code, the database, and be able to perform small changes to the code during presentation.

Appraisal - Each student should submit a 500 words (max) document, describing what he/she learned. You must use the template available on module to complete this part.

Attachment:- Assignment File.rar