Share:

Dear Students! Please share your Assignment files as you recieve in your lms so it can be discussed/solved timely. Share assignments files by click on UPLOAD button.

[Solved] CS403 Assignment 2 Solution & Discussion Fall 2019  

  RSS

admin
(@admin)
Admin
Joined: 1 year ago
Posts: 1361
27/11/2019 5:05 pm  

CS403 Database Management System Assignment 2 Solution & Discussion Fall 2019


 

Assignment No. 02
SEMESTER Spring 2019

CS403- Database Management System

 Total Marks: 20

Due Date: 02/12/2019

Instructions

Please read the following instructions carefully before solving & submitting assignment:

It should be clear that your assignment will not get any credit  if:

·       The assignment is submitted after due date.

·       The submitted assignment does not open or file corrupt.

·       The assignment is full or partially copied from (other student or ditto copy from handouts or internet).

·       Student ID is not mentioned in the assignment File or name of file is other than student ID.

·       The assignment is not submitted in .doc or .docx format.

 

Uploading instructions

Your submission must include:

·       Assignment should be in .doc or .docx format.

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

·       Assignment submission through email is NOT acceptable.

 

Objectives

The objective of this assignment is to able the Students:

·       To understand the relational database model

·       To understand the Conversion of ERD into relational data model

·       To understand the Cartesian product of two relations

·       To understand the degree and cardinalities of relations

 

Note:

Your answer must follow the below given specifications.

·        Font style: “Times New Roman”

·        Font color: “Black”

·        Font size: “12”

·        Bold for heading only.

·        Font in Italic is not allowed at all.

·        No formatting or bullets are allowed to use.

·       Your answer should be precise and to the point, avoid irrelevant detail.

 

Lectures Covered: This assignment covers Lecture # 10 - 17

Deadline

Your assignment must be uploaded/submitted on or before 02/12/2019.

 

Question  Statement

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

You’re required to perform the following tasks:

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.     Consider the following two tables:

 

                              Order:

order_id

order_status

delivery_date

btag_no

cust_id

sman_id

od001

Completed

10/30/2019

bt001

cust001

sm001

od002

Completed

10/30/2019

bt002

cust002

sm001

od003

Completed

10/30/2019

bt003

cust003

sm001

 

                           Bill:

bill_id

cust_id

order_id

net_amount

b001

cust001

od001

500

b002

cust002

od002

550

b003

cust001

od003

600

 

And write the output of the following relational algebra operations:

·       ∏  order_id, cust_id, sman_id (Order)

·       σ net_amount > 500 (Bill)

·       ∏ order_status, delivery_date (σ btag_no= ‘bt002’ (Order))

 

3.     Find the degree and cardinality of the relations (Order and Bill) given in the 2nd question.

 

For any query about the assignment, contact at [email protected]

GOOD LUCK

 

How is this website, please share your feedback through this link: https://forms.gle/mZ5rsd995RxU2gEZ7


Quote
admin
(@admin)
Admin
Joined: 1 year ago
Posts: 1361
27/11/2019 5:05 pm  

CS403 Database Management System Assignment 2 Solution & Discussion Fall 2019


 

Students having same subject can start discussion here to Solve assignment quiz and can clear their concepts until solution is provided. 🖐️

How is this website, please share your feedback through this link: https://forms.gle/mZ5rsd995RxU2gEZ7


ReplyQuote
admin
(@admin)
Admin
Joined: 1 year ago
Posts: 1361
02/12/2019 9:57 pm  

CS403 Database Management System Assignment 2 Solution & Discussion Fall 2019


 

 

Download attachment for solution idea file for CS403.

How is this website, please share your feedback through this link: https://forms.gle/mZ5rsd995RxU2gEZ7


ReplyQuote
Arsalan Ahmed
(@arslan_ahmad14)
New Member
Joined: 5 months ago
Posts: 1
02/12/2019 11:20 pm  

@admin

is se acha tha rehny hi dety... agr upload krni hi thi file to bgair watermark k krty.


ats liked
ReplyQuote
admin
(@admin)
Admin
Joined: 1 year ago
Posts: 1361
03/12/2019 12:13 am  

CS403 Database Management System Assignment 2 Solution & Discussion Fall 2019


@arslan_ahmad14

 

Another solution idea file, will be useful if you get extended day!!!

 

How is this website, please share your feedback through this link: https://forms.gle/mZ5rsd995RxU2gEZ7


ReplyQuote
Share:

Please Login or Register