Course title
FL0010003
Database Systems

 KIMURA Masaomi
Middle-level Diploma Policy (mDP)
Program / Major mDP Goals Courses
Fundamental Mechanical Engineering F 産業界や社会の要請を把握して解決するべき課題を設定し、さまざまな工学分野の知識を関連付けながら設計生産技術を活用することで、立案した構想に従って研究を進め課題を解決することができる。 Sub
Advanced Mechanical Engineering F 産業界や社会の要請を把握して解決するべき課題を設定し、機械工学の学理を応用して異分野を含む融合分野で革新的な機能を創成することができる。 Sub
Environment and Materials Engineering B 地球環境や地域社会との調和を見据えて、さまざまな工学分野に関わる問題を解決することができる。 Sub
Chemistry and Biotechnology B 地球環境や地域社会との調和を見据えて、さまざまな工学分野に関わる問題を解決することができる。 Sub
Electrical Engineering and Robotics D 電気工学や関連する工学の技術分野を課題に適用し、社会の要求を解決するために応用することができる。 Sub
Advanced Electronic Engineering E 専門的デザイン課題について解決する能力を身に付けることができる。 Sub
Information and Communications Engineering A-4 情報処理の基礎知識を広く活用することができる。 Main
Computer Science and Engineering B-2 コンピュータサイエンスの各分野の基礎知識とその応用能力を身に付けることができる。 Main
Urban Infrastructure and Environment G ⼟⽊⼯学における現実の問題について、⼯学・専⾨基礎知識を⽤いて理解・解決することができる。 Sub
Purpose of class
To understand the fundamental knowledge of databases
Course description
In this class, students will learn the database system, which plays an important role in the information society. We focus on the topics of a relational database, such as its fundamental concepts, data modeling, design theories, queries, data recovery, operation management and applications.
Goals and objectives
  1. Students can make suitable ER models
  2. Students can normalize tables
  3. Students understand SQL and can make SQL queries
  4. Students can explain the important concepts, such as file organization, query optimization and transactions.
Relationship between 'Goals and Objectives' and 'Course Outcomes'

 Final exam Short test Total.
1. 20% 5% 25%
2. 20% 5% 25%
3. 20% 5% 25%
4. 20% 5% 25%
Total. 80% 20% -
Evaluation method and criteria
Short test and final exam
・For final exam, students cannot bring textbooks and notebooks
Language
Japanese
Class schedule

 Class schedule HW assignments (Including preparation and review of the class.) Amount of Time Required
1. What is a database? Read Chap.1 of textbook 190minutes
2. Relational data model
・ER model 		Read Chap.2 of textbook 190minutes
3. Data manipulation language and relational algebra Read Chap.3 of textbook 190minutes
4. Data modeling practice and relational design theory (1)
・First normal form
・Multivalued dependency, functional dependency
・Modification anomaries 		Read Chap.4 of textbook 190minutes
5. Relational design theory (2)
・Second normal form
・Third normal form
・Non-loss decomposition
・Fourth normal form 		Read Chap.5 of textbook 190minutes
6. SQL Read Chap.5 of textbook 190minutes
7. SQL practice (1)- SELECT
SQL practice (2)- INSERT, UPDATE, DELETE 		Read Chap.5 of textbook 190minutes
8. DBMS architecture and function Read Chap.6 of textbook 190minutes
9. File access and organization
・ISAM
・B+ Tree
・HASH 		Read Chap.7 of textbook 190minutes
10. Practice on file access
・data addition/deletion in B+ Tree 		Read Chap.8 of textbook 190minutes
11. Query optimization
・Cost evaluation
・Nested loop
・Marginal sort 		Read Chap.9 of textbook 190minutes
12. Transactions and recovery
・transactions
・ACID
・log
・recovery 		Read Chap.9 of textbook 190minutes
13. Concurrency control of transactions/database operation practice
・Serializability of schedules
・Lock/dead lock 		Read Chap.10 of textbook 190minutes
14. Exam and commentary Review the textbook and distributed materials 190minutes
Total. - - 2660minutes
Feedback on exams, assignments, etc.
ways of feedback specific contents about "Other"
Feedback in the class
Textbooks and reference materials
Yoshifumi Masunaga, ”Introduction of relational database” Science sha, 2006, (Japanese)
Prerequisites
Descrete mathematics, Data Structure and Algorithms 1 and 2, Fundamental Exercise on Computer and Information Engineering 1A and 2A, Advanced Programming, Exercise on Advanced Programming
Office hours and How to contact professors for questions
  • 13:00-14:30 on Friday in Laboratory Room 13-O-32
Regionally-oriented
Non-regionally-oriented course
Development of social and professional independence
  • Course that cultivates an ability for utilizing knowledge
Active-learning course
More than one class is interactive
Course by professor with work experience
Work experience Work experience and relevance to the course content if applicable
Applicable The professor with experience in an SI company lectures knowledge and ideas necessary to understand and design database systems used in a large information system.
Education related SDGs:the Sustainable Development Goals
  • 9.INDUSTRY, INNOVATION AND INFRASTRUCTURE
  • 12.RESPONSIBLE CONSUMPTION & PRODUCTION
Last modified : Tue Mar 24 04:05:30 JST 2026