Skip to content

CristianoDinh/TGDD-database-design

Repository files navigation

An End-to-End DATABASE Design of Real TGDD Website with Microsoft SQL Server Management System.

🔎 For more information, visit The Gioi Di Dong .

Re-designing a website database using SQL Server(Microsoft). The project follows BNCF design principles and includes implementations of Views, Stored Procedures, Functions, and Triggers.

Below are the steps and key features implemented in this project:

  • Database Design: Following BNCF principles to ensure a normalized and efficient database structure.
  • Implementation of Views: Creating views to simplify complex queries and enhance data presentation.
  • Stored Procedures: Developing stored procedures for modular and reusable database operations.
  • Functions: Implementing user-defined functions to encapsulate reusable logic within the database.
  • Triggers: Setting up triggers to automate and enforce business rules.

View for better imagination

Project Requirement image

How to install this example SQL on Windows

The easiest way to see how this works is to watch the series, but here's the short version.

  1. clone this project
  2. Download Microsoft SQL Server

How to tweak this project for your own uses

Since this is an example project, I'd encourage you to clone and rename this project to use your own purposes. It's a good starter boilerplate

Find a bug?

If you found an issues or would like to submit an improvement to this project, please submit an issue using the issues tab above. If you would like to submit a PR with a fix, reference the issue you created!

Known issues (Work in progress)

This tutorial is still ongoing. The automation of the helm chart repo has not been completed yet. This is coming soon!

Like this project?

☕ If you are feeling generous, buy me a coffee!

About

End-to-End DATABASE Design of Real Website

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages