|
|
|
|
|
|
CM0719 - DATABASE MODELLING=
|
|
|
|
|
|
|
|
|
|
|
Computing,
Engineering and Information Sciences
|
|
|
Software and D=
ata
Engineering
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The aim is for you to understand the conceptual basis for current
database technology and to be able to apply such knowledge in
implementing database applications.
At the end of the module students should be able to:
1. Understand data modelling through the example of the relational mo=
del;
be able to design and manipulate relational databases with relational
algebra and SQL; normalise relational data structures.
2. Appreciate limitations of data models and the need for database
programming to achieve complete solutions; write transactions and
procedures for relational databases; specify security for operations;
apply business rules; be competent with PL/SQL.
3. Have knowledge of advanced object models, their rationale, advanta=
ges
and disadvantages; construct object-relational databases with nested
capability; write user-defined types as ADTs and subtypes for
inheritance; use object features in Oracle 10g.
4. Discuss development of distributed databases, their rationale,
strengths and weaknesses; understand performance issues and
fragmentation; handle data exchange using XML; be aware of difficulti=
es
of interoperability and possible solutions with object-based features
such as user-defined types.
5. Be aware of emerging database models, such as temporal, spatial and
multimedia; be able to design and construct examples.
6. Realise the responsibilities of database designers with respect to
professional, legal and ethical issues.
Students attend supporting sessions which introduce the forthcoming
topics, review the work done and give opportunities for practice and
feedback. Distance learning students receive equivalent support throu=
gh
the ePortal and use of email contact with the module team. Assessment
takes the form of a portfolio developed over the period of the module
with the opportunity for interim feedback from the module team.<=
/o:p>
|
|
|
|
|
|
|
|
Indicative Rea=
ding
List or Other Resources
|
Core text:
Thomas Connolly & Carolyn Begg, Database Systems: A Practical
Approach to Design, Implementation and Management, 4th ed. Pearson
(2005).
Additional reading:
Rajshekhar Sunderraman, Oracle 10G Programming: A Primer, Pearson (20=
07).
Completely adequate replacement if not issued in time is the Oracle 9i
primer by the same author.
Ramez Elmasri & Shamkant Navathe, Fundamentals of Database System=
s,
Pearson International Edition, 5th ed. (2006).
Chris J. Date, An Introduction to Database Systems, 8th ed. Addison
Wesley (2003).
Ahmed Elmagarmid, Marek Rusinkiewicz, & Amit Sheth, Management of
Heterogeneous and Autonomous Database Systems, 1st ed, Morgan Kaufmann
(1999).
Chris J Date, Hugh Darwen & Nikos Lorentzos, Temporal Data and the
Relational Model, 1st ed, Morgan Kaufmann (2002).
|
|
|
|
|
|
|
|
|
|
1. Notion of data model with relational data model as example (25%)
Relational data structures, design techniques, manipulation with
relational algebra, normalisation of relational structures to 3NF
2. The standard relational language SQL (15%)
3. When database programming is needed: business rules and transactio=
ns;
security for operations (15%)
The Oracle procedural language PL/SQL
4. Advanced object models, rationale and facilities (15%)
Object and nesting facilities in Oracle 10g, creating and using new
types.
5. Distributed databases, evolution and architectures (20%)
Advantages and disadvantages of distribution
Data exchange with XML, challenge of interoperability; creating poten=
tial
solutions with object-based user-defined types across different datab=
ase
systems
6. Emerging database models (10%)
Temporal, spatial, multimedia databases; designing and creating examp=
les.
|
|
|
|
|
|
|
|
|
|
1. To provide understanding of the conceptual basis for current datab=
ase
technology.
2. To enable students to apply such knowledge in implementing database
applications.
|
|
|
|
|
|
|
|
|
|
On completion of the module, students will be able to:
1. Have a systematic understanding of the data modelling concept; use=
as
an example the relational model; be able to design and manipulate
relational databases with relational algebra and SQL; normalise
relational data structures.
2. Appreciate limitations of data models and the need for database
programming to achieve complete solutions; write transactions and
procedures for relational databases; specify security for operations;
apply business rules; be competent with PL/SQL.
3. Have a critical awareness of advanced object data models, their
rationale, advantages and disadvantages; construct object-relational
databases with nested capability; write user-defined types as ADTs and
subtypes for inheritance; use object features in Oracle 10g.
4. Have a comprehensive knowledge of the development of distributed
databases, their rationale, strengths and weaknesses; understand
performance issues and fragmentation; handle data exchange using XML;=
be
aware of difficulties of interoperability and possible solutions with
object-based features such as user-defined types.
5. Have a conceptual understanding of emerging database models, such =
as
temporal, spatial and multimedia; be able to design and construct
examples.
6. Realise the responsibilities of database designers with respect to
professional, legal and ethical issues.
|
|
|
|
|
|
|
|
Distance Learn=
ing
Delivery
|
Access to ePortal, module handbook, module textbooks
|
|
|
|
|
|
|
|
Learning And
Teaching Strategy
|
Teaching and learning for full-time students takes the form of a seri=
es
of lectures supported by seminars in laboratories. Distance learning
students will receive a workbook and textbooks to provide similar
instruction.
The lectures will describe and discuss the basic principles for datab=
ase
technology as currently perceived. The seminars in the laboratories w=
ill
draw both upon the students’ self studies and directed learning=
as
well as additional reading of software documentation.
Formative assessment will re-enforce students’ conceptual
understanding and practical database skills through writing code for
relational database structures and manipulation in SQL; for database
procedures in PL/SQL; for object-type definitions and manipulation in=
SQL
as presented in Oracle 10g for the SQL 2003 standard; for distributed
databases in Oracle 10g and SQL Server.
Solutions to the problems set will be given to the students allowing =
them
to check their understanding and problem solving ability.
|
|
|
|
|
|
|
|
|
|
a Formative assessment and rationale for tasks
Each student will prepare a portfolio of activities that including bo=
th
written and practical work. Either sample solutions to exercises will=
be
placed on the ePortal or students will be asked to submit their answe=
rs
to the module team for formative feedback.
b. Feedback strategy
Each student will be encouraged to submit draft versions of their ass=
ignment
portfolio. A member of the team will then give interim feedback.=
|
|
|
|
|
|
|
|
Implications f=
or
Choice
|
Exclusion: CG0065 – Databases
|
|
|
|
|
|
|
|
Notional Stude=
nt
Workload
|
Mode of delivery (eg FT, PT, DL)
Please complete a separate column where the distribution of notional
student workload differs for a particular delivery pattern DL
Lectures*
Seminars*
Tutorials*
Laboratory work*
Directed learning* 60
Independent learning* 80
Placement/work experience learning*
Summative assessment hours 60
Other
Total workload 200
|
|
|
|
|
|
|
|
![3D"cid:656e4d5d-67dd-4cc0-bc18-8ba09643f166"](3D"CM0719ModuleDescriptor_files/image002.jpg")