Assignment GDB Solution: CS403 Database Management Systems

loading...

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

CS403 Database Management Systems Assignment 2 Solution Spring 2014

Suppose we have a wireless ad hoc network. A wireless ad hoc network is a decentralized type of wireless network. The network is ad hoc because it does not rely on a pre existing infrastructure, such as routers in wired networks or access points in managed (infrastructure) wireless networks. Instead, each node participates in routing by forwarding data for other nodes, so the determination of which nodes forward data is made dynamically on the basis […]

CS403 Database Management Systems Assignment 1 Solution Spring 2014

Suppose we have a wireless ad hoc network. A wireless ad hoc network is a decentralized type of wireless network. The network is ad hoc because it does not rely on a pre existing infrastructure, such as routers in wired networks or access points in managed (infrastructure) wireless networks. Instead, each node participates in routing by forwarding data for other nodes, so the determination of which nodes forward data is […]