Skip to content
This repository has been archived by the owner on Mar 27, 2022. It is now read-only.
/ PUT-INF-SQL Public archive

Repository for the 4th and 5th semester of full-time Computing studies at the Poznań University of Technology. Project in Microsoft Power Apps Canvas + Azure SQL database and SQL&PL/SQL materials.

Notifications You must be signed in to change notification settings

Koralovy/PUT-INF-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Funeral Home Ordering System - LifeSeQueL

Authors: Jan Chlebek

Planing, development and implementation of the main project took about 5 days (1.5 of which is the application implementation itself)

SQL files created during classes are included in subfolder

Setup

Target system: Microsoft Power Apps Canvas + Azure SQL database

  1. Create Azure SQL database instance
  2. Run SQL_database_generator.sql in your own database
  3. Import LifeSeQueL.zip file as Canvas App
  4. Add connections to all created tables in your app and publish it as standar Power App or Teams App.
  5. Sample client credentials: client client, sample admin credentials: admin, admin

Project photos

  • Database relational diagram

  • login screen

  • New account form

  • User order form

  • User menu main view

  • Admin menu main view

  • Admin SQL table editor

About

Repository for the 4th and 5th semester of full-time Computing studies at the Poznań University of Technology. Project in Microsoft Power Apps Canvas + Azure SQL database and SQL&PL/SQL materials.

Topics

Resources

Stars

Watchers

Forks