Tuesday, 29 May 2018

CS403-DBMS | Assignment no 2 Solution | Spring 2018 | Due date: 28 may, 2018

CS403-DBMS 
Assignment no 2 Solution
Spring 2018 
Due date: 28 may, 2018

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).