Project

1 EMU Hacettepe Internship Informing & Feedback System

1.1 Teaser Trailer

1.2 Objective

Our database aims to facilitate the process of selecting and finding companies for internships for students of Industrial Engineering at Hacettepe University. To achieve this, we gather data and evaluations from students who have previously completed their internships at these companies. The information in our database allows students to know what they can expect to experience and what to expect within the opportunities provided by these companies. In addition to evaluations, our database also includes information about the application process for internship programs offered by relevant companies.

1.3 Application Features

  • Company Search: Users can search for companies offering internships based on various criteria such as location, industry, duration, and specific requirements.

  • Student Evaluation System: A platform where students can provide feedback and evaluations on their internship experiences, including ratings for different aspects such as work environment, mentor-ship, learning opportunities, and overall satisfaction.

  • Company Profiles: Detailed profiles for each company, including information about their internship programs, requirements, past interns’ experiences, and any additional benefits offered.

  • Analytics and Insights: Data analytics features to provide insights and trends based on the evaluations and feedback collected from students, helping to identify top-rated companies, popular internship programs, and areas for improvement.

1.4 Relations (Tables) and Their Attributes as an Initial Design

  1. Student

    • student_id (Primary Key)
    • first_name
    • last_name
    • email
    • join_year
    • gpa
Show the code 
library(RMySQL)
library(readr)
library(dplyr)
library(knitr)
library(lubridate)

# Set up the connection parameters
db_host <- "127.0.0.1"  # Localhost address
db_user <- "root"  # Your MySQL username
db_password <- ""  # Your MySQL password
db_name <- "emu415_ciphers"  # The name of your database

# Establish the connection
db_connection <- dbConnect(RMySQL::MySQL(), 
                           host = db_host,
                           user = db_user,
                           password = db_password,
                           dbname = db_name)
# Define the SQL query
sql_query <- "SELECT first_name, last_name, email, join_year FROM students ORDER BY first_name;"

# Execute the SQL query and retrieve the results
results <- dbGetQuery(db_connection, sql_query)

# Display the results
kable(head(results, 10))
first_name last_name email join_year
Ahad Tanay Uyar tanayuyar@hacettepe.edu.tr 2019
Ahmet Safa Çetin safacetin@hacettepe.edu.tr 2020
Arda Türkan ardaturkan@hacettepe.edu.tr 2020
Artun Üstünol artunustunol@hacettepe.edu.tr 2019
Ayşenur Eren aysenur.eren@hacettepe.edu.tr 2019
Begüm Bahçekapılı begumbahcekapili@hacettepe.edu.tr 2020
Berkant Aytemir berkant.aytemir@hacettepe.edu.tr 2019
Ceren Arslan arslan.ceren@hacettepe.edu.tr 2020
Dilan Su Fırat sufirat@hacettepe.edu.tr 2019
Doğa Oral doral@hacettepe.edu.tr 2019

  1. Company

    • company_id (Primary Key)
    • company_name
    • industry
    • location
    • contact_info
    • website
Show the code 
# Define the SQL query
sql_query <- "SELECT company_id, company_name, industry, location, contact_info FROM companies;"

# Execute the SQL query and retrieve the results
results <- dbGetQuery(db_connection, sql_query)

# Display the results
kable(head(results, 10))
company_id company_name industry location contact_info
1 Roketsan Defense Elmadağ/Ankara 312 860 5500
2 Baykar Mak. Aerospace Esenyurt/İstanbul 212 867 0900
3 RND Yazılım ve E-Ticaret E-Commerce Kağıthane/İstanbul 212 324 2440
4 Karsan Automotive Nilüfer/Bursa 224 280 3000
5 Nurus Furniture Söğütözü/Ankara 312 447 62 32
6 Türk Havacılık ve Uzay Sanayii(TUSAŞ) Aerospace Kahramankazan/Ankara 312 811 18 00
7 Türk Traktör Automotive Etimesgut/Ankara 312 233 33 33
8 Makine ve Kimya Endüstrisi A.Ş. Ammo Gazi/Ankara 312 296 10 00
9 SAP Software Üsküdar/İstanbul 216 633 04 74
10 Aselsan Defense Macunköy/Ankara 312 592 10 00

  1. Internship

    • internship_id (Primary Key)
    • student_id (Foreign Key)
    • company_id (Foreign Key)
    • intern_type
    • department
    • year
    • start_date
    • end_date
    • duration
    • income
    • working_hours
    • transportation_status
Show the code 
# Define the SQL query
sql_query <- "SELECT internship_id, student_id, company_id, intern_type, department, start_date, end_date FROM internships;"

# Execute the SQL query and retrieve the results
results <- dbGetQuery(db_connection, sql_query)

# Display the results
kable(head(results, 10))
internship_id student_id company_id intern_type department start_date end_date
1 21948451 6 Üretim Lojistik Haziran Temmuz
2 2200469816 8 Üretim Üretim Haziran Temmuz
3 2200469005 16 Yönetim E-Ticaret Temmuz Ağustos
4 21948484 17 Üretim Üretim Haziran Temmuz
5 21948011 18 Üretim Üretim Ağustos Eylül
6 2200469011 19 Üretim İş Geliştirme Ağustos Ağustos
7 21947861 20 Üretim Üretim Temmuz Ağustos
8 2200469058 21 Yönetim Üretim Planlama Temmuz Ağustos
9 21948044 22 Üretim Lojistik Temmuz Ağustos
10 21948317 23 Yönetim Quality Assurance/ Software Testing Temmuz Ağustos

  1. Rating

    • rating_id (Primary Key)
    • internship_id (Foreign Key)
    • transportation_rating
    • work_env_rating
    • learning_opp_rating
    • food_rating
    • hr_rating
    • mentor_rating
    • comment
Show the code 
# Define the SQL query
sql_query <- "SELECT rating_id, transportation_rating, work_env_rating, learning_opp_rating, food_rating, hr_rating, mentor_rating FROM ratings;"

# Execute the SQL query and retrieve the results
results <- dbGetQuery(db_connection, sql_query)

# Display the results
kable(head(results, 10))
rating_id transportation_rating work_env_rating learning_opp_rating food_rating hr_rating mentor_rating
1 5 4 5 5 3 5
2 3 3 3 3 3 3
3 5 5 5 5 5 5
4 3 3 2 4 5 5
5 4 2 1 5 3 1
6 3 5 5 4 4 5
7 3 3 4 5 4 1
8 3 4 3 2 4 4
9 3 3 2 3 4 4
10 1 5 5 1 5 5

1.5 Relationships

  • internships belongs to company: One-to-many relationship, each company can offer multiple internships, but each internship is associated with only one company.

  • internship belongs to student: One-to-many relationship, one student can have multiple internships, but each internship is associated with only one student.

  • rating belongs to internship: One-to-one relationship, each internship has one rating, and each rating is associated with only one internship.

  • student to rating through internship: One-to-many relationship, each student can have many ratings as well as internships, but each rating can only have one student and one internship.

  • company to rating through internship: One to many relationship, each company can have many ratings as well as internships, but each rating can only have one company and one internship.

1.6 Entity-Relationship Diagram

1.7 Schema Design

Back to top