UQ Students should read the Disclaimer & Warning
Note: This page dates from 2005, and is kept for historical purposes.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- saved from url=(0094)http://www.itee.uq.edu.au/undergraduate/_profile_view.php?print=1&file=2003_2_INFS1200_StLucia -->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>INFS1200 – Course Profile</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta
content="School of Information Technology and Electrical Engineering - Course Profile"
name="Description" />
</head>
<body bgcolor="#ffffff">
<h3 align="center">The University of Queensland<br />
School of Information Technology and Electrical Engineering<br />
Semester 2, 2003</h3>
<h1 align="center" ?>INFS1200- Introduction to Information Systems<br />
INFS7900 - Equivalent Course(s)</h1>
<h1 align="center">Course Profile</h1>
<h2>Version</h2>
<p>This is version 1.1 of the INFS1200course profile, dated <b>21 July 2003</b>.</p>
<h3>Changes since the last version</h3>
<p>Not applicable.</p>
<hr />
<h2>Course Summary</h2>
<table id="AutoNumber6"
bordercolor="#111111" cellspacing="1" cellpadding="3" border="1">
<tbody>
<tr>
<td nowrap="nowrap"><b>Course Code(s):</b></td>
<td><b>INFS1200 / INFS7900</b></td>
</tr>
<tr>
<td nowrap="nowrap"><b>Unit Value:</b></td>
<td>#2</td>
</tr>
<tr>
<td nowrap="nowrap"><b>Contact Hours:</b></td>
<td>6 hours per week (3L1T2P) </td>
</tr>
<tr>
<td nowrap="nowrap"><b>Purpose:</b></td>
<td>This course introduces the student to the area of computer-based information
systems. It includes basic concepts necessary to correctly design, and implement,
a small information system. The course will prepare students to deploy
small information systems in industry and will also prepare them for further
study of advanced information system concepts taught later in the program. </td>
</tr>
</tbody>
</table>
<hr />
<h2>Teaching Staff</h2>
<p><b>Dr Shazia Sadiq (Course Coordinator)</b><br />
Office: 78-652<br />
Phone: 53481<br />
Fax: (07) 3365-4999<br />
Email: shazia[at]itee.uq.edu.au <br />
Consultation Time: </p>
<p><b>Dr. Xue Li (Ipswich)</b><br />
St Lucia Office: 78-650, Tel: 33652379; <br />
Ipswich Room: TBA, Tel: TBA <br />
Email: xueli[at]itee.uq.edu.au </p>
<h3>Tutors</h3>
<p>TBA</p>
<hr />
<h2>Course Goals</h2>
<p>On successful completion of this subject, students will be able to:</p>
<ol style="MARGIN-TOP: 0cm; MARGIN-BOTTOM: 0cm" type="1">
<li> Extract
(simplified) specifications to create basic conceptual data models </li>
<li> Map basic
conceptual data models to relational database schema </li>
<li> Reason
with the logical foundation of the relational data model </li>
<li> Understand
the fundamental principles of correct relational database design </li>
<li> Express
natural language queries using relational algebra and the SQL language </li>
<li> Construct
simple computer-based information systems given a complete specification </li>
</ol>
<h2>Graduate Attributes Developed</h2>
<p>The University of Queensland has defined a set of graduate attributes to specify
broad core knowledge and skills associated with all undergraduate programs (http://www.uq.edu.au/hupp/contents/view.asp?s1=3&s2=20&s3=5).
This course addresses these attributes as follows:</p>
<table id="AutoNumber4"
bordercolor="#111111" height="96" cellspacing="1" width="100%" border="1">
<tbody>
<tr>
<th width="20%" height="16">Attribute</th>
<th width="80%" height="16">Contributions from this Course</th>
</tr>
<tr>
<td width="20%" height="16">In-depth knowledge of the field of study</td>
<td width="80%" height="16">This course will provide foundation knowledge
of information system design and development, specifically on data modelling,
relational databases, SQL and a high level understanding of database management
systems. This knowledge is intended to lay the foundation for further advanced
study in databases. However, the course is structured in such a way that
students taking only this course in databases will gain sufficient knowledge
to undertake the design and development of a small scale database application</td>
</tr>
<tr>
<td width="20%" height="19">Effective Communication</td>
<td width="80%" height="19">The importance for effective communication is
emphasised since design diagrams are demonstrably used as instruments of
communication</td>
</tr>
<tr>
<td width="20%" height="19">Independence and Creativity</td>
<td width="80%" height="19">The course includes assignment work which requires
students to independently build data models and make design decisions. This
work is part of a small information systems development project in which
students implement a real life database application, which promotes creativity</td>
</tr>
<tr>
<td width="20%" height="19">Critical Judgement</td>
<td width="80%" height="19">Design decisions will be required in assignments
as well as exam questions. This will require the use judgement based on techniques
and methods studied and the ability to justify design approach </td>
</tr>
<tr>
<td width="20%" height="19">Ethical and Social Understanding</td>
<td width="80%" height="19">The phases of database design, from receiving
user specifications to implementing the application, demonstrate the need
for team work between domain experts/users, database designers, database
administrators, application developers and programmers. Students are expected
to recognize that the success of an information system depends not only on
technical skills, but also on the ability to effectively interact with multiple
parties and work towards a common goal</td>
</tr>
</tbody>
</table>
<hr />
<h2>Assumed Background</h2>
<p>Senior Math B or MT 140. Basic set theory is useful. No computer
programming experience is assumed.</p>
<hr />
<h2>Resources</h2>
<h3>Course Profile Copy</h3>
<p>In the first lecture (or class meeting) students will be directed to the web
address at which this course profile can be read. Students enrolled at
St Lucia who wish to retain a hard copy of the profile can use the free print
quota provided each semester to students enrolled in courses in the School of
Information Technology & Electrical Engineering. For information on
how to use this print quota, see the School Policy on Student Photocopying and
Printing (St Lucia). Students enrolled at the Ipswich campus will either be
provided with a hard copy or given directions in class on how to obtain a free
copy.</p>
<h3>Textbook</h3>
<p>The required/recommended/suggested text is</p>
<p>Elmasri & Navathe (2000) <i>Fundamentals of Database Systems,</i> 3rd
edn, Addison Wesley<br />
Grauer R.T. & Barber M. (2002) <i>Exploring Microsoft Access 2002</i>, Prentice
Hall.</p>
<h3>Handouts</h3>
<p>Lecture notes will be available from the following:</p>
<ul>
<li>
<p> Viewing/downloading from the web. These may be viewed as Html, or
downloaded as PDF </p>
</li>
<li>
<p>Printing options will be available from POD (Print on Demand, UQ http://www.pod.uq.edu.au/
) </p>
</li>
</ul>
<h3>Facilities</h3>
<p>The subject requires the use of personal computers that support Microsoft
Access database software. These computers will be made available to all INFS1200
students who will have access to ITEE labs at scheduled times. Should
students wish to do so, they may use their own computer resources for the subject.
However, students must understand that they do so at their own risk. The University
is not responsible for any hardware or software problems that arise as a result.
ITEE staff will not provide help or advice regarding their personal hardware/software
configuration. Furthermore, students must verify that all computer-based assignments
that they plan to submit will execute correctly in the ITEE laboratories. Computer-based
assignments that do not execute correctly in the ITEE labs will not be accepted. </p>
<h3>Consultation</h3>
<p>Students having problems with lab computer equipment, or their programming
assignment, should see a lab tutor at any of the practical session times.</p>
<p>Problems to do with understanding lectures, doing tutorial exercises, doing
assignments should be taken to the next tutorial session for the relevant stream.
If the problem is urgent, take it to the next tutorial on the timetable - even
if it's not the one you usually attend. If you are still having difficulty,
see a subject consultant during an arranged consultation time. The times and
locations will be announced on the web site. With the exception of special appointments,
no consultation will occur outside of these times.</p>
<p>If the above is insufficient to answer your question or resolve your problem,
you can then contact course coordinator to arrange for an appointment.</p>
<h3>Distribution of Notices</h3>
<p>All announcements for the subject will be put on the course web site. Separate
notices will be kept for St Lucia and Ipswich students. <b>Students must
check the course web site no less than once a week.</b> </p>
<h3>Web</h3>
<p>The subject website can be found at http://www.itee.uq.edu.au/~infs1200. It
contains the subject profile and current subject notices as well as the subject
resources, including lecture notes, tutorials, assignments, and solutions. <b>Students
must check this site no less than once a week.</b> </p>
<h3>Newsgroup</h3>
<p>The course newsgroup is uq.itee.infs1200. This group is available on both
the University and School news servers (news.uq.edu.au and news.itee.uq.edu.au).
Students are free to post questions (and answers!) to the newsgroup. Students
are reminded that the newsgroup is to be used only for academic purposes. The
teaching staff will monitor the newsgroup. </p>
<hr />
<h2>Teaching Activities</h2>
<h3>Lectures</h3>
<p>This subject will have 3 hours of lectures every week. Lectures will be held
in at St Lucia and Ipswich campus. Please refer to SINet Timetable for details. Lecture
notes will be available for the following:</p>
<ul>
<li>
<p>Viewing/downloading from the web. These may be viewed as Html, or downloaded
as PDF. </p>
</li>
<li>
<p>Printing options will be available from POD (Print on Demand, UQ http://www.pod.uq.edu.au/
) </p>
</li>
</ul>
<p>Please see the Lectures page on the course web site to view/download lectures
and/or find out about required readings for each lecture.</p>
<h3>Tutorials</h3>
<p>This subject will have 1 hour of tutorial every week. Please refer to SINet
Timetable for details. Tutorials consist of exercises from the text book (Elmasri & Navathe
3rd Edition). Tutorials are scheduled to meet 2 basic objectives: </p>
<ul>
<li>
<p>To provide an opportunity to extensively practice and apply the techniques
and concepts introduced in the lectures. Although the tutorial exercises are
not handed in or marked, proficiency on these techniques and concepts will
be assessed in the quizzes and final exam, and hence attendance and participation
in the tutorials is extremely important </p>
</li>
<li>
<p>To provide consultation to the students regarding theoretical component
of the subject. As far as possible, questions in a particular session should
be limited to the topic under discussion. </p>
</li>
</ul>
<p>The <b>solutions</b> to each week's tutorial exercises will be made
available online on Friday afternoon of the same week. There will be 10 tutorials
in all, with the first one starting in week 3. Please see the Tutorials page
on the course web site to find out more about the tutorial questions and solutions.</p>
<h3>Pracs</h3>
<p>This subject will have scheduled hours of supervised lab every week. Please
refer to SINet Timetable for details. The semester will be divided into 2 Lab
periods: </p>
<ul>
<li>
<p>The first period of 4 weeks (starting from week 3 through to week 6) is
to allow students to get familiar with MS Access interface and tools. A series
of lab exercises will be undertaken, which will be guided by the MS Access
text book (Grauer & Barber). The first 6 chapters of the book <b>must</b> be
covered. Guidelines to manage these exercises and ensure that the required
material is covered in the allocated time are given on the Practical page
on the course web site. However, students are free to work at their
own pace, provided the first 5 chapters are thoroughly covered. </p>
</li>
<li>
<p>The second period (week 7 to week 13) will be designated to working on the
practical assignments </p>
</li>
</ul>
<p>Please see the Practical page on the course web site for guidelines on managing
the exercises. This page also contains the practice database and web links to
additional exercises. </p>
<h3>Attendance</h3>
<p>You are not <i>required</i> to attend any of the teaching sessions (except
those in which an assessment activity is taking place), however, you are <i>strongly
encouraged</i> to do so. The lectures, tutorials and pracs have been specifically
designed to aid your learning of the course material. Failure to attend a session
may result in you being disadvantaged. It is up to you to find out what happened
at any class session that you miss.</p>
<h3>Teaching Plan</h3>
<p>This course is divided into 8 modules, which will cover the following topics:</p>
<ul style="MARGIN-TOP: 0cm; MARGIN-BOTTOM: 0cm" type="disc">
<li>
<p>Introduction to Information Systems </p>
</li>
<li>
<p>Fundamentals of the Relational Data Model </p>
</li>
<li>
<p>Conceptual Data Modeling using the Entity-Relationship Approach </p>
</li>
<li>
<p>ER to Relational Mapping </p>
</li>
<li>
<p>Functional Dependencies and Normalization </p>
</li>
<li>
<p>Relational Algebra </p>
</li>
<li>
<p>Introduction to SQL </p>
</li>
<li>
<p>Database System Architecture </p>
</li>
</ul>
<p>The above outline is intended to give a tentative plan for the subject. The
topic list may be altered or rearranged as the course progresses to better achieve
academic objectives</p>
<p>The course modules will be scheduled as follows in the teaching calendar: </p>
<table width="532" border="1"
cellpadding="0" cellspacing="0" bordercolor="#000000">
<tbody>
<tr>
<td
valign="top" width="119"> <p><b>Week</b> </p></td>
<td
valign="top" width="165"> <p><b>Lecture</b></p></td>
<td
valign="top" width="129"> <p><b>Tutorial</b></p></td>
<td
valign="top" width="120"> <p><b>Practical</b></p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>1<br />
28/7 – 1/8 </p></td>
<td
valign="top" width="165"> <p>Introduction</p>
<p><br />
Database Systems </p></td>
<td
valign="top" width="129"> </td>
<td
valign="top" width="120"> </td>
</tr>
<tr>
<td
valign="top" width="119"> <p>2<br />
4/8 - 8/8 </p></td>
<td
valign="top" width="165"> <p>Relational Model</p></td>
<td
valign="top" width="129"> </td>
<td
valign="top" width="120"> </td>
</tr>
<tr>
<td
valign="top" width="119"> <p>3<br />
11/8 - 15/8 </p></td>
<td
valign="top" width="165"> <p>Entity-relationship Model </p></td>
<td
valign="top" width="129"> <p>Relational Model </p></td>
<td
valign="top" width="120"> <p>1. MS Access </p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>4<br />
18/8 -22/8 </p></td>
<td
valign="top" width="165"> <p>ER to Relational Mapping </p></td>
<td
valign="top" width="129"> <p>ER </p></td>
<td
valign="top" width="120"> <p>2. MS Access </p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>5<br />
25/8 - 29/8 </p></td>
<td
valign="top" width="165"> <p>FDs and Normalization </p></td>
<td
valign="top" width="129"> <p>ER-Relational Mapping</p></td>
<td
valign="top" width="120"> <p>3. MS Access </p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>6<br />
1/9 - 5/9 </p></td>
<td
valign="top" width="165"> <p>(cont) Normalization Relational Algebra</p></td>
<td
valign="top" width="129"> <p>Normalization </p></td>
<td
valign="top" width="120"> <p>4. MS Access </p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>7<br />
8/9 - 12/9 </p></td>
<td
valign="top" width="165"> <p>(cont) Relational Algebra</p></td>
<td
valign="top" width="129"> <p>Relational Algebra </p></td>
<td
valign="top" width="120"> <p>Work on Assignments </p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>8<br />
15/9 - 19/9 </p></td>
<td
valign="top" width="165"> <p>Basic SQL</p></td>
<td
valign="top" width="129"> <p>Relational Algebra</p></td>
<td
valign="top" width="120"> <p>Work on Assignments</p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>9<br />
22/9 - 26/9</p></td>
<td
valign="top" width="165"> <p>Mid Semester Exam</p></td>
<td
valign="top" width="129"> <p>Basic SQL</p></td>
<td
valign="top" width="120"> <p>Introduction to SQLator</p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>29/10 - 3/10 </p></td>
<td
valign="top" width="413" colspan="3"> <p>Break </p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>10<br />
6/10 - 10/10 </p></td>
<td
valign="top" width="165"> <p>Advanced SQL </p></td>
<td
valign="top" width="129"> <p>Mid Semester Feedback </p></td>
<td
valign="top" width="120"> <p>Work on Assignments</p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>11<br />
13/10 - 17/10 </p></td>
<td
valign="top" width="165"> <p>(cont) Advanced SQL </p></td>
<td
valign="top" width="129"> <p>Advanced SQL </p></td>
<td
valign="top" width="120"> <p>Work on Assignments</p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>12<br />
20/10 - 24/10 </p></td>
<td
valign="top" width="165"> <p>Database System Architecture </p></td>
<td
valign="top" width="129"> <p>SQL-Views </p></td>
<td
valign="top" width="120"> <p>Work on Assignments</p></td>
</tr>
<tr>
<td
valign="top" width="119"> <p>13<br />
27/10 - 31/10 </p></td>
<td
valign="top" width="165"> <p>(cont) Database System Architecture<br />
Revision<br />
Hints on Final Exam </p></td>
<td
valign="top" width="129"> <p>Consultation Tutorials </p></td>
<td
valign="top" width="120"> </td>
</tr>
</tbody>
</table>
<p>Note: The week by week timetable may be changed in accordance with any changes
made to the course topics.</p>
<hr />
<h2>Assessment</h2>
<p>INFS1200will be assessed by several methods as outlined below. Your final
grade (on a 1 to 7 scale) will be determined by combining the marks from the
various assessment components as described below. For each assessment item,
reference is made to the specific learning objectives (from the list above)
which the assessment item will address. </p>
<ul>
<li>
<p>Exams are designed to test theoretical concepts and modeling techniques
introduced in lectures and tutorials. Exams will address learning outcomes
1-5. </p>
</li>
<li>
<p>Practical assignments are designed to test data analysis and design techniques,
information system development skills acquired in practical sessions, and
proficiency in SQL. Practical assignments will address learning outcomes 1-6. </p>
</li>
</ul>
<h3>Assignments</h3>
<p>This course will have two practical assignments. Practical assignments are
designed to test data analysis and design techniques as well as information
system development skills acquired in practical sessions. Assignments will be
announced and placed on the Assignment page on the course web site at the required
time. </p>
<p>Please ensure that you download/print your copy as soon as possible on or
after the date of issue. </p>
<p>Procedure for submission of assignments will be announced on the course web
site. Late submission of assessable material will incur a penalty of 20% reduction
each date late. Students who believe they have sound reasons of late submission
should see the course coordinator as soon as possible. </p>
<p>Students are advised to create back-up copies of their assignments. Software
can fail (or be lost) for many reasons and it happens quite frequently. Students
should also retain paper-based assignments in the event that the original paper
version is lost or damaged. </p>
<h3>Exams</h3>
<p>This course will have two exams: Mid Semester and Final. Exams are designed
to test theoretical concepts and modeling techniques introduced in lectures
and tutorials. Exams will address all material from lectures and tutorials
that occurred prior to the exam date. All exams will be closed book. You
will be required to answer all questions and write in the space provided on
the exam paper. Programmable calculators and other computing or communication
devices are NOT permitted. Students may request the use of dictionaries, including
bilingual dictionaries, supplied by Examinations Section. You will require a
HB or 2B pencil and an eraser to complete the exam.More information on exams
will be provided on the exam page on the course web site at the appropriate
time. </p>
<h3>Determination of Final Grade</h3>
<table width="542" border="1"
cellpadding="0" cellspacing="0" bordercolor="#000000">
<tbody>
<tr>
<td
valign="top" width="184"> <p><b>Assessment</b></p></td>
<td
valign="top" width="83"> <p><b>%</b></p></td>
<td
valign="top" width="274"> <p><b>Due date (Semester 2)</b></p></td>
</tr>
<tr>
<td
valign="top" width="184"> <p>Assignment 1 (2 Parts)</p></td>
<td
valign="top" width="83"> <p>10 %</p></td>
<td
valign="top" width="274"> <p>Week 6 (Part 1)</p></td>
</tr>
<tr>
<td
valign="top" width="184"> </td>
<td
valign="top" width="83"> <p>10%</p></td>
<td
valign="top" width="274"> <p>Week 8 (Part 2)</p></td>
</tr>
<tr>
<td
valign="top" width="184"> <p>Mid Semester Exam</p></td>
<td
valign="top" width="83"> <p>30 %</p></td>
<td
valign="top" width="274"> <p>Week 9 (in lecture)</p></td>
</tr>
<tr>
<td
valign="top" width="184"> <p>Assignment 2</p></td>
<td
valign="top" width="83"> <p>10 %</p></td>
<td
valign="top" width="274"> <p>Week 12</p></td>
</tr>
<tr>
<td
valign="top" width="184"> <p>Final Exam</p></td>
<td
valign="top" width="83"> <p>40 %</p></td>
<td
valign="top" width="274"> <p>Examination period</p></td>
</tr>
</tbody>
</table>
<p><b>Students are required to pass the final exam (i.e. to obtain at least 20
out of 40) to pass the course.</b></p>
<h2>Assessment Policies</h2>
<h3>Return of Assignments</h3>
<p>Upon completion of marking, an announcement will be made on the web site,
as to when the marked material will be returned. Assignments and exams will
be returned in the practical/tutorial session that you indicate on the cover
page of the assignment or exam. Please indicate, as far as possible the
same session as the one you signed up for. </p>
<p>Uncollected assignments and exams will then be made available for collection/viewing
from an announced place</p>
<h3>Academic Merit, Plagiarism, Collusion and Other Misconduct</h3>
<p>The School and the wider academic community in general takes academic integrity
and respect for other persons and property very seriously. In particular, the
following behaviour is unacceptable: </p>
<ul>
<li>Submission of plagiarised work, i.e. work that contains content copied from
an unacknowledged source. </li>
<li>Submission of work without academic merit, i.e. work that adds little or
nothing to material available from reference sources such as textbooks, websites,
etc., even where this is appropriately acknowledged. </li>
<li>Engaging in collusive behaviour, i.e. inappropriate working together with
other students where individual work is required, or working with people outside
your team where team work is required. </li>
<li>Copying work done by other students. </li>
<li>Failing to adhere to the School's regulations concerning behaviour in laboratories,
in particular occupational health and safety regulations. </li>
</ul>
<p>Penalties for engaging in unacceptable behaviour can range from cash fines
or loss of grades in a subject, through to expulsion from the University.<br />
<br />
You are required to read and understand the School Statement on Misconduct,
available on the ITEE website at: http://www.itee.uq.edu.au/about/student-misconduct.jsp. This
Statement includes advice on how to properly cite references and other sources
in your submissions and on acceptable levels of collaboration.<br />
<br />
If you have any questions concerning this statement, please contact your
lecturer in the first instance.</p>
<h3>Assessment Feedback</h3>
<p>Timely feedback on all progressive assessment in this course will be available
in accordance with University policy (HUPP 3.30.6 <i>Student Access to Feedback
on Assessment</i>). Feedback will be provided in the following forms:</p>
<ul>
<li>Comments on assignment and exam scripts where appropriate </li>
<li>Release of solutions and discussion on frequent errors on the course website </li>
<li>Special tutorial session on discussion of solution </li>
</ul>
<p>Students wishing to view examination answer scripts and/or question papers
should consult with the School office (Room 217, General Purpose South Building
[78], St Lucia; Room 218, Building 1, Ipswich) regarding arrangements.</p>
<p>It is a student’s responsibility to incorporate feedback into their learning;
making use of the assessment criteria that they are given; being aware of the
rules, policies and other documents related to assessment; and providing teachers
with feedback on their assessment practices.</p>
<hr />
<h2>Support for Students with a Disability</h2>
<p>Any student with a disability who may require alternative academic arrangements
in the course is encouraged to seek advice at the commencement of the semester
from a Disability Adviser at Student Support Services. </p>
<hr />
<p>Sourced From <a href="http://www.itee.uq.edu.au/undergraduate/_profile_view.php?print=1&file=2003_2_INFS1200_StLucia">http://www.itee.uq.edu.au/undergraduate/_profile_view.php?print=1&file=2003_2_INFS1200_StLucia</a></p>
</body>
</html>