Database Management System Lab
Database Management System lab
Quick Links
Experiment 1
Objective: Installation of MySQL Database.
MySQL Installation
To install the MySQL software, we must use the MySQL official site and download the latest version from the MySQL Community Server as per the requirement of our system.
- For this installation, we need the downloaded version of the MySQL which we initially done in the system. From the directory where we have the unzipped files, open Window Explorer and double-click on
setup.exe
. - The product we want to install is MySQL Server 9.0 Setup Wizard.
- We can perform a basic installation with some term acceptance which is End-User License Agreement then go to the next step.
- Now choose the Setup Type as per the requirement, we will go with the Complete Setup Option.
- Installation window has been appeared, now simply click on the Install tab.
- Now our MySQL Server Setup Wizard has been successfully completed. Click on the finish button by giving permission to Run MySQL Configuration with tick icon.
- A new window with the name MySQL Configurator will pop out to our system. Go with the each step for the proper functioning of our SQL Server.
- Data Directory contains the detail of our work path.
- Type and Networking contains the Config Type, we will go with the Development Computer with TCP/IP connectivity Port:3306 and X Protocol Port:33060.
- Account and Roles contains the Password Setup for our MySQL Root server. We may also add the user here as our requirement.
- With our Username, Password and Database role we will go to the next step.
- For Windows Service, we will go with the option as our need.
- For Server File Permission, we give full access to the server.
- Sample Database contain Create Sakila Database and Create World Database, we will go with both the option.
- After applying Configuration, the steps will start to be executed.
- Now the Configuration completed Finish the window now by clicking on the tab.
- For running the SQL Program, we have to download the MySQL Workbench in our system from the same MySQL Official site from the Community Server and select the path where we want to install the Workbench.
- Click on the Complete Setup type and go to the next step.
- After that MySQL Workbench is started to install in the system it will take sometime to install the data. After that the Wizard Completed has been shown in the system.
- For connecting the MySQL Server, we have to enter the Password which we created earlier to link it with the MySQL Workbench.
- Our SQL Workbench will look like as the below image:
Notes: After installation you can work now on the Workbench to create your Database very efficiently by using DDL and DML Commands.
Experiment 2
Objective: Create a database by using the Following SQL Commands:
Theory
- CREATE
- INSERT
- SELECT
- DESCRIBE
- SQL commands are extensively used to interact with databases, enabling users to perform a wide range of actions on database systems. Understanding these commands is crucial for effectively managing and manipulating data.
- SQL Commands are mainly categorized into five categories:
- DDL: Data Definition Language
- DQL: Data Query Language
- DML: Data Manipulation Language
- DCL: Data Control Language
- TCL: Transaction Control Language
CREATE
: Create database or its objects (table, index, function, views, store procedure, and triggers).INSERT
: Insert data into a table.SELECT
: Used to retrieve data from a database.DESCRIBE
: Used to display the structure of a table, view, type, procedure, function, package, or synonym.
Output:
Experiment 3
Objective: Study of hardware and software requirements of differenet operating systems (Windows 10, UNIX, Linux, Windows XP, and Windows 7/8).