Hotel chain database
-
Updated
Mar 7, 2021 - TSQL
Hotel chain database
Creation of a relational database alongside with the ER diagram, the Relational Model and the Database Diagram. Insertion of data and creation of multiple SQL queries for data retrieval
Practicing Database and object Oriented Database using SQL
In this repository, there are database creation and query commands with sql server.
Ejercicios resueltos de la materia Base de Datos (2009).
This is a Library Management System designed to meet the requirements of efficiently managing library operations.
Topic: Analyze and design databases for library management problems
We were given the task of creating a hospital management system in which we aim to create a database that allows us to keep track of its records. Therefore, our system must be able to store patient data, store hospital personnel data, manage materials used in the hospital, control and organize billing, and manage services offered.
This is an art store database management for a typical store which sells art supplies. The system is made with Oracle-11g DBMS. It includes trigger, loop, PL-SQL, procedure and functions.
In this file I show examples of working in database with Sql. Here, I gave information about both reading and creating a database.
MSSQL exercises
Sistema de Banco de Dados feito em SQL Server que gerencia todas as operações de um determinado restaurante.
Created a database schema for a dental clinic management system. This database can also be useful when creating a hospital database. The schema includes tables for doctors, technicians, patients, appointments, examinations, medications, diagnoses, prescriptions, invoices and payments.
In this repository, you can find some stored procedures, triggers, views and t-sql examples with both their explanations and implementations.
Add a description, image, and links to the trigger topic page so that developers can more easily learn about it.
To associate your repository with the trigger topic, visit your repo's landing page and select "manage topics."