Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Suppose in a situation if two list boxes are there and if
you select multiple options based on that the options
related to those selected items should display in second
list box.

Again if we select multiple items in second listbox then the
related to those selected items should display .

In this scenario how will you design database,tables?

Question Posted / swapna


Suppose in a situation if two list boxes are there and if you select multiple options based on that..

Answer / pawan k. dubey

e.g. create two table
1-department(dept_id int PK,dept_name)
2-employee(emp_id int Primary key,Name varchar(40),dept_id
FK)

now create two listbox employee and department.

step1-when multiple departments are selected...dispaly
employee related to selected department in employee listbox

step2-when multiple employees are selected...dispaly
respective department in department listbox

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How to insert new line characters into strings?

0 Answers  

What is the stored procedure?

0 Answers  

How you can move data or databases between servers and databases in sql server?

0 Answers  

Can you name some of the dml commands in sql?

0 Answers  

internal language used in sql server 2000?

2 Answers  

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

How dts is used to extract, transform and consolidate data?

0 Answers  

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

Do you know query execution plan?

0 Answers  

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  

How many columns can we include on clustered index ?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories