Quick little demo on MySQL using mariadb in kali linux;
How to create a table in 3rd normal form, view table information, add information, use select, import data, add data, and a couple embedded functions to view data;
For the table data grab it from the github account here:
https://gitlab.com/modernhackerspace/...
To better understand the scenario and relationship, here is the information that was provided:
A Business Trip Management System manages information about business trips and their associated expenses by employees of a company.
Each employee belongs to a department and is identified by a unique number.
Each employee also has name, job title and salary information.
An employee can have many business trips.
Each business trip includes the departure city and destination city, the departure date and the return date.
each business trip, each day, an employee can have many expense items and each item has its own amount.
Watch video mySQL crash course online without registration, duration hours minute second in high quality. This video was added by user Modern Hacker Space 12 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2 once and liked it people.