Virtual University of Pakistan Study forum !
Assignment No. 02
CS403 – Database Management Systems
· 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
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:
You are required to thoroughly observe the ERD as above ( solution of assignment No.1) and provide solution of the following tasks:
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.
Deadline: Your assignment must be uploaded/submitted on or before May 28, 2018.