Skip to content

mhtkarakose/SE-222-Database-Systems-Term-Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Welcome !

Hey! This document is my term proejct. Please be sure to inform us of any errors you found in the codes.

Project Aim

Project aim is creating affordable online ordering system for small restaurant SMEs. Project name is Online Ordering System for Restaurants.


Documents

Conceptual Diagram

Conceptual Diagram

Logical Model

Logical Model

Create a database

CREATE DATABASE OrderingSystemDb; 

The necessary codes have been added.

Procedures

  • Customer_ReadAll All customers print on the screen. How does it work?

    exec Customer_ReadAll;

  • Customer_ReadById Writes the selected customer information to the screen. How does it work?

    exec Customer_ReadById [Enter the int DustomerId];

  • Customer_Add Add customer :) How does it work?

    exec Customer_Add(@Id, @Email, @CustomerPass, @Name, @SecondName, @Surname)

  • Customer_Add_Address The address information of the customer is entered in the address table. How does it work?

    exec Customer_Add_Address(@Id, @CustomerId, @AddressName, @AddressDescription )

  • Customer_ReadAll_Address All customer addresses on the screen. How does it work?

    exec Customer_ReadAll_Address;

  • Customer_ReadById_Address The selected customer addresses are displayed on the screen. How does it work?

    exec Customer_ReadById_Address [Enter the int CustomerId];

  • Customer_Bill The invoice belongs to the selected customer. How does it work?

    exec Customer_Bill[Enter the int CustomerId];

  • Product_Add Adding products to the system. How does it work?

    exec Product_Add(@ProductId, @CategoryId, @ProductName, @ProductDescription, @ProductPrice, @ProductCalorie, @Stock) ;

Triggers

  • Stock_Takip

Stocks for each product ordered are replaced.

  • TotalPrice

It subtracts the total price of the ordered product to the customer bill.

Team

Mehmet KARAKOSE,

Yağız Ismail GAZIBABA

Releases

No releases published

Packages

No packages published