Assignment No. 02
Semester: Spring 2018

CS403 – Database Management Systems

 

Uploading instructions:

 

·         Your assignment should be in .doc /.docx format.

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

·         No assignment will be accepted through email.

 

Rules for Marking:

 

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

1.      The assignment is submitted after due date

2.      The assignment is copied

3.      The assignment solution does not have own VU-ID as database name

4.      The assignment solution has other student ID

Objectives

The motive of this assignment is to enable students how to transform ER data model in to Relations with Primary Foreign key constrains. It will also help the students to understand Basic Operators of Relational Algebra and Join Operations.

 

Important things to consider before doing this assignment: 


This assignment is based on the previous scenario (Assignment No.1 solution).      

                                  

You are required to thoroughly observe the ERD as above ( solution of assignment No.1) and provide solution of the following tasks:

 

  1. Map all entities into Relations with Primary, Foreign key constrains where possible.
  2. Consider the below populated relations. Perform the cross product on SERVICES and EVENT relations by providing the resultant relation.

3.      Apply projection operation on SERVICES relation and provide resultant relation. I-I serID , serCharges (SERVICES)

4.      Take Union of SERVICES and EVENT relations and provide output.

 

SERVICES

serId

serTitle

serDescription

serCharges

01

Food and beverage

Class B

200$

02

Food and beverages

Class A

300$

03

Room upgrades

Economic

150$

 

EVENT

eventId

Date

timeSlot

Cx01

12.5.2018

11:00 am

Bs03

25.5.2018

12:00 pm

 

 

 

 

Deadline: Your assignment must be uploaded/submitted on or before May 28, 2018.

Views: 483

Attachments:

Replies to This Discussion

pls uplaod idea for solution

RSS

Discussion Forum

CS403 Finalterm Papers from Sep 1st to 13th, 2018

Started by + caмe4ѕтυdιeѕ.
Last reply
by + caмe4ѕтυdιeѕ Sep 5. 4 Replies

Graded Discussion Board (GDB) of CS403

Started by +.ïɳnόϲϵᴎԎ ɖόІІ.+.
Last reply
by +.ïɳnόϲϵᴎԎ ɖόІІ.+ Jul 26. 1 Reply

cs403 assignment no: 3

Started by +.ïɳnόϲϵᴎԎ ɖόІІ.+.
Last reply
by +.ïɳnόϲϵᴎԎ ɖόІІ.+ Jul 12. 2 Replies

SPONSORED LINKS

© 2018   Created by Muhammad Anwar Tahseen.   Powered by

Badges  |  Report an Issue  |  Terms of Service