Course title
L03058003
Database Systems

 kimura masaomi Click to show questionnaire result at 2019
Course description
In this class, students will learn the database system, which plays an important role in the information society. We focus on the topics of a relational database, such as its fundamental concepts, data modeling, design theories, queries, data recovery, operation management and applications.
Purpose of class
To understand the fundamental knowledge of databases
Goals and objectives
  1. Students can make suitable ER models
  2. Students can normalize tables
  3. Students understand SQL and can make SQL queries
  4. Students can explain the important concepts, such as file organization, query optimization and transactions.
Language
Japanese
Class schedule

 Class schedule HW assignments (Including preparation and review of the class.) Amount of Time Required
1. What is a database? Read Chap.1 of textbook 190minutes
2. Relational data model
・ER model 		Read Chap.2 of textbook 190minutes
3. Data manipulation language and relational algebra Read Chap.3 of textbook 190minutes
4. Data modeling practice and relational design theory (1)
・First normal form
・Multivalued dependency, functional dependency
・Modification anomaries 		Read Chap.4 of textbook 190minutes
5. Relational design theory (2)
・Second normal form
・Third normal form
・Non-loss decomposition
・Fourth normal form 		Read Chap.5 of textbook 190minutes
6. SQL Read Chap.5 of textbook 190minutes
7. SQL practice (1)- SELECT
SQL practice (2)- INSERT, UPDATE, DELETE 		Read Chap.5 of textbook 190minutes
8. DBMS architecture and function Read Chap.6 of textbook 190minutes
9. File access and organization
・ISAM
・B+ Tree
・HASH 		Read Chap.7 of textbook 190minutes
10. Practice on file access
・data addition/deletion in B+ Tree 		Read Chap.8 of textbook 190minutes
11. Query optimization
・Cost evaluation
・Nested loop
・Marginal sort 		Read Chap.9 of textbook 190minutes
12. Transactions and recovery
・transactions
・ACID
・log
・recovery 		Read Chap.9 of textbook 190minutes
13. Concurrency control of transactions/database operation practice
・Serializability of schedules
・Lock/dead lock 		Read Chap.10 of textbook 190minutes
14. Exam and commentary Review the textbook and distributed materials 190minutes
Total. - - 2660minutes
Relationship between 'Goals and Objectives' and 'Course Outcomes'

 Final exam Short test Total.
1. 20% 5% 25%
2. 20% 5% 25%
3. 20% 5% 25%
4. 20% 5% 25%
Total. 80% 20% -
Evaluation method and criteria
Short test and final exam
・For final exam, students cannot bring textbooks and notebooks
Textbooks and reference materials
Yoshifumi Masunaga, "Introduction of relational database" Science sha, 2006, (Japanese)
Prerequisites
Descrete mathematics, Data Structure and Algorithms 1 and 2, Fundamental Exercise on Computer and Information Engineering 1A and 2A, Advanced Programming, Exercise on Advanced Programming
Office hours and How to contact professors for questions
  • 13:00-14:30 on Friday in Laboratory Room 13-O-32
Regionally-oriented
Non-regionally-oriented course
Development of social and professional independence
  • Course that cultivates an ability for utilizing knowledge
Active-learning course
More than one class is interactive
Course by professor with work experience
Work experience Work experience and relevance to the course content if applicable
Applicable The professor with experience in an SI company lectures knowledge and ideas necessary to understand and design database systems used in a large information system.
Education related SDGs:the Sustainable Development Goals
  • 9.INDUSTRY, INNOVATION AND INFRASTRUCTURE
  • 12.RESPONSIBLE CONSUMPTION & PRODUCTION
Last modified : Sun Mar 21 16:27:02 JST 2021