Giter VIP home page Giter VIP logo

dbms-course's Introduction

Dir

image

WinForms Application

Final version (Uncompleted)

  • This application requires local database to be loaded, as well as triggers, procedures,...
  • This application is not completed yet, but has no plans to be develop in the future. Well, we stepped on ours deadline.
  • Open source for education purpose.

Login

image

Sign Up

As A Customer

image

Sign Up To Be A Shipper

image

Sign Up To Be A Partner

image

Profile (As A Customer)

image

Products Manage

image

Orders Manage

image

Customer Manage

image

Staff Manage

image

Shipper Manage

image

Partner Manage

image

Concurrency Demo

Dirty Read

Problem

  • Staff updates price for all products of a department, a customer request to read all product of this department at the same time, too.
  • Well, after the customer read data, a issue occured that staff's transaction has to be rolled back. image

Handled

  • Customer has to wait until the staff's transaction is commited or rolled back. (??? :D How silly) image

Unreapeatable Read

Problem

  • Shipper want to search specified products quantity of an order
  • But the customer makes change of quantity at the same time. image

Handled

  • Customer has to waits until shipper's transaction is finished.
  • image

Phantom Read

Problem

  • Customer search all products have price bigger than given value.
  • Staff added a new product has price in range which to be searched by customer.
  • Staff's transaction is rolled back. image

Handled

  • Staff has to wait for customer. image

dbms-course's People

Contributors

eakan-git avatar nhut19112001 avatar yennhipear avatar

Stargazers

 avatar

Watchers

 avatar

dbms-course's Issues

Chỉnh sửa Data

Tất cả đều giống nhau, chỉ khác MaKH
image

Query 1 câu đơn giản nhưng bị trùng hơn 1k rows
@yennhipear
Thay đổi một số type: Tiền -> type là money
Số điện thoại nvarchar -> varchar
Số lượng sản phẩm bigint -> int

Nghịch lý số lượng sản phẩm

image
Đối tác có số lượng sản phẩm hạn chế.
image
Nhưng một chi nhánh lại không có số lượng tồn kho. (?)

Thiết kế lại database.

  • Thêm số lượng tồn kho của một sản phẩm tại một chi nhánh.
  • Tổng số đơn hàng bán ra trong ngày <= số lượng tối đa đối tác cung cấp.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.