Semester two

Course Description 

This introductory application-oriented course covers the relational database systems RDBS - the predominant system for business, scientific and engineering applications at present. The topics are reinforced using tools such as Oracle or MS SQL Server in labs. The course includes Relational model, Relational algebra, and data access queries as well as an introduction to SQL. It also covers the basic theories behind databases, data models and database analysis and design. The course will tackle different data models but will concentrate mainly on relational databases, being the most commonly used today.

 

Course Objectives 

1. To explain to students the fundamental concepts of database systems,  functions of DBMS(Database Management System), database systems design and methodology, the current and emerging database system technologies, ability to compare and use different
2. To provide students with knowledge and understanding of DBMSs and database connectivity middleware, ability to design and implement (web-based) database systems
3. To enable students to learn how to use RMAN to create and manage backup sets and image copies
4. To train students on the use Oracle's Flashback technology to recover database,
5. To train students on the use of the various Database advisors and views to monitor and improve database Performance, Control database resource usage with the Resource Manager,
6. To provide students with knowledge and skills required to customize language-dependent behaviour for the database and individual sessions.

 

Course Learning Outcomes

By the end of the course the student will be able to:

1.    Understand the fundamental concepts of database systems,  functions of DBMS (Database Management System), database systems design and methodology, the current and emerging database system technologies, ability to compare and use different

2.    Understand DBMSs and database connectivity middleware, ability to design and implement (web-based) database systems

3.    Learn how to use RMAN to create and manage backup sets and image copies

4.    Use Oracle's Flashback technology to recover database,

5.    Use the various Database advisors and views to monitor and improve database Performance, Control database resource usage with the Resource Manager,

6.    Customize language-dependent behaviour for the database and individual sessions.

 

Indicative Content

1.    Introduction to Database programming (8 Hours)

i)     database system,

ii)    database management system (DBMS),

iii)   advantages & dis- advantages of DBMS.

2.    An Architecture of the Database system (8 Hours)

i)     Three levels of architecture,

ii)    mappings,

iii)   role of database administrator (DBA),

iv)   E-R model,

v)    three approaches of DBMS- relational,

vi)   hierarchical and network.

3.    Relational Database Terms and Concepts (8 Hours)

i)     conceptual foundation of the relational model,

ii)    difference between relations and non-relational tables,

iii)   basic relational terminology to include, but not limited to, relation/table, tuple/row, attribute/column, cardinality/multiplicity, the meaning and importance of keys, foreign keys, and related terminology,

iv)   Explain how foreign keys and intersection relations represent relationships

v)    Explain the purpose and use of surrogate keys,

vi)   the meaning of referential integrity.

4.    Normalization (8 Hours)

i)     Define normalization,

ii)    the impetus behind use of Normalization in database design,

iii)   the nature and background of normalization theory,

iv)   apply the normalization process to produce a relation in 3NF,

v)    the meaning of functional dependencies.

5.    Relational Algebra and Relational Calculus (8 Hours)

i)     Relational operators,

ii)    tuple calculus,

iii)   well-formed formulae.

6.    The SQL Language (8 Hours)

i)     Introduction,

ii)    Characteristics of SQL,

iii)   data definition,

iv)   data manipulation,

v)    SQL commands, SQL operators,

vi)   Queries, aggregate functions.

7.    Backup and Recovery (4 Hours)

i)     Transaction recovery,

ii)    System Recovery Techniques,

iii)   SQL support.

iv)   Security - General considerations, controls, audit trail, data encryption, SQL support.

v)    Integrity - General considerations, integrity rules, SQL support.

8.    Design and Development of Database Applications (4 Hours)

Database applications using some standard RDBMS.

9.    Overview of SQL and Advanced SQL: (8 Hours)

i)     Controlling user Access,

ii)    using SET operators,

iii)   Data Time Functions,

iv)   Enhancements to Group by clause (cube, Rollup and Grouping),

v)    Advanced Sub queries (Multiple column sub queries,

vi)   Sub queries in FROM clause, Scalar and correlated sub queries),

vii) The use of the WITH Clause and Hierarchical retrieval.

 

Study Materials

Relevant text books, power point slides, a projector, lap top and teaching aids necessary.

 

Mode of Delivery

Lectures, Tutorials, Lab sessions, Seminars.

 

Mode of Assessment:   

Test                                                     15%

Assignment                                       15%

End of semester examination         70%

Total                                                  100%

 

Reading List:

1.    Elmasri, M & Navathe, (2011). Fundamentals of Database Systems, 6th Edition., Addison-Wesley, ISBN: 978-013-608620-8

2.    Silberschatz, A., Korth, H. & Sudarshan, S, (1997). Database System Concepts. (Vol 4)

3.    Reese, G. (2000). Database Programming with JDBC and Java. “O’Reilly Media, Inc.”

4. Usama Fayyad, Gregory Piatetsky-Shapiro, and Padhraic Smyth. From Data Mining to Knowledge Discovery in Databases, AI Magazine 17(3): Fall 1996, 37-54.   

Course Description 

The course provides an overview of the various platforms, applications, media and technology used to develop digital media products and communications. Participants are introduced to Digital graphics photography, Video, Audio, Networked Multimedia and authorizing. Students are taught Visual Design Skills as a basic for working in Graphic Design and other major areas of Multimedia Production, learning a variety of design techniques using specialists’ software to design and manipulate images. Learn the Art of Multimedia! Authoring tools are combined to provide an effective multimedia system. This course will investigate the sue of several software tools for multimedia production and the ways in which media components can be represented and integrated into final multimedia introduction

 

Course Objectives 

The aim of this course is to provide students:

1.    Knowledge and understanding of core concepts, technologies and formats of multimedia;

2.    Skills of multimedia capture, authoring, production and compression; and

3.    Skills of deploying and serving media contents within web applications

4.    Knowledge that supports the television and cinema industries and how they can be efficiently applied.

 

Course Learning Outcomes

By the end of this course, the student will be able to:

1.    Demonstrate knowledge and understanding of core concepts, technologies and formats of multimedia;

2.    Use the skills acquired for multimedia capture, authoring, production and compression; and

3.    Use the skills acquired for deploying and serving media contents within web applications

4.    Apply the knowledge acquired to support the television and cinema industries and how they can be efficiently applied.

 

Indicative Content

1.    Introduction to multimedia systems: (6 Hours)

i)     Definition of terms and concepts;

ii)    Definition of terms and concepts related to multimedia;

iii)   Trends in the development and the use of multimedia.

2.    Multimedia capture, authoring and production. (6 Hours)

3.    Multimedia management: (6 Hours)

Tools, techniques, and guidelines facilitating the planning, design, production, and implementation of multimedia products. e.g. compression, filtering, tracking.

4.    Graphics: (6 Hours)

i)     Characteristics and interoperability;

ii)    Color, shape;

iii)   Practical sessions using application such as Photoshop,

iv)   Fireworks to create graphics web content.   

5.    Usability and User-Centered Design; (6 Hours)

i)     Design Principles,

ii)    Paper Prototyping,

iii)   Constraints and Layouts;

iv)   Graphic Design and Computer Prototyping;

v)    Heuristic Evaluation;

vi)   User Testing;

vii) Experiment Design;

viii)        Experiment Analysis

6.    Sound, Video and Animation: (6 Hours)

Characteristics and interoperability.                    

7.    Enhancing Web accessibility through using multimodal user interface. (6 Hours)          

8.    Multimedia systems-requirements social networking, (6 Hours)

i)     Operating systems issues in multimedia-real-time OS issues,

ii)    synchronization,

iii)   interrupt handling,

iv)  database issues in multimedia –indexing and storing multimedia data,

9.    Disk multimedia – quality –of-service guarantees, (6 Hours)

i)     resource reservation,

ii)    traffic specification,

iii)   shaping, and monitoring, admission control.

iv)   Multicasting issues, Session directories,

v)    Protocols for controlling sessions.

10. Security issues in multimedia-digital watermarking, (6 Hours)

i)     partial encryption schemes for video streams,

ii)    multimedia applications-audio and video conferencing,

iii)   video on demand,

iv)  voice over IP etc.

 

Study Materials

Relevant text books, power point slides, a projector, lap top and teaching aids necessary.

 

Mode of Delivery

Lectures will be used to introduce material on the formal aspects of the module whilst the bulk of the tutorial time will be spent in laboratory sessions planned around the acquisition of usable skills in a range of multimedia techniques.

 

Mode of Assessment:

Test                                                     15%

Assignment                                       15%

End of semester examination         70%

Total                                                  100%

 

Reading List

1.    Lopuck, L. (1996). Designing Multemedia: A Visual Guide to Multimedia and Online Graphic Design. Peachpit Press.

2.    Gordon, B., & Gordon, M. (2002). The Cmplete Guide to Digital Graphic Design. Watson-Guptill Publications, Inc.

3.    Austin, T, & Doust, R. (2007). New Media in Graphics Design. Harry N. Abrams, Inc.

4.    Gerassimos, B (2005). Distributed Multimedia Retrieval Strategies for Large Scale Networked Systems: Multimedia Systems and Applications. Springer-Verlag.

Course Description 

This course provides an introduction to the problems of software development and maintenance and the processes and methods used to address them. Although all phases in the software development life cycle will be introduced, the main focus will be on object-oriented analysis and design. Throughout the course, UML 2.0 will be intensively used as a modeling language for the different views of a software system. This course unit covers the techniques for development of software systems, commonly referred to as software Engineering.  It is intended to give the students both knowledge and practical experience in the design and development of quality software production

 

Course Objectives

1.    To introduce to students the concepts and tools for designing software projects.

2.    To provide students with knowledge of the principles for the design of software engineering projects using sound, scientific and engineering principles and methods

3.    To provide knowledge and understanding on selected areas of software engineering.

4.    To provide knowledge and understanding of the practical skills towards the development of computer-based solutions of problems to a software engineering provide.

 

Course Learning Outcomes

By the end of this course, the student will be able to:

1.    To explain the concepts and tools for designing software projects.

2.    To demonstrate the knowledge and understanding of the discipline of software engineering, including a sound fundamental understanding of scientific and engineering principles and methods

3.    To show knowledge and understanding of selected of software engineering.

4.    Use practical skills acquired to develop computer-based solutions to software engineering problems

 

Indicative Content

1.    Software engineering concepts and tools (4 Hours)

2.    Phases of software development, (4 Hours)

3.    Software Management: (4 Hours)

Planning and controlling a software development project.

4.    Requirements analysis: (4 Hours)

i)     Requirements specification,

ii)    humans as information sources,

iii)   tools for documenting the requirements (SADT, PSL/PSA, Ada-based analysis methods).

5.    Software design: (4 Hours)

i)     Abstraction,

ii)    modularity,

iii)   information hiding,

iv)   design methods,

v)    design documentation.

6.    Testing, (4 Hours)

i)     test objectives,

ii)    verification and validation,

iii)   manual test techniques,

iv)   techniques for functional and structural testing.

7.    Software development life cycles; (4 Hours)

8.    Software process model; (4 Hours)

9.    Software Metrics; (4 Hours)

10. Software project management. (4 Hours)

11. Metrics and measurements engineering, (4 Hours)

12. Software quality assurance, (4 Hours)

13. software reliability models, (4 Hours)

14. Formal verification of programs, (4 Hours)

15. CASE tools and technology, (4 Hours)

 

 

Study Materials

Relevant text books, power point slides, a projector, lap top and teaching aids necessary.

 

Mode of Delivery

Lectures, Tutorials, Seminars.

 

Mode of Assessment       

Test                                                     15%

Assignment                                       15%

End of semester examination         70%

Total                                                  100%

 

Reading List

1.     Somerville Ian. (2011). Software engineering: 9^th edition, Pearson Education Ltd Publishers. ISBN 10: 0-13-703515-2

2.     Wohlin, C., Runeson., Host,. M., Ohlsson, M. C. Regnell, B., & Wesslen, A. (2012). Experimentation in Software Engineering. Springer Science and Business Media.

3.     Panjak Jalote, (2005), An Integrated Approach to Software Engineering, Fifth Edition, Narosa Publishing House, 1997, 1991, Reprinted 2003, 2004, 2005. 

4.     Brian Marick, The Craft of Software Testing", Prentice Hall.