DataBase_2021_2

CONSULTATION(Consultation Service)

This is an introduction page of Consultation Service 'CONSULTATION'

---

Kyungpook National University

[COMP322]Introduction to Databases Fall' 2021

Team 4 - Consultation Service : Project

---

1. WHAT IS CONSULTATION?

consultation booking service in university

---

2. DEVELOPER

권도용

박정식

최민중

---

3. CODE LINK

access to jsp files

---

4. DEVELOPMENT ENVIRONMENT

1. OS

• windows10

2. DBMS

• Oracle

3. Language

• SQL
• java
• html
• javascript

---

5. HOW TO INSTALL & RUN

build a database

ddl.sql
insert.sql

run

login.jsp

---

6. DEMO

Youtube Link: https://www.youtube.com/watch?v=e4Wo-IMcFY4

---

7. STUDENT

1. sign in

• insert student id
• insert password
• insert university code

2. main page

• access mypage
• search scheduled consultation
• view consultation recommendations

3. my page

• view my consultation and update consultation information or cancle consultation
• view my account and update password

4. search scheduled consultation

• select consultation type
• insert professor's name

5. select consultation between scheduled schedules and insert information for counsultation with specific professor

---

8. PROFESSOR

1. sign in

• insert student id
• insert password
• insert university code

2. main page

• access mypage
• view my scheduled consultation
• create new schedule
• delete schedule

3. my page

• view my account and update password

---

9. ADMINISTRATOR

1. manage database