Monday, 27 May 2019

CS403-DBMS Assignment no. 2 Solution SPRING 2019 Due date: 30 May, 2019 | SUPERSTARWEBTECH

Subject: CS403-DBMS
Semester: SPRING 2019
Assignment No. 2
Due date: 30 May 2019
CS403 DBMS ASSIGNMENT 2 SOLUTION SPRING 2019

CS403-DBMS Assignment 2 #Question

Our second assignment is the continuation of the first assignment. In the first assignment, an ERD was required for the given scenario.
The ERD of the first assignment is given below:

You’re required to perform the first task according to above Entity Relationship Diagram.

1. Convert the above Entity Relationship Diagram into Relational data model
You have to convert all the components of the ERD into Relational Data model.
2. Perform the Cartesian product (Task X DiscussionThread) on the following relations:
Task:
Task_id
Title
Creation_date
Deadline
Assigned_to
T0001
Computer Science
01/01/2019
15/01/2019
User001
T0002
Management Science
02/02/2019
16/02/2019
User002
T0003
Mass Communication
03/03/2019
17/03/2019
User003
T0004
Bio Informatics
04/04/2019
20/04/2019
User004
      DiscussionThread:
Thread_id
Thread_name
Th001
BSCS
Th002
BBA
Th003
MSC zoology





3. Find the degree and cardinality of the relations given in the 2nd question.

CS403-DBMS Assignment 2 Solution! Download!

CS403 Assignment_2 Solution SPRING_2019 ---------------------- Download