Hiroshima University Syllabus

Back to syllabus main page
Japanese
Academic Year 2020Year 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 Bb9. 
Credits 2 Class Hours/Week   Language on Instruction J : Japanese
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
 
Criterion referenced
Evaluation
Program of Electronic Devices and Systems
(Abilities and Skills)
・Ability to apply basic concepts, knowledge, and methods of electronics engineering to concrete/technical problems.

Informatics and Data Science Program
(Knowledge and Understanding)
・I1. Knowledge and ability required for collecting and processing high-dimensional data using information processing technologies based on scientific logic, while understanding the theoretical system that forms the basis of informatics.
 
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 
PC or AV used in
Class,etc.
handout, projector, Laptop computer as a Requisite Tool to use Bb9
 
Suggestions on
Preparation and
Review
Learn about (1) background of database, (2) theory of database and (3) practical use of SQL. 
Requirements Bring a Laptop computer as a Requisite Tool
 
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. 
Back to syllabus main page