Posts

Showing posts from October, 2022

My SQL Revision

 RELATIONAL DATABASE MANAGEMENT SYSTEMS – MySQL Revision  Data – Raw facts which has a meaning but can’t lead to a conclusion  Eg – I give you 4 words,  ‘Tom’, 6/6, shades, blue. Tell me what do I want you to lead to? These 4 words are data (Raw facts definitely has a meaning which every student will think of as his mindset) When I arrange (Process) these 4 words, add some conjunctions, adjectives will lead you to a conclusion. Tom with an eyesight 6/6 loves to gear blue shades. This is information (processed data leading to a conclusion) Database – is a container/holder (base) which holds data in it. This document is having data in it so is it a database? No, a database is an organized structure (not a paragraph) in rows and columns (table) which hold data in it.  Why? Easy to locate and access specific values within the database. Like  AdmNo RollNo Name Percentage 1023 1 Amya 87 5467 15 Navya 99 AdmNo Name DOB 1023 Amya 20/01/20...