Skip to content

Database project using gui and shopping cart based on php of use framework Laravel and Oracle19c.

License

Notifications You must be signed in to change notification settings

dawidolko/TechByte-Project-Laravel

Repository files navigation

Database project - Computer store

Final database project

Full application of a store selling computers and computer components, with a Frontend written in JavaScript, a Backend in PHP, and a PL/SQL database

info

TechByte

info

Introduction

Welcome to the GitHub repository of the TechByte computer store project. This store is a modern e-commerce platform, offering a wide selection of computer products, including laptops, desktop computers, and components and accessories.

Project Structure

The repository is organized into several directories that are responsible for different parts of the web application and contain necessary files for the operation of the store. Here is a detailed description of each directory and file:

docs

jsDoc

  • database-storage-and-limitation.docx
  • project-description-v1.docx
  • project-description-v2.docx
  • suggestions-sopics.docx
  • README.md # Project documentation

entity-relationship-diagram

  • DB-Diagram.pdf
  • ERD_v3.pdf
  • ERD_v3.png
  • ERD-project-base-drawio.pdf
  • ERD-Projekt-v2-drawio.pdf
  • ERD-VERSION1.png
  • ERD-VERSION2.png
  • ERD-VERSION3.png
  • ERD.pgerd
  • README.md # ER diagram documentation

frontend

  • account.html
  • cart.html
  • checkout.html
  • CNAME # CNAME configuration file for the custom domain
  • components.html
  • computers.html
  • contact.html
  • dashboard.html
  • faq.html
  • favorite.html
  • index.html # Main page of the store
  • laptops.html
  • login.html
  • privacy.html
  • sales.html

python-codes

  • clear.sql
  • delete.sql
  • export_of_data.sql
  • export.sql
  • procedures.sql (PL/SQL scripts for database management)

Project root files

  • .env.example
  • .env
  • .gitignore
  • CONTRIBUTING.md
  • LICENSE
  • README.md # This file with instructions

.github/workflows

Directory containing CI/CD system definitions for the project, including automatic testing and deployment of changes.

docs

Directory with project documentation, including API specifications and user manuals.

backend

Directory with PHP scripts responsible for the backend logic, data handling, session management, and interaction with the database.

entity-relationship-diagram

Directory containing files documenting the Entity-Relationship Diagram (ERD) for the store database.

erd

frontend

Directory containing the frontend application, including HTML files, CSS, JavaScript, and other assets used to create an engaging user interface.

plsql-oracle19c

Directory containing PL/SQL scripts for database management, including stored procedures, triggers, and data export/import scripts.

Project root files

  • Configuration and environment setup files.
  • Contribution guidelines and license information.
  • Main README file with project instructions.

Getting started

Instructions on how to start working with this repository and launching the store can be found in the README.md file.

License

The project is distributed under the MIT license. See the LICENSE file for more information.

Collaborators

List of people involved in the development of the project:

Contribution

If you want to contribute to this project, please see our contribution guidelines in the CONTRIBUTING.md file.


Feel free to explore the repository and provide feedback or contribute to the project. For any questions or issues, please contact the collaborators.