Worksheet - Save and quit from the file. Create another file named DEF.txt and enter the PDF

Preview

Summary

Save and quit from the file. Create another file named DEF.txt and enter the content “HELLO, HOW R U?” in it. Now delete “R” and edit it as “ARE” and now move this file to another directory DIR1. At last append the contents of ABC.txt to DEF.txt. After appending store the contents in DEF.txt file as...

Description

External Practical Examination (Dec 2020) Subject Name: Database Management System Lab Subject Code: CAP-207 SET A 1. Create a table emp with following values E_id (primary key) E1001

E_name (not null)

E_dept

E_sal (not null)

Shivani

HR

45000

E1002

Pooja

Marketing

47000

E1003

Rohit

Finance

38000

E1004

Ram

Marketing

45000

2. Calculate the average salary of an employee. 3. What is the maximum salary withdrawn by an employee? 4. List out the unique names of the departments in the emp table. 5. Change the salary of Ram to 46000.

External Practical Examination (Dec 2020) Subject Name: Database Management System Lab Subject Code: CAP-207 SET B Create the following table with name Teacher_details Teacher_ID (primary key)

Teacher_name

Teacher_specialization Teacher_dept

E101

Prof. Harish

Cloud Computing

CSE

E102

Prof. Sneha

Big Data

CSE

E103

Prof. Vikram

Marketing

Business Studies

E104

Prof. Sonam

Networking

ECE

E105

Prof. Sandeep

Thermodynamics

Civil

Follow the instructions given below: 1. Add another column teacher_sal and update the salary where no salary must be less than 30000. 2. Display only those teacher names whose salary is more than 45000. 3. Display only those teacher details where department is “CSE”. 4. Create a view having columns as teacher_id, Teacher_name only.

External Practical Examination (Dec 2020) Subject Name: Database Management System Lab Subject Code: CAP-207 SET C 1. Create table student with following details:     

Stu_id ……………….. primary key Stu_name ……………… not null Stu_course………………… not null Stu_contact……………. Unique Stu_cgpa ……….not null

Enter any ten values. 2. Create another table instructor and consider following details    

Inst_id………………primary key Inst_name………………….not null Inst_dept…………………… not null Stu_id…………………..foreign key

3. Enter any five values in this table also. 4. Implement joins on above two tables a. Equi Join b. Right Outer Join c. Left Outer Join d. Cross Join.

External Practical Examination (Dec 2020) Subject Name: Database Management System Lab Subject Code: CAP-207 SET D 1. Create a table hospital_management and enter any ten records of your choice. Take following columns:      

Patient_id …………… primary key Patient_name…………….. not null Patient_date_admit …………….. date Patient_date_discharge…………date Patient_disease_diagnose……….not null Doctor_id……………foreign key

2. Implement the following queries on above table; a. Update b. Rename c. Aggregate functions d. Clauses 3. Implement Joins (Full outer and cross join) with another table doctor_details as follows   

Doctor_id : primary key Doctor_name : not null Doctor_specialization….unique...