Scribd
Upload
53 views1 page

Course Code. PMIT6006 Date. 12-02-2021 Each Carries 5 Marks

This document contains instructions for 5 SQL and relational algebra questions. Question 1 asks to write SQL to create a table with 6 columns. Question 2 asks to write SQL to insert a record into that table. Question 3 asks to write SQL to select records from the table that meet certain criteria. Question 4 asks to write the output of a relational algebra expression operating on a table. Question 5 asks to use relational algebra to find kids who like certain toys using 3 given tables.

Uploaded by

TusharShuvro
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
53 views1 page

Course Code. PMIT6006 Date. 12-02-2021 Each Carries 5 Marks

This document contains instructions for 5 SQL and relational algebra questions. Question 1 asks to write SQL to create a table with 6 columns. Question 2 asks to write SQL to insert a record into that table. Question 3 asks to write SQL to select records from the table that meet certain criteria. Question 4 asks to write the output of a relational algebra expression operating on a table. Question 5 asks to use relational algebra to find kids who like certain toys using 3 given tables.

Uploaded by

TusharShuvro
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

ID.

Name.
Course Code. PMIT6006
Date. 12-02-2021
Each carries 5 marks

1. Write a SQL code to create a table PMIT that contains six columns such as Student_name,
Student_id, Contact_address, Mobile, Gender, Age
2. Write a SQL code to insert values of Rakib, 01910, Mirpur, 87654331, Male, 30 into the
table of PMIT.
3. Write a SQL code to find out the student names from the table of PMIT who are male,
contact address is at Mirpur, and age is between 30-40 years.
4. Find out the following query’s output:
σactor =‘ABC’(Dance) - σactor =‘XYZ’(Dance)
note. Dance(actor, Dance-name), and Dance is a table/relation
5. ToyShop(kid, store)
Sells(store, toys)
Likes(kid, toys)
# Table/Relation ToyShop indicates what toy stores a kid likes to visit.
# Table/Relation Sells shows which toy each store sells.
# Table/Relation Likes informs which toy a kid likes.
Use relational algebra to find the kids who like “Robot” or “Ludu” toy.

You might also like