e.g. create two table 1-department(dept_id int PK,dept

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 / pawan k. dubey

1 Answers
5185 Views
HP, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What is indexing explain it with an example?

930

Explain the categories of stored procedure?

886

How to create an inline table-valued function?

907

What are the operating modes in which database mirroring runs?

1025

What is the maximum size of column in sql server?

844

What is a virtual table in sql?

943

What do you mean by a dependent functionality in a build?

1062

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

112

How do you test your database? : sql server database administration

950

What are the rendering extensions of ssrs?

142

Can I run multiple instances of sql server 2000 at the same time on one computer?

1023

What is difference between stored procedure and user defined function?

1029

Explain what is it unwise to create wide clustered index keys?

929

What are different types of views?

891

Can We Use Data-grids For Our Report In Ssrs?

177