Vishakha Umale

DBMS Queries : //for fedora-19 or 20 make sure u have to log in as a root  //if no then type su in terminal then enter password //installed mysql and  then....direct use following commands //NOTE " <- " this sign is use for enter....   To open MYSQL : systemctl start mysqld <- mysql <- To create database: show databases <- +--------------------+ | Database           | +--------------------+ | information_schema | | mysql              | | performance_schema | | test               | +--------------------+ 4 rows in set (0.01 sec) create database vishakha; <- show databases <- +--------------------+ | Database           | +--------------------+ | information_schema | | mysql              | | performance_schema | | test               | | vishakha           | +--------------------+ 5 rows in set (0.00 sec) use vishakha;<- show tables; <- o/p-----empty set create table vt(id int,nm varchar(10)); <- o/p: Query OK

Data Base Management System: Data base is nothing but collection of tables. Table is  collection of rows and columns. DBMS is the technology of storing and retrieving users’ data with utmost efficiency along with appropriate security measures. OR A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information. A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information. There are four structural types of database management systems: Hierarchical databases. Network databases. Relational databases. Object-oriented databases. Hierarchical Databases (DBMS) In the Hierarchical Database Model we have to learn about the databases. It is very fast and simple. In a hierarchical database, records contain information about there groups of parent/child relationships, just like as a tree structure.   Network databases