| Academic Year |
2024Year |
School/Graduate School |
School of Informatics and Data Science |
| Lecture Code |
KA126001 |
Subject Classification |
Specialized Education |
| Subject Name |
データベース |
Subject Name
（Katakana） |
データベース |
Subject Name in
English |
Databases |
| Instructor |
HIRASHIMA TSUKASA |
Instructor
(Katakana) |
ヒラシマ ツカサ |
| Campus |
Higashi-Hiroshima |
Semester/Term |
2nd-Year, Second Semester, 4Term |
| Days, Periods, and Classrooms |
(4T) Weds1-4：ENG 220 |
| Lesson Style |
Lecture |
Lesson Style
(More Details) |
|
| Lecture, On-line report submission with moodle． |
| Credits |
2.0 |
Class Hours/Week |
|
Language of Instruction |
B
:
Japanese／English |
| Course Level |
2
:
Undergraduate Low-Intermediate
|
| Course Area（Area） |
25
:
Science and Technology |
| Course Area（Discipline） |
02
:
Information Science |
| Eligible Students |
2nd grade |
| Keywords |
Database, Modeling, relational database, SQL |
| Special Subject for Teacher Education |
|
Special Subject |
|
Class Status
within Educational
Program
(Applicable only to targeted subjects for undergraduate students) | |
|---|
Criterion referenced
Evaluation
(Applicable only to targeted subjects for undergraduate students) | Program of Electronic Devices and Systems
（Abilities and Skills）
・Ability to apply basic concepts, knowledge, and methods of electronics engineering to concrete/technical problems.
Computer Science Program
（Knowledge and Understanding）
・D1. Knowledge and ability to understand the theoretical framework underlying computer science and to collect and process high-dimensional data through full use of information processing technology based on scientific logic.
Data Science Program
（Abilities and Skills）
・A. Information infrastructure development technology, information processing technology, technology that analyzes data and creates new added value.
Intelligence Science Program
（Knowledge and Understanding）
・D1. A deep systematic understanding of the advanced intelligence of human beings and its realization by computers. |
|---|
Class Objectives
/Class Outline |
Learn relational database as a method to digitalize real world. |
| Class Schedule |
lesson1
What is data? What is information?
lesson2
Data model to digitalize real world
lesson3
Entity-Relation Model(1)
lesson4
Entity-Relation Model(2)
lesson5
Relational Data Model
lesson6
Constraint Function of Relational Data Model
lesson7
Relational Algebra(1)
lesson8
Relational Algebra(2)
lesson9
Relational Algebra(3)
lesson10
Normalization of Relational Schema(1)
lesson11
Normalization of Relational Schema(2)
lesson12
Normalization of Relational Schema(3)
lesson13
Exercise of SQL(1)
lesson14
Exercise SQL(2)
lesson15
Exercise SQL(3) |
Text/Reference
Books,etc. |
Handout is provided(on moodle) |
PC or AV used in
Class,etc. |
|
| (More Details) |
|
| Learning techniques to be incorporated |
|
Suggestions on
Preparation and
Review |
Learn about (1) background of database, (2) theory of database and (3) practical use of SQL. |
| Requirements |
|
| Grading Method |
Evaluation based on several reports in class and a semester test. |
| Practical Experience |
|
| Summary of Practical Experience and Class Contents based on it |
|
| Message |
|
| Other |
|
Please fill in the class improvement questionnaire which is carried out on all classes.
Instructors will reflect on your feedback and utilize the information for improving their teaching. |