Y0170012
3 Practice on Design Project 12
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.
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.
- To be able to model various data and systems dealing with them.
- To be able to develop a database and a system using it, based on models.
- To understand processes and procedures of system development by a team, and to be able to collaborate with team members.
|
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
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