Course title
Y02500342
Data engineering

 NODA Natsuko
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.
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.
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% -
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
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.
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
Review the course content from Information Processing Exercises, Programming, and other classes.
Research what a "database" is and how it is used in the real world.
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
About half of the 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 : Fri Nov 21 04:04:25 JST 2025