Course title
M02240002
Database Systems

LAOHAKANGVALVIT TIPPORN
Middle-level Diploma Policy (mDP)
Program / Major mDP Goals
(改組前)先進国際課程 A-1 A-1 Students shall obtain basic and advanced knowledge and skills in mathematics, natural and computer sciences as well as presentation skills to communicate on their knowledge with scholars from various fields.
先進国際課程 A-1 A-1 Students shall obtain basic and advanced knowledge and skills in mathematics, natural and computer sciences as well as presentation skills to communicate on their knowledge with scholars from various fields.
先進国際課程 A-2 A-2 To suitably lead an international team in the future, students will be able to consider and make decisions on issues in various kinds of problems by grasping what kind of problems are tackled to solve in what way in a wide range of fields in science and technology.
(改組前)先進国際課程 A-2 A-2 To suitably lead an international team in the future, students will be able to consider and make decisions on issues in various kinds of problems by grasping what kind of problems are tackled to solve in what way in a wide range of fields in science and technology.
先進国際課程 B B Ability to understand, respect, and accept diversity in a global society, and cooperate with people from various backgrounds for international teamwork.
(改組前)先進国際課程 B B Ability to understand, respect, and accept diversity in a global society, and cooperate with people from various backgrounds for international teamwork.
Purpose of class
Students are expected to obtain knowledge, understanding, and technical skills to design and develop a program to manage and operate database. Also, students are aim to understand the role of database systems in real-world applications.
Course description
This course provides principles, design, implementation, and management of databases, which are fundamental to modern information systems. Students will gain proficiency in Structured Query Language (SQL) for data manipulation and retrieval within relational databases. Through lectures, hands-on exercises, and projects, students will develop practical skills in database design, implementation, and management. This course prepares students for careers in software development, data analysis, and information management.
Goals and objectives
  1. Students can explain fundamental knowledge about database design and implementation techniques.
  2. Students can effectively use SQL for database implementation, manipulation and retrieval.
  3. Students can apply theoretical concepts to design and implement a database system for real-world applications.
Relationship between 'Goals and Objectives' and 'Course Outcomes'

Assignments Mid-term Examination Final Project Total.
1. 10% 10% 5% 25%
2. 10% 10% 15% 35%
3. 10% 10% 20% 40%
Total. 30% 30% 40% -
Evaluation method and criteria
Assignments will contribute 30% of the grade.
Mid-term examination and final project will contribute 70% of the grade.
*Those who get at least 60% of the total score will receive the credits of this course.
Language
English
Class schedule

Class schedule HW assignments (Including preparation and review of the class.) Amount of Time Required
1. Introduction to database systems Review after class and do assignment 190minutes
2. Database concepts and architectures Review after class and do assignment 190minutes
3. Database design and modeling Review after class and do assignment 190minutes
4. Entity-Relationship (ER) diagram Review after class and do assignment 190minutes
5. Database storage, indexing, and normalization Review after class and do assignment 190minutes
6. SQL language (1) Review after class and do assignment 190minutes
7. Mid-term examination & Discussion on solutions Review all previous classes and prepare for examination 220minutes
8. SQL language (2) Review after class and do assignment 190minutes
9. Query processing and optimization Review after class and do assignment 190minutes
10. Tools for implementing database management systems (DBMS) Review after class and do assignment 190minutes
11. Project-based Learning: Requirement gathering and design of DBMS Work on project 190minutes
12. Project-based Learning: Implementation of DBMS & Progress report on design Work on project 190minutes
13. Project-based Learning: Implementation of DBMS & Progress report on implementation Work on project 190minutes
14. Course review & Final project presentation and discussion Preparation for presentation and discussion 220minutes
Total. - - 2720minutes
Feedback on exams, assignments, etc.
ways of feedback specific contents about "Other"
Feedback outside of the class (ScombZ, mail, etc.)
Textbooks and reference materials
Fundamentals of Database Systems (7th Edition). Ramez Elmasri and Shamkant B. Navathe. Pearson (2015).
Prerequisites
Knowledge and experience to develop a basic web application is required, as the final project will involve developing web-based database management systems.
(*Review on the basic web programming will not be provided.)
Office hours and How to contact professors for questions
  • Office hours: After class or by appointment
    For appointment, please contact me by e-mail: tipporn@shibaura-it.ac.jp
Regionally-oriented
Non-regionally-oriented course
Development of social and professional independence
  • Course that cultivates an ability for utilizing knowledge
  • Course that cultivates a basic problem-solving skills
  • Course that cultivates a basic interpersonal skills
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
N/A N/A
Education related SDGs:the Sustainable Development Goals
  • 4.QUALITY EDUCATION
Last modified : Sat Mar 14 13:55:00 JST 2026