SUPERSTARWEBTECH

There is no elevator to success. You have to take the stairs. Take your first steps with SSWT!

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

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

Author

Anam Afzal

Anam Afzal

Hi, I'm a Pakistani freelancer with a passion for helping businesses achieve their online goals through no-code solutions. I specialize in WordPress customization and ManyChat automation, and I'm always on the lookout for new ways to use technology to make businesses more efficient and successful. I'm also a big believer in the power of no-code tools to democratize technology and make it accessible to everyone. I'm passionate about sharing my knowledge and helping others learn how to use no-code tools to create their own websites, automate their workflows, and grow their businesses. If you're looking for a reliable and experienced no-code developer, I'm here to help. Please feel free to contact me to discuss your project requirements.
SHARE THIS POST