Answer to Question #229901 in Computer Networks for upcoming legend

Question

1.1 If we apply the cross-product operation to these two instances of STUDENTS & BOOKS, what would be the resulting relation? (15)

STUDENTS

Student_ID Student_Name Qualification

401 Andile HCIT

402 Carol DIT

403 Amber BSc

404 Bright HCIT

 BOOKS

Book_ID Title Copy-right

101 Database fundamentals 2017

102 C++ how to program 2018

103 Simply Visual Basic 2019

104 OOP for beginners 2020

1.2 SELECT and RETURN all students with qualification HCIT from relations STUDENTS X BOOKS. (10)

1.3 Write a relational algebra expression using the symbolic notation for the given question in (1.2)

above. (5)

Answer 1

The answer to your question is provided in the image: