CS403 Assignment 2 Solution Fall 2021 With File

CS403 Assignment 2 Solution Fall 2021 With File - VU Answer

Provide CS403 Assignment 2 Solution Fall 2021. Easy to See Complete Step by Step CS403 Assignment 2 Solution 2021 Download File PDF.

CS403 ASSIGNMENT 2 SOLUTION FALL 2021

Due Date: 24 Dec 2021

Total Marks: 20

Assignment Upload Instruction:

Submit your assignment in doc or docx format only

Save your assignment with your ID (e.g. bx020200786.doc).

Also, Must Read Assignment Question File and Note that Fulfill Proper Instruction that will be Given in the File.

Question 1 (Part a:)

Draw the Enhanced Entity Relationship Diagram (EERD) by considering the above-given scenario and table. You are required to identify and draw supertypes and subtypes properly. Draw relationship cardinalities in alphabetical notation.

EERD Diagram:

Question 2 Part B:

Perform the Cartesian product (Booking X Feedback) on the following relations

Solution:

Bk_Id	Bk_Date	Driver_option	Feedback_Id	Feedback_desc
BK001	01/09/2020	Yes	Fd001	Good
BK001	01/09/2020	Yes	Fd002	Nice
BK001	01/09/2020	Yes	Fd003	Bad
BK002	20/08/2021	Yes	Fd001	Good
BK002	20/08/2021	Yes	Fd002	Nice
BK002	20/08/2021	Yes	Fd003	Bad
BK003	12/10/2021	No	Fd001	Good
BK003	12/10/2021	No	Fd002	Nice
BK003	12/10/2021	No	Fd003	Bad
BK004	01/11/2021	Yes	Fd001	Good
BK004	01/11/2021	Yes	Fd002	Nice
BK004	01/11/2021	Yes	Fd003	Bad