Data and Information Management
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
ISYS2120
Data and Information
Management
Agenda
– Focus of the Unit
– Exam Coverage
– Exam Structure
– Exam Advice
Week 13 lab
– Presentation of Assignment 3
– Checkout related discussions and posts on Edstem
What is examinable?
– Everything from the lectures, the referenced sections of
the textbooks, the labs, the weekly challenge tasks, the
quizzes, the assignments
– except when explicitly labeled as non-examinable
– If it happened during this unit, you are expected to know
about it!
– But, focus on the things we put most emphasis on, as
seen in labs and assignments
From Unit Outline, Handbook entry
– “The ubiquitous use of information technology leaves us facing a
tsunami of data produced by users, IT systems and mobile devices.
The proper management of data is hence essential for all
applications and for effective decision making within organizations.
– This unit of study will introduce the basic concepts of database
designs at the conceptual, logical and physical levels. We will place
particular emphasis on introducing integrity constraints and the
concept of data normalization which prevents data from being
corrupted or duplicated in different parts of the database. This in
turn helps in the data remaining consistent during its lifetime. Once a
database design is in place, the emphasis shifts towards querying the
data in order to extract useful information. The unit will introduce the
SQL database query languages, which is industry standard. Other
topics covered will include the important concept of transaction
management, application development with a backend database,
and an overview of data warehousing and OLAP. “
ISYS2120 Learning outcomes (start)
– 1. Ability to design a schema which says how information about
a particular domain will be stored in a relational DBMS (given
a conceptual data model); also ability to apply normalization
theory to evaluate or improve a relational schema. Ability to
capture business rules as integrity constraints in a database
schema.
– 2. Understanding of the concept of a DBMS: differences from
other ways to store and share data; DBMS role in
organizations; the types of work done with a DBMS.
– 3. Ability to work with data stored in a relational database
management system (understand table definitions including
integrity constraints, extract information through SQL queries,
modify information through SQL queries, use views and
permissions for security)
ISYS2120 Learning outcomes (rest)
– 4. Experience of how application software can use data stored
in a DBMS (eg a dynamic content web site) and understand the
basic architectural alternatives for data management
applications.
– 5. Understanding of the basic concepts of transaction
management.
– 6. Understanding of the relational data model
– 7. Ability to connect general database concepts to both
theoretical abstract formulations, and details of specific
software platforms.
– 8. Understanding of the SQL mechanisms for basic concepts of
data security and privacy
– 9. Work effectively in a team with members whose skills and
interests differ
Practice Exam
– Practice exam will be released at the end of Week 13
Exam has two sections
Question type Points Recommended time
spent
Section 1 MCQs 30 40 minutes
Section 2
Short answer and/or
extended response
70 80 minutes
Exam Structure
– Two hours writing plus 10 minutes reading at the start
– Total 130 minutes
– Open book exam
– You can consult any lecture or tutorial material
– Can use calculator
– Do all questions worth in total 100 points
– Exam is worth 50% of overall isys2120 grade
– reminder: you must get at least 40 points on exam, in order to
pass the unit