Description
Assignment:
A. Install mysql server into your system:
Download MariaDB:
https://downloads.mariadb.org/
B. Observe existing databases:
1. Login in mysql server
2. Show databases
3. select Host, User from mysql.User;
4. Use information_schema
5. Show tables
6. Select * from CHARACTER_SETS
7. Desc TABLES
8. Select TABLE_NAME,TABLE_TYPE from TABLES
9. Write down your observations from above operations
C. Creating Database:
1. Create a database hospital
2. Create table patients
3. Create table payments
4. Create table doctors