WorldSkills Portugal 2024 - Category 09: IT Software Solutions for Business

Repository used for Pre-Selection Test (theme: Skilian Cinemas).

This repository contains the official project developed for the WorldSkills Pre-Selection Exam, focusing on Skillian Cinemas. Developed the app covering three fundamental modules:

• Relational Model Design: Creating an efficient relational model to manage complex business data; Guarantee of data integrity and consistency through advanced modelling techniques; Use ER (Entity-Relationship) diagrams to represent the relationships between different entities in the system.

• Databases: Implementation of scalable databases; Use of SQL to create, manipulate and query data; Query optimization to improve system performance.

• CRUD Operations (Create, Read, Update, Delete): Development of UI and functionalities to allow complete interaction with the database; Implementation of safe and efficient CRUD operations; Rigorous testing to ensure the accuracy and reliability of operations;

Overview: Delivery of a functional system that meets business needs, with a user-friendly interface and a solid data architecture; Demonstration of advanced technical skills and ability to solve complex problems.

Description

The project involves creating an application (or system) for Skillian Cinemas management.

Technologies Used

The main technologies and tools used in the development of this project are:

• Programming Language: [C# Windows Forms]
• Framework: [None, but it's possible to add ASP.NET]
• Database: [SQL Server]
• Version Control: [Git/GitHub]

Features

• Login System and Dark Mode
• Hashed Password
• Roles (Admin, Coordenator and User)
• Search Bar
• Movie Registration
• Types of Movies Associated w/ Movies
• Session Management
• Cinema Room Management
• (Local) Place Management

About This Project

This project was developed for the WorldSkills Portugal Pre-Selection Test, where it achieved 1st place and took place in May 2024.

The theme of the test was Skillian Cinemas, and the objective was to create a CRUD for different entities, not only at the frontend level (client-side and UX/UI) but also at the backend level (server-side, with respective databases created with SQL Server), thus creating a robust full-stack application.

Contact Me

For more information, please contact me via email: emsmoreno@gmail.com