Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 5200 Views
- HP, I also Faced
- E-Mail Answers
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 |
What is difference in performance between insert top (n) into table and using top with insert?
What is difference between inner join and full join?
Can you index views?
write the query for taking database backup in sql
10 Answers ABC, IBM, Logica CMG, MA,
Can you explain various data region available in ssrs with their use?
What's the difference between a primary key and a unique key?
How to create new table with "create table" statements?
Why should one not prefix user stored procedures with ‘sp_’?
What is difference between equi join and natural join?
What’s the distinction between dropping a info and taking a info offline?
Does partitioning improve performance?
Does a sql server 2005 select statement require a from?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
