Greetings

I'm a 4th-year Ph.D. candidate in Computer Science at the University of Toronto, working with Prof. Khai Truong in the DGP lab.

My research lies at the intersection of human–AI interaction, accessibility, and creativity support, with a special focus on improving music accessibility for d/Deaf and hard-of-hearing (DHH) individuals. My projects include song signing (CHI ’23) to explore how music is experienced and expressed within Deaf culture, and ELMI (CHI ’25), an LLM-supported English lyrics to ASL gloss translation system.

I completed my B.Sc. in Computer Science and Engineering at Ewha Womans University, where I was advised by Prof. Uran Oh (Human-Computer Interaction Lab) and Prof. Hyokyung Bahn (Distributed Computing and Operating Systems Lab).

Additionally, I worked as a research intern at Samsung AI Center Toronto, where I was mentored by Iqbal Mohomed, and at NAVER AI LAB under the supervision of Young-Ho Kim. Most recently, I interned at Adobe Research in the STORIE Lab, supervised by Anh Truong and Justin Salamon .

💼 I am currently exploring academic (Assistant Professor) and industry (Research Scientist) positions starting in Summer/Fall 2026.

Google Scholar | LinkedIn | suhyeon.yoo[at]mail.utoronto.ca

Labels

Database: Chinese Restaurant Sales DB (Spring, 2019)

Class: Database
Class Number: 20471-01
Date: Fall 2019
Professor: Ingi Lee
Main Idea: Chinese Restaurant Sales DB
-Make various queries on the database by using SQL grammar. 
-Model the real world as a database and create an ER schema. 
-Design and implement a database system to analyze and solve real problems.
Methods: MS SQL
Results: 


<Summary of Market Analysis>


[Analysis of commercial districts in Chinese restaurants]


Percentage of sales by age: The percentage of sales by age at Chinese restaurants is the largest at about 62 percent of people in their twenties.

Day-of-week sales ratio: The ratio of sales by day of the week at Chinese restaurants is similar on all days of the week, but among them, Tuesdays and Wednesdays account for about 16 percent.

Percentage of Sales by Gender: The ratio of sales by gender in the catering industry is 72 percent for women and 28 percent for men, with women accounting for the overwhelming majority.


[Analysis of commercial districts in Ewha Station: Analysis of Gender of Floating Population]


Floating Population by Age and Gender: The average of the floating population of women is higher than that of men in all age groups except under teens.

Floating population by gender by time zone: 14 o'clock is the most floating population for both women and men.

The floating population by gender by day of the week: Both women and men have a lower floating population on weekends than on weekdays, a large floating population on Wednesdays on weekdays, and a low floating population on Mondays.


<Customer Management SQL>

 

1.      Input:

 

INSERT

INTO 고객

VALUES ( 전화번호, 주소, 성별, 나이대)

 

 

2. Searching

 

SELECT *

FROM 고객

 

3. Searching with Phone #

 

SELECT *

FROM 고객

WHERE 전화번호 LIKE 입력된 전화번호


 

 



<Requirement Specification>


1. The counter collects the customer's phone number, address, gender, and age.

2. Customer information is collected per person, not per table.

3. Customers are identified by phone number.

4. Customer's address shall be classified only as a building block.

5. The age range is divided into 10~60s.

6. Customers can make a reservation.

7. Reservations must maintain reservation number, reservation time, number of reservations, and customer information.

8. The number of reservations is limited to a maximum of 30 people.

9. One customer can make one reservation.

10. Reservation times are limited from 10 am to 9 pm.












라벨:

Comments

Post a Comment