| CODE | CIS1042 | |||||||||
| TITLE | Introduction to Databases and Information Management | |||||||||
| UM LEVEL | 01 - Year 1 in Modular Undergraduate Course | |||||||||
| MQF LEVEL | 5 | |||||||||
| ECTS CREDITS | 6 | |||||||||
| DEPARTMENT | Computer Information Systems | |||||||||
| DESCRIPTION | The aim of this unit is to introduce students to the background of databases and DBMSs, their use and architecture, concepts of database design and implementation and to teach basic skills and techniques in creating, updating and querying databases. An introduction to the database approach, characteristics, advantages and disadvantages of using a DBMS. Historical development and overview of current application areas. Use of databases for Datawarehousing, GIS, Data Mining and Multimedia applications. Issues related to different data formats The role of Databases in an organization. The types of users. The role of the Database administrator. The database application system life cycle. The principal components and architecture of a DBMS. The processes of database design and implementation. Database conceptualisation, modeling the database, logical and physical data independence, the three-schema conceptual architecture, The use and composition of ER diagrams. The development Entity Relationship diagrams from user requirements. The relational model, principal components, relational schema design. Conversion of ER model to Relational Schema model. Introduction to a formal database language -Relational Algebra, knowledge and use of basic relational operations. Structured Query Language basic DDL and DML commands covering the specification of tables and constraints, basic updating of data and various query operations Use of a relational database management systems is made though a number of practical / presentation. The lecturer provides unit material. Textbooks: • R Elmasri & S Navathe, Fundamentals of Database Systems, Addison-Wesley. • R Earp & S Bagui, Learning SQL: A step-by-step guide using Oracle, Addison-Wesley. |
|||||||||
| ADDITIONAL NOTES | Pre-requisite: ‘A’ Level Grade C (Computing or I.T.) or following a Computing course. Leads to: CIS2090 |
|||||||||
| STUDY-UNIT TYPE | Lecture | |||||||||
| METHOD OF ASSESSMENT |
|
|||||||||
| LECTURER/S | Joseph Vella |
|||||||||
|
The University makes every effort to ensure that the published Courses Plans, Programmes of Study and Study-Unit information are complete and up-to-date at the time of publication. The University reserves the right to make changes in case errors are detected after publication.
The availability of optional units may be subject to timetabling constraints. Units not attracting a sufficient number of registrations may be withdrawn without notice. It should be noted that all the information in the description above applies to study-units available during the academic year 2024/5. It may be subject to change in subsequent years. |
||||||||||