Course title
Practice on Design Project 12

NODA Natsuko Click to show questionnaire result at 2019
Course description
This course covers modeling of data and software, and the basics of relational databases. The students are divided in small teams, and each team designs and develops a relational database and a system using the database.
Purpose of class
The aim of this course is to help students understand methods about modeling of data and functions of systems. It also enhances the development of students’ skill in modeling, designing, and developing systems dealing with various data.
Goals and objectives
  1. To be able to model various data and systems dealing with them.
  2. To be able to develop a database and a system using it, based on models.
  3. To understand processes and procedures of system development by a team, and to be able to collaborate with team members.
Class schedule

Class schedule HW assignments (Including preparation and review of the class.) Amount of Time Required
1. Basics on modeling of data and functions Exercises on modeling 180minutes
Making an activity report 60minutes
2. Requirements definition of the target system Making a goal model 90minutes
Making usecases 90minutes
Making an activity report 60minutes
3. Database design: data modeling with conceptual models and logical models Refinement of the entity-relationship diagram 120minutes
Refinement of the database schema 60minutes
Making an activity report 60minutes
4. System design: designing of applications and databases Modification and refinement of the models 180minutes
Making an activity report 60minutes
5. Making a database and development of components using the database Collecting and inputting data 120minutes
Review of SQL 60minutes
Making an activity report 60minutes
6. Detailed design and implementation of the application Implementing the application 180minutes
Making an activity report 60minutes
7. Demonstration of the developed system and evaluation Developing an final report 240minutes
Total. - - 1680minutes
Relationship between 'Goals and Objectives' and 'Course Outcomes'

Weekly reports and meeting minutes Exercises Presentation Final artifacts Final reports Total.
1. 7% 13% 0% 5% 10% 35%
2. 7% 12% 0% 5% 10% 34%
3. 4% 0% 7% 15% 5% 31%
4. 0%
5. 0%
Total. 18% 25% 7% 25% 25% -
Evaluation method and criteria
Your final grade will be calculated according to the following process:
Weekly reports and meeting minutes(18%), exercises(25%), presentation in classes(7%), final artifacts(25%), and final reports(25%).
You get a mark of 60, if you submit all weekly reports, all models designated in the classes and a executable application.
Textbooks and reference materials
Materials prepared by the instructor will be offered.
Basic knowledge of object-oriented programming
Office hours and How to contact professors for questions
  • Lunch break on Thursday (1Q, 2Q), or on Wednesday (3Q, 4Q).
  • Or, make an appointment. Or, send e-mail to the lecturer.
Non-regionally-oriented course
Development of social and professional independence
  • Course that cultivates an ability for utilizing knowledge
  • Course that cultivates a basic interpersonal skills
  • Course that cultivates a basic self-management skills
  • Course that cultivates a basic problem-solving skills
Active-learning course
Most classes are interactive
Course by professor with work experience
Work experience Work experience and relevance to the course content if applicable
Applicable The lecturer engaged consultations on system development, as a researcher of a private company. Based on that experience, the lecturer will teach how to proceed ICT system development projects.
Education related SDGs:the Sustainable Development Goals
Last modified : Sat Mar 19 00:12:57 JST 2022