<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta content="MSHTML 6.00.6002.18332" name="GENERATOR">
<style>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@page WordSection1 {size: 612.0pt 792.0pt; margin: 70.85pt 2.0cm 70.85pt 2.0cm; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-compose
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body text="#000000" vlink="purple" bgcolor="#ffffff" lang="FI"
link="blue">
<font color="#0000ff" face="Arial" size="2"><span
style="font-family: Arial;"><font size="+0"><font size="3"><span
class="430370508-19012011"><span lang="EN-US"><font
color="#000000"><strong>Dear student,<o:p></o:p></strong></font></span></span></font></font></span></font>
<div>
<p class="MsoNormal"><span lang="EN-US"><o:p><font color="#0000ff"
face="Arial" size="2"><font size="+0"><font size="3"><font
color="#000000"><strong> </strong></font></font></font></font></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><font color="#0000ff"
face="Arial" size="2"><font size="+0"><font size="3"><font
color="#000000"><font size="3"><strong>please take
advantage of the TUCS-course “Database Management
Systems<span class="430370508-19012011">: >From
Databases to Business Intelligence</span>”</strong><span><font
face="Arial"><font color="#0000ff"> <font
color="#000000" face="Calibri"><strong> </strong><span
class="371581108-19012011"><font
color="#0000ff" face="Arial"> <strong><font
color="#000000" face="Calibri">by
professor Shushil Sharma</font></strong> </font></span></font></font></font></span><strong>described <span
class="430370508-19012011">below.</span></strong></font></font></font></font></font></span></p>
<font color="#0000ff" face="Arial" size="2">
</font>
<p style="margin-bottom: 0pt; text-align: justify;"><font
color="#0000ff" face="Arial" size="2"><b style=""><span
style="font-family: Arial;"><font color="#000000"><font
size="3"><span class="430370508-19012011">"</span>From
Databases to Business Intelligence<o:p></o:p></font></font></span></b></font></p>
<p style="margin-bottom: 0pt; text-align: justify;"><span
style="font-family: Arial;"><font color="#0000ff" face="Arial"
size="2"><font size="3"><font color="#000000">Database and
database management systems (DBMS) have become an
essential component of everyday life in modern society.
The knowledge of DBMS is mandatory for every information
systems graduate because practically every software or a
system application today is developed in DBMS
environment. Course presents a comprehensive overview of
Database Management systems. This course shall cover
fundamentals of data base management technology and
practice of database and data management systems design,
implementation, and application. This course is purely
applied course. Students will understand how to be a
consultant to prepare a proposal for database
application development. Students would get an
opportunity to design the database for their own
proposal. Once the database design is ready, discussion
would be on how to handle database administration and
database tuning and performance issues. In next stage,
students would be given inputs for understanding how to
migrate to ERP, data warehouse and finally business
intelligence. A Group project (comprising 3 or 4
students) will be run throughout the semester for an
application design and development. This course will
supplement the knowledge and skills of database
knowledge that students may have from earlier database
courses at <st1:place w:st="on"><st1:placetype
w:st="on">University</st1:placetype> of <st1:placename
w:st="on">Turku</st1:placename></st1:place>.<o:p></o:p></font></font></font></span></p>
<p style="margin-bottom: 0pt; text-align: justify;"><span
style="font-family: Arial;"><font color="#0000ff" face="Arial"
size="2"><font size="3"><font color="#000000">The course
will address the following questions:<o:p></o:p></font></font></font></span></p>
<p style="margin-bottom: 0pt; text-align: justify;"><span
style="font-family: Arial;"><o:p><font color="#0000ff"
face="Arial" size="2"><font color="#000000" size="3"> </font></font></o:p></span></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent:
-18pt; line-height: normal;"><font color="#0000ff" face="Arial"
size="2"><font color="#000000"><span style="font-size: 12pt;
font-family: Arial;"><span style="">a.<span style="font:
7pt 'Times New Roman';"> </span></span></span><span
dir="ltr"><span style="font-size: 12pt; font-family:
Arial;">What are the different approaches to system
development?<o:p></o:p></span></span></font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent:
-18pt; line-height: normal;"><font color="#0000ff" face="Arial"
size="2"><font color="#000000"><span style="font-size: 12pt;
font-family: Arial;"><span style="">b.<span style="font:
7pt 'Times New Roman';"> </span></span></span><span
dir="ltr"><span style="font-size: 12pt; font-family:
Arial;">What is a Database and what are the Data Base
Management Systems? Why the uses of DBMS are preferred
over File Management Systems in any system design?<o:p></o:p></span></span></font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent:
-18pt; line-height: normal;"><font color="#0000ff" face="Arial"
size="2"><font color="#000000"><span style="font-size: 12pt;
font-family: Arial;"><span style="">c.<span style="font:
7pt 'Times New Roman';"> </span></span></span><span
dir="ltr"><span style="font-size: 12pt; font-family:
Arial;"><span style=""> </span>How to design and develop
systems using DBMS approach? <o:p></o:p></span></span></font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent:
-18pt; line-height: normal;"><font color="#0000ff" face="Arial"
size="2"><font color="#000000"><span style="font-size: 12pt;
font-family: Arial;"><span style="">d.<span style="font:
7pt 'Times New Roman';"> </span></span></span><span
dir="ltr"><span style="font-size: 12pt; font-family:
Arial;">How to Normalize and develop a Conceptual Data
Model for a given application?<o:p></o:p></span></span></font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent:
-18pt; line-height: normal;"><font color="#0000ff" face="Arial"
size="2"><font color="#000000"><span style="font-size: 12pt;
font-family: Arial;"><span style="">e.<span style="font:
7pt 'Times New Roman';"> </span></span></span><span
dir="ltr"><span style="font-size: 12pt; font-family:
Arial;">What problems may arise in different phases at
designing and implementation of Database application? <o:p></o:p></span></span></font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent:
-18pt; line-height: normal;"><font color="#0000ff" face="Arial"
size="2"><font color="#000000"><span style="font-size: 12pt;
font-family: Arial;"><span style="">f.<span style="font:
7pt 'Times New Roman';"> </span></span></span><span
dir="ltr"><span style="font-size: 12pt; font-family:
Arial;">How to address performance tuning and database
administration concerns<o:p></o:p></span></span></font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent:
-18pt; line-height: normal;"><font color="#0000ff" face="Arial"
size="2"><font color="#000000"><span style="font-size: 12pt;
font-family: Arial;"><span style="">g.<span style="font:
7pt 'Times New Roman';"> </span></span></span><span
dir="ltr"><span style="font-size: 12pt; font-family:
Arial;">How to migrate to ERP<o:p></o:p></span></span></font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent:
-18pt; line-height: normal;"><font color="#0000ff" face="Arial"
size="2"><font color="#000000"><span style="font-size: 12pt;
font-family: Arial;"><span style="">h.<span style="font:
7pt 'Times New Roman';"> </span></span></span><span
dir="ltr"><span style="font-size: 12pt; font-family:
Arial;">What are distributed databases and data
warehousing? <o:p></o:p></span></span></font></font></p>
<p class="MsoNormal" style="margin: 0cm 0cm 0pt; text-indent:
-18pt; line-height: normal;"><font color="#0000ff" face="Arial"
size="2"><font color="#000000"><span style="font-size: 12pt;
font-family: Arial;"><span style="">i.<span style="font:
7pt 'Times New Roman';"> </span></span></span><span
dir="ltr"><span style="font-size: 12pt; font-family:
Arial;">What is business intelligence<span
class="430370508-19012011">"</span></span></span></font></font></p>
</div>
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The course can be taken in
the following packages<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">lecture 2
ECTS (basic and obligatory part)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">literature 2 ECTS<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">seminar 2 ECTS<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Together also maximum 6
ECTS<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The course <span
class="430370508-19012011"><font color="#0000ff"
face="Arial" size="2"> </font></span>offers added value to
the current courses on database and their management systems
at University of Turku.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The course times and
venues at TSE main building are as follows:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> Wed 26.1.
14-18 lecture hall 09<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> Thu
27.1. 14-18 OP-Pohjola-sali <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> Wed 2.2.
14-18 lecture hall 09<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> Thu 3.2.
14-18 Osuuskauppa-sali <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> Wed 9.2.
14-18 Elovena-sali <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> Thu 10.2.
14-18 Osuuskauppa-sali<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">TSE students please
register normally to the course through the Oodi system,
others please send you registration directly to me by e-mail
by 24.1.2011.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">All registrations from the
course necessitate TSE matriculation number, that can be
obtained through the Joopas-system (<a class="moz-txt-link-abbreviated" href="http://www.joopas.fi">www.joopas.fi</a>)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Welcome to this course!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Reima Suomi<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:
'Arial','sans-serif';" lang="EN-US">_______________________</span><span
lang="EN-US"> <br>
</span><span style="font-size: 10pt; font-family: 'Courier
New';" lang="EN-US">Reima Suomi </span><span lang="EN-US"><br>
</span><span style="font-size: 10pt; font-family: 'Courier
New';" lang="EN-US">Professor of Information Systems Science<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family:
'Courier New';" lang="EN-US">Turku School of Economics,
University of Turku </span><span lang="EN-US"><br>
</span><span style="font-size: 10pt; font-family: 'Courier
New';" lang="EN-US">Rehtorinpellonkatu 3 </span><span
lang="EN-US"><br>
</span><span style="font-size: 10pt; font-family: 'Courier
New';" lang="EN-US">FIN-20500 TURKU Finland </span><span
lang="EN-US"><br>
</span><span style="font-size: 10pt; font-family: 'Courier
New';" lang="EN-US">Telephone +358 2 333 9409 </span><span
lang="EN-US"><br>
</span><span style="font-size: 10pt; font-family: 'Courier
New';" lang="EN-US">Fax +358 2 333 8900</span><span
lang="EN-US"><br>
</span><span style="font-size: 10pt; font-family: 'Courier
New';" lang="EN-US">Mobile +358 50 410 2282 </span><span
lang="EN-US"><br>
</span><span style="font-size: 10pt; font-family: 'Courier
New';" lang="EN-US"><a class="moz-txt-link-abbreviated" href="mailto:reima.suomi@utu.fi">reima.suomi@utu.fi</a> </span><span
lang="EN-US"><br>
</span><span style="font-family: 'Arial','sans-serif';"
lang="EN-US"> </span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p><br>
</o:p></span></p>
</div>
</body>
</html>