Description
Instructions:
– Take the screenshot of terminal after execution of each command and
paste it below the command given in assignment
– Submit the .pdf file on moodle
– Submit it in naming format
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
