CS403 Assignment No 2 Solution Fall 2023

878

CS403 Assignment No 2 Solution Fall 2023 – VU Assignment Solution – VU Fall Assignment Solution

The CS403 Assignment No 2 Solution Fall 2023 of Virtual University (VU) course assignment and I will share with you today the solution I came up with. Always come back to StudySolution for the most recent updates regarding the answers to your assignments.

Please visit our GDB section to traverse the Fall GDB Solution page if you find any GDB solutions for the Spring of 2024 and bring them to our attention. You are welcome to share your thoughts with us in the space provided below, and we will get back to you as quickly as possible.

Study Solution is an educational platform that offers students a free VU assignment solution to further their education. The solutions to the VU assignments provided by this site are the product of the professional and extensive experience of educators who are acknowledged authorities in their respective areas.

CS403 Assignment No 2 Solution Fall 2023 This assignment solution for Virtual University has been crafted with careful consideration given to the particular needs of the students as well as the course material. Study Solution provides a solution for completing assignments associated with Virtual University that is dependable, accurate, and up-to-date.

The VU assignment solution file will be available at no cost during the Fall 2023 semester. You can use all VU assignment solution files for your VU assignments. We can guarantee that if you use our VU assignment help, you will improve the grades that you receive on your assignments.

The Virtual University can be a complex learning environment, particularly for starting students. That is why we provide the Virtual University Assignment Solution to assist you. Don’t hesitate to contact us using the comment box to let us know about any Virtual University Assignment Solution requirements you may have.

CS403 Assignment No 2 Solution Fall 2023 The assignments play a significant role in the educational experience at VU, which is consistently ranked among the nation’s best universities. There are a lot of students who struggle to finish their VU assignments on time; this is where Study Solution comes in.

Assignment No. 2

Solution Fall 2023

CS403

Please Note this Before Submit Your Assignment:

Solution

SQL Code:

CREATE  TABLE  COMPANY  (

Comp_ID  VARCHAR(5)  PRIMARY  KEY, Comp_Name VARCHAR(50),

Comp_City  VARCHAR(50),

);  Comp_Ph  VARCHAR(15)                •

CREATE  TABLE ITEM (                    1

Item_ID  INT PRIMARY  KEY,

enName VA.RCHAR(50),

Item_Unit  VARCHAR( 10),

Item_Quantity INT, CID VARCHAR(5),

FOREIGN  KEY (CID) REFERENCES COMPANY(Comp_ID)

);

INSERT INTO COMPANY  (Comp_ID, Comp_Name, Comp_City,  Comp_Ph#) VALUES

(‘C00l ‘, ‘Toyota’,  ‘Islamabad’,  ‘051-321002’), (‘C002’, ‘Honda’,  ‘Lahore’,  ‘042-321002’), (‘C003’, ‘Suzuki’,  ‘Peshawar’,  ‘091-321002’),

(‘C004’, ‘MITSUBISHI’,  ‘Quetta’,  ‘081-321002’),

(‘C005′, ‘Nissan’,  ‘Gilgit’,  ‘092-321002’);

INSERT INTO ITEM (Item_ID, Item_Name, Item_Unit, Item_Quantity,  CID) VALUES

(1, ‘Lights’,  ‘PCs’,  50,  ‘C00l’),

(2, ‘Bumper’,  ‘PCs’, 20,  ‘C002’), (3, ‘Seats’,  ‘Set’,  10,  ‘C003’),

(4, ‘Tires’, ‘Set’,  60, NULL),

(5, ‘Engine’,  ‘PCs’,  5, NULL), (6, ‘Breaks’,  ‘Set’,  14, ‘C005′);

1. Theta Join on Company and Item tables having a condition ltem_Unit = PCs:

SELECT*

FROM COMPANY

JOIN ITEM ON COMPANY.Comp_ID = ITEM.CID WHERE ITEM.Item_Unit= ‘PCs’;

1. i Equi Join on Company and Item tables:

SELECT*

FROM COMPANY

JOIN ITEM ON COMPANY.Comp_ID  = ITEM.CID;

iii. Natural Join on Company and Item tables:

SELECT

FROM COMPANY

NATURAL  JOIN iTEM

1. iv. Semi Join on Company and Item tables:

SELECT*

FROM COMPANY

WHERE  Comp_ID  IN (SELECT DISTINCT  CID FROM  ITEM WHERE  CID IS NOl

NULL);

1. Theta Join on Company and Item tables having a condition ltem_Unit = PCs: Answer:

Relational Algebra Expression:

(COMPANY  l><l    ITEM ON Item_Unit = ‘PCs’

Comp_ID      Comp_Name      Comp_City     Comp_Ph      Item   IO     ltem   Name     Item   Unit      ltem_Quantity      CID C001             Toyota                  Islamabad        051-321002                  1      Lights             ~-     _I                        50    C001

C002            Honda                  Lahore             042-321002                 2  Bumper

1. ii. Equi Join on Company and Item tables: Answer:

Relational Algebra Expression:

(COMPANY  l><J    ITEM ON COMPANY

 

 

iii. Natural Join on Company and Item tables: Answer:

Relational Algebra Expression: COMPANY  ITEM

1. iv. Semi Join on Company and Item tables: Answer:

Relational Algebra Expression:

COMPANY    I><      ITEM

• Comp_ID     Comp_Name     Comp_City      Comp_Ph

!          C001             Toyota —- Islamabad,    051-321002

!       C002            o MinaiOai_’  042-321002

 

 

 

For More Latest Update Stay With Us.