본문 바로가기
학부공부/Database

Development of Web-based DATABASE APPLICATION SYSTEM_System implementation [Toy project]

by sonpang 2022. 7. 5.
반응형

지역별 대학 연구시설 공유 시스템

 

0. 산출물

⚫ Source codes : Codiad

 

1. System DB implementation

1.1. Table schema information

 

1.2. Initial setting (for building a test environment)

The corresponding data creation function is not included within the scope of implementation, so the table data is directly created in Maria DB with SQL.

Note: Exclude special characters in all strings. The web page developed in this project has no SQL injection prevention code.

 

 

 

2. System Implementation

2.1. Final implementation function diagram

 

2.2. Site access example

 

NOTE: This site supports the equipment name, research classification number, research field main category, research field subcategory, and the university name of the equipment holding institution as search keywords.

 

 

 

2.3. Data in table after sample test in 2.2.

 

 

 

3. Source code summary

System Implementation Key Requirements

⚫ The search results for specific information should be implemented so that it can be viewed in two steps (simple information about the entire search result & detailed information about the specific search result).

⚫ When implementing a system, a function that requires two or more tables to be joined and processed (search, insert, modify, delete) must be included.

 

 

 

 

 

 

 

 

 

 

 

 

 

반응형

댓글