DBMS With MySQL😊

DBMS  stand for database management system.It is a software that designed for storing data, defining data ,retrieving data and manage all type records or data into the  database.
                 

                        *----- DATABASE-----*
                  =======================
Database refers to the collection of interrrelated data and Database management system (DBMS) is a computer program that manages a database effectively and efficiently.
a number of diffrent application programs are written to extract records from and add records to the appropriate files. But this scheme has a number of major limitations and disadvantages,such as data redundancy (duplication of data), data inconsistency, unsharable data, unstandarized data,insecure data, incorrect data etc. A database management system is answer for all these problems as it provides a centralized control of the data.


                        HOW DATABASE WORKS
                 ==========================
The database system do not maintain se4prate copies of same data.Rather, all the data are kept at one place and all the applications that require data refers to the centralluy maintained database (collection of data) .If any change is to be made to data, it will be made at just one place and the same changed information will be available to all the pplications referring to it .We do not mean to suggest that all redundancy should neccessarily be eliminated.


        Advantages of database:-
===========================
1.  Database reduce the data redundancy to a              large extent.
2.  Database can control data inconsistancy to a        large extent
3.  Database facilitate sharing of data
4.  Dtatabase enforce standards 
5.  Database can ensure data security


                         Flat  vs Relational database
                    ===========================
When all the data is stored in one file then such a database is called Flat database.
When the data is stored in multiple tables that are linked through a common fields,then such a database is called Relational database and software handling relational database is called RDBMS- Relational database Management System.

Microsoft Access, BASE, Oracle, MySQL etc. are examples of RDBMS. A table in an RDBMS is given a special name - relation.


Comments

Post a Comment

Popular posts from this blog

My SQL Data Type

                      -:Data Type:-                   ================ INT:-      A numeric type that can accept values in               the range of 2147483648 to -2147483647. DECIMAL:-    A numeric type with support for                                floating point numbers.   DATE:-    A Date field in the YYYYMMDD format   TIME:-    A Time field in the HH:MM:SS format DATETIME:-  A combined date/time type in the                              YYYYMMDD HH:MM:SS format. YEAR:-    A field specifically for year displays in                      the range 1901 to 2155,in either YYYY                       or YY formats. TIMESTAMP:-  A timestamp, in YYYYMMDD -                                     HHMMSS formats. CHAR:-      A string type with a maximum size of                     255 characters and a variable length. VARCHAR:-  A string type with a maximum size                         of 255 characters and a fixed length. TEXT:-    A string type with a maximum size of                        655
Read more

How to create shortcuts file

Image
A shortcut is a small file that is linked to a program,document,folder or an Internet ll.The file luis represented by an icon with an arrrow in its lower left corner. A shortcut is linked to a file or folder. However, that file or folder can be located anywhere on a local hard disk or CD-ROM drive or on a floppy disk.             Method to Create a shortcut ====================================== *  By using cut and paste,or  *   By using the create shortcut wizard. NOTE:-                 A shortcut is a pointer to an object, and not the object itself. you can create and delete shortcuts without affecting the original file.
Read more

ccc important quetions

                  S.P GROUP OF INSTITUTE   1. IFSC CODE क्या है ? a. Indian financial system code b. एक अल्फानुमेरिक 11 digit ka code hai c. पहले के 4 डिजिट बैंक के लिए होते है आखिरी के 6 डिजिट        न्यूमेरिक खाताब्रंच के होते है और एक बीच में जीरो (0) होता       है d. all of the above 2. imps का पूर्ण रूप क्या है? a. immediate payment system b. immediate payment service c. internet power system d. none of these  2. पहला माइक्रो एटीएम आधार बेस्ड किस बैंक ने suru ki thi? a.HDFC B.FINO BANK C.SBI D.AXIS BANK 3.WHATSAPP ग्रुप में अधिकतम कितने मेंबर हो सकते हैं? A.255 B.300 C.256 D.NO limit 4. लाइब्रेफिस राइटर में डिफॉल्ट फाइल एक्सटेंशन क्या होता है? a. .ods b. .docs c .odt d. .doc 5. क्या पालतू जानवरों के नाम pr paasword rakhna chahiye? a. सत्य b. असत्य 6. USSD का पूर्ण रूप क्या है? A.Unstructured supplimentary service data b. uniform supplimentary service data c. unified supplimentary services data d. universal supplimentary service data 7. लाइब्रेफिस ek एप्लीकेशन सॉफ्टवेयर हैं/ a. सत्
Read more