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

What is the difference between a unique key and primary key?

0 Answers  

What is create statement?

0 Answers  

How to turn off warning messages during php execution?

0 Answers  

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

Call by value and call by reference in procedure and function, with NOCOPY.

0 Answers   Nagarro,

What is the default value of CHAR type?

10 Answers   Bosch,

How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 Answers  

Please explain what is “asynchronous” communication in sql server service broker?

0 Answers  

how can i store resumes in database?

3 Answers   HCL,

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories