06.522: Data - Course prescription

COURSE NAME: DATA
COURSE CODE: 06.522
LEVEL: 5
NUMBER OF CREDITS: 12
AIMS OF COURSE: To provide students with an understanding of the way computers represent data and to give students an introduction to database systems.
PRE-REQUISITES: None.
CO-REQUISITES: 06.528 Operating Systems
STUDENT CAPABILITIES: Problem solving, conceptual thinking, application of knowledge.
COURSE DELIVERY:

Lecture Hours Weekly

Tutorial
/Practical
Hours Weekly

Self-directed Learning Hours Weekly

Total Learning Hours Weekly

Total Number of Weeks

Total Learning Hours

1

2

5

8

15

120

LEARNING OUTCOMES:

Time Expanded Outcomes Learning Strategies Summative Assessment
3 weeks Element 1:

Explain the digital representation and manipulation of data including standard coding schemes.

  • Explain how a computer can use a number of schemes to represent and manipulate numbers and characters (Range: binary, octal, decimal, hexadecimal, boolean).
  • Describe the characteristics of standard coding systems with reference to ASCII.
  • Explain the way in which codes are structured in business situations to provide unique identification and meaning.
  • Describe the characteristics of standard bar coding systems and how they can improve data capture.
 Lectures

Tutorials

 Test
4 weeks Element 2:

Describe different types of data, system data objects, and operations on data.

  • Describe a selection of data types and give examples of data (Range: character, blob, integer, numeric, string, object).
  • Describe a selection of data structures and their relationship, if any, to each other (Range: fields, records, files, indexes, sets, hyperlinks).
  • Describe a selection of file structures.
  • Discuss how data is manipulated with a selection of operations (Range: insertion, deletion, updating, error handling using checksums, compression, encryption, masking, collating, multi-key sorting, encapsulating, triggering).
 Lectures

Laboratory work

 Test
3 weeks

Element 3:

Explain the meaning of the terms used in a database management environment.

(Range: shared use, security, privacy, integrity, performance, data administration, recovery, audit, distributed data management, backups, risk analysis, change control, transaction processing)

 Lectures

Laboratory work

 Test
4 weeks

Element 4:

Implement simple database designs to solve given business problems.

  • Explain the purpose of a data model.
  • Normalise a given set of data.
  • Interpret simple ER diagrams.
  • Implement a given database design.
  • Use simple SQL queries to illustrate a data query language.
 Lectures

Laboratory work

 Assignment

LEARNING RESOURCES:

Recommended Text:

ASSESSMENTS:

Unitec/EIT Bachelor of Computing Systems   [Rev: 25/11/99] © 1999