CREATION & INSERTION OF SAILORS , BOATS & RESERVES TABLES IN SQL || SQL QUERIES || FOREIGN KEY

SAILORS ( SID , SNAME , RATING , AGE ) BOATS ( BID , BNAME , COLOR ) RESERVES ( SID , BID , DATE ) Syntax CREATE TABLE SAILORS ( SID INTEGER , SNAME VARCHAR(30) , RATING INTEGER , AGE INTEGER , PRIMARY KEY(SID) ); CREATE TABLE BOATS ( BID INTEGER , BNAME VARCHAR(20) , COLOR VARCHAR(20) , PRIMARY KEY(BID) ); CREATE TABLE RESERVES ( SID INTEGER , BID INTEGER , DAY DATE , PRIMARY KEY(BID,SID) , FOREIGN KEY(SID) REFERENCES SAILORS(SID) , FOREIGN KEY(BID) REFERENCES BOATS(BID) ); - HOW TO DOWNLOAD & INSTALL MySQL IN WINDOWS 10 🤍🤍youtube.com/watch?v=6dC0xjdIPZ0&t=302s DATABASE MANAGEMENT SYSTEM 🤍🤍youtube.com/playlist?list=PLLOxZwkBK52B6FqMOu6FfU4_5Id2cBStN PYTHON PROGRAMS 🤍🤍youtube.com/playlist?list=PLLOxZwkBK52BC-U5nWzUm6dBsFIFRtQuO C PROGRAMMING 🤍🤍youtube.com/watch?v=aUqO-dgzMw4&list=PLLOxZwkBK52AE9jFVOGZTJxaiAC_xB8Yy CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS 🤍🤍youtube.com/watch?v=ZFnRvpxpnOc&t=4961s HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS 🤍🤍youtube.com/watch?v=a8W952NBZUE&t=1305s LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS 🤍🤍youtube.com/watch?v=_-tR5OQS5cI&t=13s JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT 🤍🤍youtube.com/watch?v=BTuCzffKh8E&t=4s PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో) 🤍youtu.be/9hVzEKZQyMU PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో) 🤍youtu.be/B-Rkxotn9Ok PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU 🤍youtu.be/p2k_9I4VGYs PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE 🤍🤍youtube.com/watch?v=brgzTJwHIKI&t=4456s MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH) 🤍🤍youtube.com/playlist?list=PLLOxZwkBK52BQjsMFcnOB0wjzAUneSNfI PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL 🤍🤍youtube.com/playlist?list=PLLOxZwkBK52CIfeg1YISebeYu2Cfc_6Pl DATA STRUCTURES USING PYTHON (ENGLISH) 🤍🤍youtube.com/playlist?list=PLLOxZwkBK52Apt7hZ6D5q1QY6uQ6vgt Instagram : 🤍🤍instagram.com/sundeepsaradhikanthety/