Introduction to Information Systems

Faculteit Science and Engineering
Jaar 2021/22
Vakcode WBCS021-05
Vaknaam Introduction to Information Systems
Niveau(s) propedeuse
Voertaal Engels
Periode semester II a
ECTS 5
Rooster rooster.rug.nl

Uitgebreide vaknaam Introduction to Information Systems
Leerdoelen At the end of the course, the student is able to:
1) gain understanding and knowledge of the process of data modelling, design, mapping of database schema to relations, realization, and use of relational databases.
2) define database schema and formulating queries using the SQL language.
3) use relational database systems and SQL queries in practice.
Omschrijving Part 1: Introduction to Databases and DB Architecture
- Databases and Database Users
- Database Systems: Concepts and Architecture
Part 2: Conceptual Data Modeling and Database Design using ER
- Data Modeling Using the Entity Relationship (ER) Model
- The Enhanced Entity Relationship (EER) Model
Part 3: The Relational Data Model, Relational Algebra and SQL
- The Relational Data Model and Relational Database Constraints
- The Relational Algebra
- Relational Database Design by ER- and EER-to-Relational Mapping
- Basic SQL
- SQL: Complex Queries, Views, and Schema Modification, Security
Uren per week
Onderwijsvorm Hoorcollege (LC), Practisch werk (PRC)
Toetsvorm Practisch werk (PR), Schriftelijk tentamen (WE)
(The final grade will be based on the written exam and the assignments with weights: 70% WE, 30%Assignments. Passing grade for written exam is 50% (before rounding). Passing grade for assignments: none. Passing grade for the course is 5.5 or higher. Rounding will be done on the final grade as follows: 5.5 will be rounded to 6.0. Any grade above 6.0 will be rounded to the closest 0.5 point.)
Vaksoort bachelor
Co├Ârdinator prof. dr. D. Karastoyanova
Docent(en) prof. dr. D. Karastoyanova , F.F.M. Mohsen, PhD.
Verplichte literatuur
Titel Auteur ISBN Prijs
Fundamentals of Database Systems, 7th Edition, 2006
(available as PDF on Nestor for students enrolled in the course)
Ramez Elmasri, Shamkant B. Navathe 978-1-292-09761-9
Entreevoorwaarden Advisable: Logic
Opmerkingen All CS bachelor courses have limited enrollment:
- CS students can always enter each course, regardless of whether the course is mandatory for them or not.
- A maximum of only 20 places per course is available for non-CS students. These places are filled on a first-come-first-served basis, with priority given to students with a strong CS-related background (e.g., CS exchange students, AI students, etc.). These students need to meet the course prerequisite requirements as mentioned on Ocasys.
- Six weeks before the course starts, the 20 students that can join are selected and added to the course. If you enroll after this date, you will be placed on the waiting list.

For more info about the enrollment procedure, see https://student.portal.rug.nl/infonet/studenten/fse/programmes/bsc-cs/general/vakintekening-procedure#cap
Opgenomen in
Opleiding Jaar Periode Type
BSc Artificial Intelligence  (Keuzevakken) 2 semester II a keuze
BSc Artificial Intelligence  (Keuzevakken) 3 semester II a keuze
BSc Computing Science 1 semester II a verplicht
BSc Courses for Exchange Students: AI - Computing Science - Mathematics - semester II a