Course Description

In this course, you will learn about database, a mechanism which enables to effectively store and retrieve data. Specifically, you will learn the following.
* Basic Concepts of Databases
* Models of Database
* Query language for Database
* Design of Relational Database and Operation of data
You will acquire knowledge and skills on DP2 and DP3 of diploma policies.

Course Objectives

The goal is to understand the basic concepts of databases required for complex information processing and the basic mechanism of database systems so that you can apply them. You will be required to acquire the following skills when completing the course.
* You can explain concepts about relational models (relation, keys, functional dependencies, relational algebra).
* You can perform simple retrieval and output by using SQL, a relational database language.
* You can explain concepts of an entity-relationship model and methods to design a relational database with it.
* You can explain the background of normalization and the features of the third normal form.

Grading Policy

Your grade will be assessed based on the scores of final exams (60%), small test and exercise problems (40%).
However, if you do not meet the following two conditions, you will be failed regardless of your grade.
(1) You must pass all tasks (small tests in every class).
(2) You must get score in the final exams at least 60%.
You will receive elucidations and evaluations in the LMS.

Textbook and Reference

Requirements(Assignments)

For the preparation, you should read through the teaching materials. (1.5 hours)
After the class, you should review and work on the assignment in order to improve your understanding. (1.5 hours)

Note

The lesson materials and scope of each class will be notified on LMS.
Textbook is written in Japanese, so you need to understand the text book or find another textbook by yourself.

Schedule