Practice on Design Project 12

Course title

Y0170012

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

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.

Language

Japanese

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
1.	Basics on modeling of data and functions	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
4.	System design: designing of applications and databases	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
6.	Detailed design and implementation of the application	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.

Prerequisites

Basic knowledge of object-oriented programming

Office hours and How to contact professors for questions