Experiment No: 01
Name: Nayan Mishra
PRN: 20220802424
Aim: - To install MySQL.
Requirement: -
1. MySQL [Software]
2. Hardware: 8 GB Ram,Ryzen 7
Theory:-
MySQL is an open-source relational database management system
(RDBMS). It may be anything from a simple shopping list to a picture gallery
or the vast amounts of information in a corporate network. To add, access,
and process data stored in a computer database, you need a database
management system such as MySQL Server.
Step 1:- Open your browser & open the following URL:
https://dev.mysql.com/downloads/installer/
Step 2:- Click on download on the 1st download button as shown.
Step 3:- Login with your Oracle ID to continue.
Step 4:- After successfully logging in click on the download button.
Step
5:- Locate the downloaded file and open it. Now select Full and click Next.
Step 6:- Click Execute on this screen to install all MySQL and its
dependencies.
Step 7:- After the package status is downloaded click next to proceed
to installation.
Step 8:-Click on execute to install all the downloaded packages.
Step 9: - Click Next and process to ‘Product Configuration’.
Step 10:- Keep all the options on default and hit Next.
Step 11: - Select the first option and click next to set a password.
Step
12:- Set a Password that you will remember and click next.
Step 13:- Click Next for further screen and leave all the options on default.
Step 14:- At last, click on execute and finalize the installation.
Step 15:- Click on Finish.
Result:-
Thus, we installed MySQL successfully.
DBS ASSIGNMENT 2
Name: Nayan Mishra
PRN: 20220802424 Batch: C3
Experiment No: 02
I] perform following commands on Databases –
1) create
2) drop
RESULT:
II] Perform following commands on Table –
1)Create
Result:
2) Alter
3)Truncate
4)Drop
DATABASE MANAGEMENT SYSTEM
SEMESTER-IV
LAB SHEET - 3
NAME: NAYAN MISHRA
PRN: 20220802424
BATCH: C3
Aim:
● Create department table, employee table in mySQL.
● Create project table with primary key
● Create workson table
● Create foreign keys between employees and department
● Create foreign keys between workson and employees
● Create foreign keys between projects and departments
Experiment and Results:
1. Create employee table, department table in MySQL.
2. Create project table with primary key.
3. Create workson table.
4. Create foreign keys between employees and departments.
5. Create foreign keys between workson and employees.
6. Create foreign keys between projects and departments.
Conclusion:
In conclusion, the provided SQL commands effec vely establish a rela onal database
schema for managing department, employee, project, and workson data. By defining tables
with primary keys and establishing foreign key constraints between them, the schema
ensures data integrity and maintains referen al integrity across related en es. This setup
enables the database to efficiently organize and store informa on while enforcing
rela onships between en es, thus facilita ng effec ve data management and retrieval
opera ons.
