Assignment GDB Solution: CS403 Database Management Systems

loading...

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

CS403 Database Management Systems GDB Solution Fall 2013

Suppose there are two entities “building” and “apartment”. The entity “apartment” is dependent entity and cannot exist independently and “building” is an independent entity. The “apartment” entity contains the primary key (building_name) of building entity to identify the apartment of that specific building. The “apartment” entity also has its own identifier, i.e. apartment_no but that identifier is not sufficient […]

CS403 Database Management System Assignment 4 Solution Fall 2013

Objectives The objective of this assignment is: Giving the idea of the most commonly used RDBMS for designing physical database systems i.e. SQL SERVER. It is used to design systems physically either through Query Analyzer OR Enterprise Manager. Important things to consider before doing this assignment:  This Assignment is the continuation of third Assignment. Taking […]