cs dbms task 10

CREATE VIEW BugCompProj
AS
SELECT B.num bug_num, B.title bug_title, B.submission_date submission_date, B.owner_id owner_id, B.status_id status_id,
       C.title component_title,
       P.id project_id
 FROM Bug B
    JOIN BugComponent BC ON BC.bug_num = B.num
    JOIN Component C ON C.id = BC.component_id
    JOIN Project P ON P.id = C.project_id