Shilian real estate Software Engineer Test Questions

1. assume that there are two types of system users: finance personnel and customer personnel, and each system user can query documents. However, the query between finance personnel and customer personnel is different. Please use system users as the basis, finance and customer service personnel are derived classes. C # is used to show how to use polymorphism to process query documents.

2. Assume that the database server is dataserver1, the database is sqlserver db1, the username is test1, And the password is test. To perform a group of operations on the database, you need to execute the transaction. UseCodeImplementation in ADO. net

3. Use Asp.net to use the HTTP request corresponding to IIS, and interact with the background database. Just draw the basic structure.

4. The Planning Department has the following levels of personnel: Deputy Director, Planning Manager, Project Manager, planning personnel, and Planning Assistant. Please design the database structure to meet the following requirements:
A. Each employee has multiple superiors and can manage multiple subordinates.
B. It is convenient to query lower-level employees of a certain leader (implemented using stored procedures)
Write related SQL statements