Learning outcomes

At the end of the course the student will be able to : • Describe the main characteristics of an information system. • To classify information systems from a functional and technological point of view. • Manipulate data from relational databases. • Understand the structure of a database. • Participate in the modelling of a database

Goals

This course will aim at describing from a functional point of view the most widely used types of information systems (ERP, Collaborative Systems, KMS, ...) in companies. It will approach these different information systems mainly from two perspectives: (i) their software life cycles and (ii) the technologies that support them. Among these technologies, relational databases will be studied in particular, both in terms of their design and data manipulation aspects.

Content

This course is a detailed introduction, from a business analyst's perspective, to an area that is becoming increasingly important within the operationalisation of business processes in companies, namely information systems. To this end, the following topics are covered during the course: • Definitions and descriptions of the components of an information system ; • Functional classifications of the most common information systems in companies ; • Data manipulation with SQL ; • Data structure modelling and design for relational databases.

Assessment method

Oral examination on knowledge/skills.

Sources, references and any support material

• P. Vidal, Ph. Planeix. Organizational Information Systems. Pearson Education. • Hainaut. Bases de données: concepts, utilisation et developpement: cours et exercices corriges. Paris: Dunod. • G. Curtis, D. Cobham. Business Information Systems. Prentice Hall.

Language of instruction

French