Course title
Practice on Design Project 12

noda natsuko
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'

Artifacts Presentation Reports Total.
1. 15% 5% 15% 35%
2. 25% 10% 35%
3. 5% 15% 10% 30%
Total. 45% 20% 35% -
Evaluation method and criteria
Your final grade will be calculated according to the following process:
Final artifacts(45%), presenation in classes(20%), and reports(35%).
You get a mark of 60, if you submit all models designated in the classes and a runnable 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
  • Or, make an appointment. Or, send e-mail to the lecturer.
Relation to the environment
Non-environment-related course
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 applicatable
Applicatable The instructor engaged consultations on system development, as a researcher of a private company.
Last modified : Thu Mar 21 16:51:22 JST 2019