| １． |
Outline |
|
In this course, you will learn about database, a mechanism which enables to effectively store and retrieve data. Specifically, you will learn the following.
* Information models and systems
* Database systems
* Data modelling and relational databases
* SQL, a relational database language
* Design of databases and operations of data
These serve as a basis for knowledge and skills on DP4C and DP4M.
|
| ２． |
Objectives |
|
The goal of this course is to understand basic concepts about databases necessary complex information processing and fundamental mechanisms of database systems, so that you will be able to utilize 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.
In each class, you will receive instructions from the lecturer, make explanation about learning materials by yourself, and answer quizzes.
|
| ３． |
Grading Policy |
|
Your grade will be assessed based on the score of the mastering examination and evaluations of tasks. To earn the credits, you must satisfy the following three conditions.
(1) You must attend the specified number of or more classes.
(2) You must pass all tasks (quizzes in every class).
(3) You must obtain the score equal to or higher than the qualifying score (60%).
You will receive elucidations and evaluations in the LMS.
|
| ４． |
Textbook and Reference |
|
You need the following textbook.
Haruo Hayami, Nobuyoshi Miyazaki, and Haruaki YAmazaki, IT Text Databases, Ohmsha, ISBN 978-4-274-13254-4
You also use materials provided in the LMS
|
| ５． |
Requirements (Assignments) |
|
You can access the material for each class in the LMS. Check it before each class. A task will be provided in each class, which must be completed before the next class.
|
| ６． |
Note |
|
This course covers subgoal 4-4 in learning-education goals of the JABEE program.
|
| ７． |
Schedule |
|
| １. Basic Concepts of Databases |
| ２. Models of Databases |
| ３. Basis of Relational Databases (1) (Basic terms and concepts of Relation) |
| ４. Basis of Relational Databases (2) (Relational algebra) |
５. Relational Database Language SQL (1) (Basic concepts of SQL, and queries)
訂正無し |
| ６. Relational Database Language SQL (2) (Update of data, and operations of data from an application program) |
| ７. Middle Examination and Design of Databases (1) (An overview of database design, and ER models and design of schema) |
| ８. Design of Databases (2) (Standardization) |
| ９. Transaction Management (1) (Concepts of transactions, and concurrency control) |
| 10. Transaction Management (2) (fault recovery) |
| 11. Database Management Systems (1) (An overview of database management systems and storing methods of database |
| 12. Database Management Systems (2) (query processing) |
| 13. Evolution of Databases (1) (Object relational database, and distributed database |
| 14. Evolution of Databases (2) (Internet and database) |
| 15. Mastering Examination and Review of the Classes |
|
| １． |
Outline |
|
In this course, you will learn about database, a mechanism which enables to effectively store and retrieve data. Specifically, you will learn the following.
* Information models and systems
* Database systems
* Data modelling and relational databases
* SQL, a relational database language
* Design of databases and operations of data
These serve as a basis for knowledge and skills on DP4C and DP4M.
|
| ２． |
Objectives |
|
The goal of this course is to understand basic concepts about databases necessary complex information processing and fundamental mechanisms of database systems, so that you will be able to utilize 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.
In each class, you will receive instructions from the lecturer, make explanation about learning materials by yourself, and answer quizzes.
|
| ３． |
Grading Policy |
|
Your grade will be assessed based on the score of the mastering examination and evaluations of tasks. To earn the credits, you must satisfy the following three conditions.
(1) You must attend the specified number of or more classes.
(2) You must pass all tasks (quizzes in every class).
(3) You must obtain the score equal to or higher than the qualifying score (60%).
You will receive elucidations and evaluations in the LMS.
|
| ４． |
Textbook and Reference |
|
You need the following textbook.
Haruo Hayami, Nobuyoshi Miyazaki, and Haruaki YAmazaki, IT Text Databases, Ohmsha, ISBN 978-4-274-13254-4
You also use materials provided in the LMS
|
| ５． |
Requirements (Assignments) |
|
You can access the material for each class in the LMS. Check it before each class. A task will be provided in each class, which must be completed before the next class.
|
| ６． |
Note |
|
This course covers subgoal 4-4 in learning-education goals of the JABEE program.
|
| ７． |
Schedule |
|
| １. Basic Concepts of Databases |
| ２. Models of Databases |
| ３. Basis of Relational Databases (1) (Basic terms and concepts of Relation) |
| ４. Basis of Relational Databases (2) (Relational algebra) |
５. Relational Database Language SQL (1) (Basic concepts of SQL, and queries)
訂正無し |
| ６. Relational Database Language SQL (2) (Update of data, and operations of data from an application program) |
| ７. Middle Examination and Design of Databases (1) (An overview of database design, and ER models and design of schema) |
| ８. Design of Databases (2) (Standardization) |
| ９. Transaction Management (1) (Concepts of transactions, and concurrency control) |
| 10. Transaction Management (2) (fault recovery) |
| 11. Database Management Systems (1) (An overview of database management systems and storing methods of database |
| 12. Database Management Systems (2) (query processing) |
| 13. Evolution of Databases (1) (Object relational database, and distributed database |
| 14. Evolution of Databases (2) (Internet and database) |
| 15. Mastering Examination and Review of the Classes |
|
|