|
This course covers the fundamental concepts of database systems. One major objective is to acquaint the students with the use of current relational database systems, which is closely related to usage of the query language called SQL. Topics also include principles and methodologies of database design, and techniques for database application development.
|
|
|
Upon completion of this course, participants will have gained knowledge of database system concepts and the ability to:
• understand the basics of digital data recording
• understand the basics of logical operation
• understand the basic structures of existing databases
• effectively search existing databases using SQL
• understand new user requirements/views
• develop the conceptual data model
• apply normalization techniques
• implement a new database
|
|
|
A: Basic knowledge and understanding of various sciences subjects ○
B: The ability to think logically and creatively ◎
C: The ability to communicate effectively △
D: Gained a sense of social ethics and an international perspective △
E: Understanding of various issues in the information society and the ability to utilize informatics knowledge △
F: Knowledge of social organizations and systems and the ability to analyze them by a social scientific approach ○
G: Basic knowledge of data science and the ability to propose social implementation ○
H: Knowledge base for creating and utilizing information technology ◎
I: The ability to formulate tasks based on humanistic and informatics knowledge and search for practical philosophy △
J: The ability to discover issues and propose social systems utilizing social science knowledge ○
K: The ability to solve problems through data collection, analysis and mathematical optimization ○
L: Knowledge of computations and information and the ability to develop technology related to computers ◎
（◎：Especially important，〇：Important，△：Subject to evaluation，―：Not subject to evaluation）
|
|
|
You will be lectured on
・basic commands and terms for using relational database systems
・And how to use them to create and maintain your own database
|
|
|
|
This course based on lectures and programming exercises. Students are expected to bring their computer.
|
|
|
|
|
| No. | 内容 |
| 第1回 |
Introduction
|
| 第2回 |
Single Table Queries (1)
|
| 第3回 |
Single Table Queries (2)
|
| 第4回 |
Single Table Queries (3)
|
| 第5回 |
Multiple Table Queries (1)
|
| 第6回 |
Multiple Table Queries (2)
|
| 第7回 |
Multiple Table Queries (3)
|
| 第8回 |
Creation and Manipulation of Database(1)
|
| 第9回 |
Creation and Manipulation of Database(2)
|
| 第10回 |
Creation and Manipulation of Database(3)
|
| 第11回 |
Design and Management of Database (1)
|
| 第12回 |
Design and Management of Database (2)
|
| 第13回 |
Design and Management of Database (3)
|
| 第14回 |
Practical Exercise (1)
|
| 第15回 |
Practical Exercise (2)
|
| 第16回 |
Examination
|
|
|
|
|
This is a normal 2-credit course, which basically means that in addition to the scheduled meeting times, students are expected to do at least 3 hours of course-related work outside of class each week during the session. This includes work done completing assigned readings, preparing written/programming assignments, studying for tests and examinations, and other course-related tasks.
|
|
|
40%: Written and programming assignments [A, B, C, D, E, F, G, H, I, J, K, L]
60%: Tests and the final paper-based examination [A, B, C, D, E, F, G, H, I, J, K, L]
|
|
|
|
This course is offered for senior or higher grade students.
|
|
|
|
|
|
Relational Database, SQL, ER Model, DB normalization
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This course uses printed or electronic materials in place of textbooks.
|
|
|
|
|
|
|
|
The electronic materials for this course are distributed via Moodle.
|
|
|
|
|
Lecture: Japanese
Text and Materials: Japanese
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|