Posts

Showing posts from February, 2022

My Sql Configuration

 1. service mysql stop 2. sudo systemctl stop mysql 3. sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-* 4. sudo rm -rf /etc/mysql /var/lib/mysql 5. sudo apt update 6. sudo apt install mysql-server 7. sudo mysql

Internal Sets

LAKIREDDY BALI REDDY COLLEGE OF ENGINEERING DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING DATA BASE MANAGEMENT SYSTEM INTERNAL LAB & 20CS56   Set no : 1 1.       Sailors(sid: integer , sname: string, rating: integer, age: real)          Boats(bid: integer , bname: string, color: string)          Reserves(sid: integer, bid: integer, day: date).             For the above schema, perform the following: 1.       Find the names of sailors who have reserved a red boat, and list in the order of age . 2.       Find the colors of boats reserved by Lubber. 3.       Find the names of sailors who have reserved a red or a green boat. 4.       Find all sids of sailors who have rating of 10 or have reserved boat 104   2.       Write a Procedure to find the reverse of the given number.