Try to create at least 2 table and link them together through mysql join (relationship) Table A
Question:
Try to create at least 2 table and link them together through mysql join (relationship) Table A has a field in Table B which is matching both field.
When we call table A statement will respond statement B
1.0 Centralized Database for the college
1.1 Making a Database for Students in Pures College (2 tables 1 international 1 domestics) 1.2
2.0 Inventory of products
2.1 two-there tables related to products such as Nike, adidas etc 2.2 2 tables. 1 sport, runners
3.0 Hospital database
3.1 Admitted patients in different wards
4.0 Payroll
4.1 Salary for employee
5.0 Blood donation 5.1 0
5.2 A 5.3 B 5.4 AB
6.0 Covid-19 vaccination 6.1 Covid Shield
6.2 Pfizer
6.3 Moderna 7.0 Library System 7.1 Books.
For this project you will be able to use PHPMYADMIN in case you encounter any difficulties created tables.
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright