| １． |
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.
|
| ３． |
Grading Policy |
|
Your grade will be assessed based on the scores of the middle and mastering examinations and evaluations of tasks. You do not earn the credits unless the following two conditions are satisfied.
(1) You must pass all tasks (quizzes in every class).
(2) You must obtain the score higher than the qualifying score (60%) in the mastering examination.
You must pass all the quizzes in order to take the mastering examination. 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 |
|
|
| ７． |
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) |
| ７. 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. 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.
|
| ３． |
Grading Policy |
|
Your grade will be assessed based on the scores of the middle and mastering examinations and evaluations of tasks. You do not earn the credits unless the following two conditions are satisfied.
(1) You must pass all tasks (quizzes in every class).
(2) You must obtain the score higher than the qualifying score (60%) in the mastering examination.
You must pass all the quizzes in order to take the mastering examination. 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 |
|
|
| ７． |
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) |
| ７. 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. Review of the Classes |
|
|