Course title
Y02500342
Data engineering

 NODA Natsuko
Middle-level Diploma Policy (mDP)
Program / Major mDP Goals
Department of Design Engineering E E 情報技術に関する高度な専門知識やデジタル技術を含む他の専門分野の知識・技術を活用し、構想を具体化するとともに、実現に向けた取り組みを行うことができる。
Purpose of class
The objective is to understand the fundamental concepts of databases and become capable of designing databases (creating ER diagrams) and querying databases (writing SQL). Furthermore, students will understand the basic concepts for big data processing.
Course description
In modern society, it is crucial to properly collect, analyze, and utilize the vast amounts of information generated daily. Database technology is essential for this purpose. This course focuses primarily on relational databases, the most widely used type, while also providing an introduction to new technologies required in the big data era.
Goals and objectives
  1. To understand data modeling and be able to draw appropriate entity-relationship diagrams.
  2. To understand database design and be able to define properly normalized tables.
  3. To understand SQL and be able to perform queries using SQL.
Relationship between 'Goals and Objectives' and 'Course Outcomes'

 Quiz Minute paper Exercises Report Total.
1. 10% 5% 15% 5% 35%
2. 10% 5% 10% 5% 30%
3. 10% 5% 15% 5% 35%
4. 0%
Total. 30% 15% 40% 15% -
Evaluation method and criteria
Comprehensive evaluation based on:
Quize conducted during each class (30%),
Minute papers submitted after each class (15%),
Comprehensive exercise assigned during class (40%),
And a report covering the entire course (15%).
Achieving 60% requires the ability to create relatively simple entity-relationship diagrams at the level covered in class and write simple queries in SQL.
Language
Japanese
Class schedule

 Class schedule HW assignments (Including preparation and review of the class.) Amount of Time Required
1. Database Fundamentals
What is a Relational Database? 		Review: Solve the review problems presented in class. 160minutes
2. ER diagram Review: Solve the review problems presented in class. 160minutes
3. Relational algebra Review: Solve the review problems presented in class. 160minutes
4. Normalization Review: Solve the review problems presented in class. 160minutes
5. SQL Review: Solve the review problems presented in class. 160minutes
6. Transactions and ACID Review: Solve the review problems presented in class. 120minutes
7. Databases in the Big Data Era (NoSQL, Data ETL, etc.) Review: Solve the review problems presented in class. 160minutes
Solve comprehensive exercises involving ER diagrams and SQL 80minutes
Prepare a report on the learning content 165minutes
Total. - - 1325minutes
Feedback on exams, assignments, etc.
ways of feedback specific contents about "Other"
Feedback in the class
Textbooks and reference materials
Materials published on ScombZ
Prerequisites
Office hours and How to contact professors for questions
  • Accepting questions and consultations via ScombZ
Regionally-oriented
Non-regionally-oriented course
Development of social and professional independence
  • Course that cultivates an ability for utilizing knowledge
Active-learning course
Most classes are interactive
Course by professor with work experience
Work experience Work experience and relevance to the course content if applicable
Applicable Leveraging experience gained as a researcher at a private company engaged in system development consultation, I teach the fundamentals of building systems for the appropriate utilization of data.
Education related SDGs:the Sustainable Development Goals
  • 9.INDUSTRY, INNOVATION AND INFRASTRUCTURE
Last modified : Sat Mar 14 14:30:58 JST 2026