Establishment
Language of instruction
English
Teaching content
MANAGEMENT OF INFORMATION SYSTEMS
This course occurs in the following program(s)
IESEG Degree - Programme Grande École
- Crédits ECTS: 2.00
Training officer(s)
K.MOHAJERI
Stakeholder(s)
Kaveh Mohajeri
Présentation
Prerequisite
1. Digital literacy, i.e., a general understanding of basic computer concepts (software and hardware), the Internet, new information technologies and digital security
2. General understanding of how IT is being used in organizational settings
3. Familiarity with mathematical logic and set theory, including applications in Boolean algebras
2. General understanding of how IT is being used in organizational settings
3. Familiarity with mathematical logic and set theory, including applications in Boolean algebras
Goal
At the end of the course the student should be able to :
1. Recognize how data must be stored in a relational database
2. Describe the relational set operators
3. Practice data modeling and ER diagramming
4. Explain the concepts of dependency diagram, partial dependency, transitive dependency and relational schema
5. Apply normalization methods to any type of data structure in order to achieve 1st, 2nd, 3rd and Boyce-Codd normal forms
6. Practice SQL (both data definition and data manipulation) programming
7. Discuss the basics of the analysis and design of database systems
8. Identify issues related to organizational administration and security of database systems
1. Recognize how data must be stored in a relational database
2. Describe the relational set operators
3. Practice data modeling and ER diagramming
4. Explain the concepts of dependency diagram, partial dependency, transitive dependency and relational schema
5. Apply normalization methods to any type of data structure in order to achieve 1st, 2nd, 3rd and Boyce-Codd normal forms
6. Practice SQL (both data definition and data manipulation) programming
7. Discuss the basics of the analysis and design of database systems
8. Identify issues related to organizational administration and security of database systems
Presentation
Chapter 1 (Database Systems)
Chapter 2 (Data Models)
Chapter 3 (The Relational Database Model)
Chapter 4 (Entity Relationship (ER) Modeling)
Chapter 6 (Normalization of Database Tables)
Chapter 7 (Introduction to Structured Query Language (SQL))
Chapter 8 (Advanced SQL)
Chapter 9 (Database Design)
Chapter 16 (Database Administration and Security)
Chapter 2 (Data Models)
Chapter 3 (The Relational Database Model)
Chapter 4 (Entity Relationship (ER) Modeling)
Chapter 6 (Normalization of Database Tables)
Chapter 7 (Introduction to Structured Query Language (SQL))
Chapter 8 (Advanced SQL)
Chapter 9 (Database Design)
Chapter 16 (Database Administration and Security)
Modalités
Organization
Type | Amount of time | Comment | |
---|---|---|---|
Présentiel | |||
Cours interactif | 16,00 | ||
Autoformation | |||
Lecture du manuel de référence | 19,00 | To study the textbook's covered chapters, and the in-class lecture slides and exercises. | |
Travail personnel | |||
Charge de travail personnel indicative | 15,00 | Three assignments (two will be graded). | |
Overall student workload | 50,00 |
Evaluation
- Two multiple-choice quizzes on Chapters 1, 2, 3 and 4 (covers learning outcomes 1, 2 and 3) - Each individual student may ask the instructor to go over their own graded quizzes.
- Two homework assignments on Chapters 6, 7 and 8 (covers learning outcomes 4, 5 and 6) - The solutions will be given to students after the submission deadline. Each individual student may also ask the instructor to go over their own graded assignments.
- One mid-term exam on Chapters 1-4 and 6 (covers learning outcomes 1 to 5) - The solutions will be reviewed in class, if class time allows. Each individual student may also ask the instructor to go over their own graded exam paper.
- One written final exam on Chapters 7, 8, 9 and 16 (covers learning outcomes 6, 7 and 8) - Each individual student may ask the instructor to go over their own graded exam paper.
- Two homework assignments on Chapters 6, 7 and 8 (covers learning outcomes 4, 5 and 6) - The solutions will be given to students after the submission deadline. Each individual student may also ask the instructor to go over their own graded assignments.
- One mid-term exam on Chapters 1-4 and 6 (covers learning outcomes 1 to 5) - The solutions will be reviewed in class, if class time allows. Each individual student may also ask the instructor to go over their own graded exam paper.
- One written final exam on Chapters 7, 8, 9 and 16 (covers learning outcomes 6, 7 and 8) - Each individual student may ask the instructor to go over their own graded exam paper.
Control type | Duration | Amount | Weighting |
---|---|---|---|
Contrôle continu | |||
Examen partiel | 1,33 | 1 | 30,00 |
QCM | 0,16 | 2 | 15,00 |
Examen (final) | |||
Examen écrit | 2,00 | 1 | 35,00 |
Autres | |||
Rapport écrit | 0,00 | 2 | 20,00 |
TOTAL | 100,00 |
Ressources
Bibliography
Database Systems Design, Implementation, & Management 13th Edition - Carlos Coronel and Steven Morris (ISBN-13: 978-1337627900 / ISBN-10: 1337627909) -
Internet resources