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?
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 |
Is oracle faster than sql server?
what happens on checkpoint? : Sql server database administration
what is for foreign key ??
4 Answers CarrizalSoft Technologies, Sabic,
What is blocking and how would you troubleshoot it?
Explain intellisense for query editing
What is updatable resultset?
What is ddl command?
Why is normalisation important?
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
What stored procedure would you use to view lock information?
1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?
Give me a SQL Query to find out the second largest company?