Option
6
6 ECTS
Autumn
None
CSIS440
Dr. Belma Ramic-Brkic
2017
Introduction: data, file and database concepts; database management system (DBMS); types of databases; database life-cycle;
Relational database: tables; keys; relationships; relational algebra;
Data modelling: data abstraction; conceptual data models; entity; attribute; relationship; entity-relationship (E-R) modelling technique; E-R diagram;
Database design: design problems; first, second and third normal forms; normalisation process;
Database implementation: structured query language (SQL), data definition and manipulation commands; queries and reports;
| Type | Number per Term | Duration | Total Time |
|---|---|---|---|
|
Lectures |
30 |
1.5h |
45 hours |
| Tutorials |
15 |
1h |
15 hours |
| Total Guided/Independent Learning Hours |
90 |
||
| Total Contact Hours |
60 |
||
| Total Engagement Hours | 150 | ||
| Type | Number Required | Duration / Length | Weighting | Timing / Submission Deadline |
|---|---|---|---|---|
|
Exam |
1 |
3 hours |
50% |
End of semester |
|
Mid-semester test |
1 |
2 hours |
20% |
Mid-semester |
|
Group Project |
1 |
~2500 words |
15% |
Week 13 |
|
Subject tests |
2 |
90min |
15% |
Week 4 and 12 |
Intended Learning Outcomes:
Demonstrate an understanding of basic concepts and principles
Build conceptual data models for a variety of business scenarios
Use different database modelling and design techniques
Develop a working database application using a commercial DBMS software
Teaching and Learning Strategy:
Lectures on module material (ILO: 1-4)
Tutorials use examples and solutions to illustrate the theory
Lab exercises with appropriate tools and practice problems (ILO: 1-4)
Independent study is based on the recommended text
Group project enables students to develop communication skills and apply what they have learnt in the course to a practical problem (ILO: 1-4)
Assessment Strategy:
Midterm exam and Final exam (ILO: 1-5)
Course projects (ILO:1-4)
Continuous assessment tests (ILO: 1-5)
Practical Skills:
Advanced use of Microsoft Access in generating financial reports and providing necessary data to the upper Management for proper decision making
Advanced use of Microsoft Excel in generating adequate visual presentations of the data flow within the company
Interpret and demonstrate understanding of DB development methodologies
Teaching and Learning Strategy:
Practical demonstrations (PS: 1-3)
Interactive lectures (PS:1-3)(PS: 1-3)
Assessment Strategy:
Written Exam (PS: 1,3)
Group Project (PS: 1,2)
Subject tests (PS: 1-3)
Transferable Skills:
Abstract thinking and modelling of real world objects
Ability to work in teams
IT skills
Communication skills: written and oral
Teaching and Learning Strategy:
Labs with hands-on experience with Microsoft tools: Excel and Access (TS: 1-4)
Group project (TS: 1-4)
Assessment Strategy:
Group project (TS:1-3)
Subject tests (TS: 1)
Set text
Carlos Coronel, Steven Morris, Peter Rob and Keeley Crockett, Database Principles: Fundamentals of Design, Implementation, and Management, 2nd Edition, 2013.
ISBN 978-1-133-31197-3
Supplementary Materials
To be advised
Please note
This specification provides a concise summary of the main features of the module and the learning outcomes that a typical student might reasonably be expected to achieve and demonstrate if he/she takes full advantage of the learning opportunities that are provided.
More detailed information on the learning outcomes, content and teaching, learning and assessment methods of each module and programme can be found in the departmental or programme handbook.
The accuracy of the information contained in this document is reviewed annually by the University of Buckingham and may be checked by the Quality Assurance Agency.
Date of Production : July 2016
Date approved by School Learning and Teaching Committee:
Date approved by School Board of Study :
Date approved by University Learning and Teaching Committee:
Date of Annual Review:
Hrasnička cesta 3a, Sarajevo, 71 000
Bosna i Hercegovina
Prijemni ispiti se održavaju na SSST-u, od aprila do septembra, sa početkom u 9:00 časova.
Tel: +387 33 975 002
Fax: +387 33 975 030
administration@ssst.edu.ba
admissions@ssst.edu.ba
SSST © 2024 Sva prava zadržana
Preuzmi ovdje