Computer Shop - CRUD

This program automatically creates tables, using classes made in Model folder, then allows you to execute full CRUD on either Motherboards or Power Supply Units table.
While the image demonstrating the database structure is in Polish, the program itself is written in English.

Database structure

Made with Adobe Photoshop 2021

The database, as shown above, consists of 7 tables:

• Computer, main table, containing most of the other tables
• Disk
• CPU
• Motherboard
• RAM memory
• GPU
• PSU

Each table has it's own ID and records representing it's different properties, like for example CPU's socket or disk's model.

How to use it

1. Copy this repository and open the program in Visual Studio
2. Make sure these two packages are properly installed:
3. Run the program
4. If you encounter any problems with a database, make sure that the context file is configured correctly

Teacher's instructions

POL:

Wykonaj aplikację korzystającą z bazy danych oraz Entity Framework.
Należy:

• utworzyć tabele w podejściu Code First
• baza ma zawierać co najmniej 4 tabele powiązane relacjami
• aplikacja ma mieć możliwość wykonania pełnego CRUDa dla dwóch wybranych tabel.

ENG:

Make an application that uses a database and Entity Framework.

• You should create tables with code-first approach
• The database needs to have at least 4 tables with relations to each other
• The application must have full CRUD functionality for two chosen tables

To do

• Make sure that the database is being actually created correctly
• Add CRUD functionality to all tables
• Make English version of the image showing database anatomy

If you come across any errors or bugs please let me know

The program is not perfect

Made in december 2023