Databases | SQL | Oracle | MS Access Answers

Practical Related Question
(Write step by step command)

1. Create table COURSE in that it Contain 3 fields(COURSE_ID AS PRIMARY KEY&NOT
NULL,COURSE_NAME)

2. Create 2nd Table COURSE_STRENGTH(COURSE_ID FOREIGN KEY,COURSE_STRENGTH)

3. Enter 5 record in Both table:
COURSE NAME: STRENGTH
1.PYTHON 30
2..NET 20
3.HADOOP 45
4.SOFTWARE TESTING 40
5.JAVA 35

4. DELETE SOFTWARE TESTING COURSE & SHOW BOTH TABLES.

Practical Related Questions:(step by step command)
1. Create Database NCER
2. Create Table Student it contain 3 fieldS(Roll No,Name ,Age,City)
3. Insert 5 records into table
4. Update name of student (Updated Name=XYZ)
5. Add ‘Blood Group’ Column into table
6. Rename ‘Student’ Table to ‘Stud’
7. Delete all record from ‘Stud’ table
8. Drop ‘Stud’ Table
9. Drop ‘NCER’ database

Explain union, intersection, cross product, difference in relational algebra

List and explain different types of Joins.

Explain insertion, deletion and modification amenities with an example.

List and explain the different DML commands with example

List the operation of relational algebra and purpose of each with an example.

Write short note on Open and Commercial DBMS Software

Explain unary relational operation in detail.

Consider the following schema ,write the relational algebra queries for the following:
Supplier(sid,name,address)
Parts(pid,name,color)
Catalog (sid,pid,cost)

i)Find sid of supplier who supplies every part)
ii)find the name of suppliers who supplies only red parts.
iii) find the ID’s of suppliers who supplies only red parts.
iv) find the sid of suppliers who supplies only red parts or are at 221 park street.