| Teachers | KOJIMA, Kazuaki | |
|---|---|---|
| Grade, Semester | Year 2 1st semest [Department of Information and Electronic Engineering, Faculty of Science and Engineering] | |
| Category | Special Subjects | |
| Elective, Credits | Elective 2credit | |
| Syllabus Number | 3B222 | |
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. Each class is comprised of a lecture by the lecturer, an activity to work on a task or practice to operate a databese by yourself.
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 databases and relational models.
* You can perform queries for data retrieval from a database system by using SQL, a relational database language.
* You can explain design of a database such as normalization and its background, and concepts of an entity-relationship model.
* You can explain concepts of transactions and some methods to recover faults.
In each class, you will receive instructions from the lecturer, make explanation about learning materials by yourself, and answer quizzes.
Your grade will be assessed based on the score of the mastering examination and evaluations of tasks (quizzes and option tasks in classes). 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.
| Kind | Title | Author | Publisher |
|---|---|---|---|
| Textbook | IT Text Basics of Databases, ISBN 978-4-274-22373-0 | Masatoshi Yoshikawa | Ohmsha |
| References |
You will receive instructions for preparation for each class on the LMS. Check learning goals and create brief explanations to key questions of each class while following the instructions. A task will be provided in each class, which must be completed before the next class.
This course covers subgoal 4-4 in learning-education goals of the JABEE program. The mastering examination may be changed to a mastering report.
| 1 | Concepts of Databases |
| 2 | Relational Databases (1) (Relation and its basic terms, and concepts) |
| 3 | Relational Databases (2) (Relational schemata, and relational databases) |
| 4 | Relational Algebra (1) (Operations in relational algebra) |
| 5 | Relational Algebra (2) (Relational algebra expressions) |
| 6 | SQL(1) (SQL and queries) |
| 7 | SQL(2) (Updating operations, subqueries, and aggregate functions) |
| 8 | SQL(3) (Practice to operate a database system) |
| 9 | Design of Conceptual Schemata (1) (Data dependency, and information lossless decomposition) |
| 10 | Design of Conceptual Schemata (2) (Standardization) |
| 11 | Design of Conceptual Schemata (3) (RE models) |
| 12 | Data Storing and Query Processing |
| 13 | Transaction (1) (Transaction, and concurrency control) |
| 14 | Transaction (2) (Fault recovery) |
| 15 | Mastering Examination and Review of the Classes |
