Assignment GDB Solution: CS403 Database Management Systems


CS403 Assignment 2 Solution Spring 2018

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 […]

CS403 Assignment 1 Solution Spring 2018

Question   Trend of celebrating events in Pakistan is changing rapidly. People got more conscious about the event related arrangements. They spend more time, energy and money to make their events memorable and different from others. Event planners are hired to make events more organized, memorable and ostentatious. “Traditions” is a newly established event planning […]

CS403 Assignment 1 Solution 2017

Question  (Marks:  10 +10)  Consider that you are working as a database designer in a software company. Your company has given the project for developing an application for the Election Commission of Pakistan. The application would enable the citizen of Pakistan to cast vote through this application.  Keeping in view that a citizen of age […]

CS403 Assignment 3 Solution Spring 2017

Assignment No. 03 Semester: Spring 2017 CS403 – Database Management Systems   Total Marks: 20 Due Date: 21/07/2017 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 […]

CS403 Assignment 2 Solution Spring 2017

 Question:     (15 Marks) A public sector hospital wants to automate its manual paper based operations to speed up the operations and facilitate its patients and staff members. For this purpose, they want to develop a database for their hospital management system to remove paper based records. Now, you are required to analyze the following scenario […]

CS403 GDB Solution Feb 2015

The University of Texas is going to develop an application for its Alumnae Association as recently it has acquired a state of the art data center. The information may be like student name its region or current location of residence since it has a large record of Alumnae in manual form. Which indexing technique will […]

CS403 Database Management Systems Assignment 2 Solution

Question 1    [20 Marks] Read the two scenarios given below and identify the Entities and then identify Attributes related to these entities and hence draw the Entity Relationship Diagram (ERD) in both cases given below. a) A company has a number of employees having their name, address and date of birth. The company has several […]

CS403 Database Management Systems Assignment 1 solution Fall 2014

Question 1                                                                                            [15 Marks]   Read the following requirements carefully […]

CS403 Database Management Systems GDB Solution Spring 2014

Suppose we have a table “Employee” having column “age” in it. The table “employee” might have a data of different age groups according to their designations. The employee at high levels of post like Project Manager, Managing director etc has different age group when we are comparing it with other junior or senior level employees. […]

CS403 Database Management Systems Assignment 4 Solution Spring 2014

Task Description:  In this assignment you will focus only on the tasks given below: Node_Info Node_id Node_role Protocol_id 01 Source 11 02 Source 12 03 Destination 13 04 Destination 14   Protocol_Info Protocol_id Protocol_name Protocol_version 11  AODV 2.1 12 DSR 1.1 13 DSDV 1.5 14 AODV 1.1 15 DSR 1.2   Open the Query Analyzer/SQL […]