BSc: Advanced Databases ======================= Contents -------- * [1 Advanced Databases](#Advanced_Databases) + [1.1 Short Description](#Short_Description) + [1.2 Prerequisites](#Prerequisites) - [1.2.1 Prerequisite subjects](#Prerequisite_subjects) - [1.2.2 Prerequisite topics](#Prerequisite_topics) + [1.3 Course Topics](#Course_Topics) + [1.4 Intended Learning Outcomes (ILOs)](#Intended_Learning_Outcomes_.28ILOs.29) - [1.4.1 What is the main purpose of this course?](#What_is_the_main_purpose_of_this_course.3F) - [1.4.2 ILOs defined at three levels](#ILOs_defined_at_three_levels) * [1.4.2.1 Level 1: What concepts should a student know/remember/explain?](#Level_1:_What_concepts_should_a_student_know.2Fremember.2Fexplain.3F) * [1.4.2.2 Level 2: What basic practical skills should a student be able to perform?](#Level_2:_What_basic_practical_skills_should_a_student_be_able_to_perform.3F) * [1.4.2.3 Level 3: What complex comprehensive skills should a student be able to apply in real-life scenarios?](#Level_3:_What_complex_comprehensive_skills_should_a_student_be_able_to_apply_in_real-life_scenarios.3F) + [1.5 Grading](#Grading) - [1.5.1 Course grading range](#Course_grading_range) - [1.5.2 Course activities and grading breakdown](#Course_activities_and_grading_breakdown) - [1.5.3 Recommendations for students on how to succeed in the course](#Recommendations_for_students_on_how_to_succeed_in_the_course) + [1.6 Resources, literature and reference materials](#Resources.2C_literature_and_reference_materials) - [1.6.1 Open access resources](#Open_access_resources) - [1.6.2 Closed access resources](#Closed_access_resources) - [1.6.3 Software and tools used within the course](#Software_and_tools_used_within_the_course) * [2 Teaching Methodology: Methods, techniques, & activities](#Teaching_Methodology:_Methods.2C_techniques.2C_.26_activities) + [2.1 Activities and Teaching Methods](#Activities_and_Teaching_Methods) + [2.2 Formative Assessment and Course Activities](#Formative_Assessment_and_Course_Activities) - [2.2.1 Ongoing performance assessment](#Ongoing_performance_assessment) * [2.2.1.1 Section 1](#Section_1) * [2.2.1.2 Section 2](#Section_2) * [2.2.1.3 Section 3](#Section_3) * [2.2.1.4 Section 4](#Section_4) - [2.2.2 Final assessment](#Final_assessment) - [2.2.3 The retake exam](#The_retake_exam) Advanced Databases ================== * **Course name**: Advanced Databases * **Code discipline**: XYZ * **Subject area**: xxx Short Description ----------------- This course covers the following concepts: DevOps Engineering concepts:. Prerequisites ------------- ### Prerequisite subjects ### Prerequisite topics Course Topics ------------- Course Sections and Topics | Section | Topics within the section | | --- | --- | | Introduction to subject, computer networks basics, transport layer protocols, and socket programming | 1. General introduction to the course 2. Computer networks basic 3. Socket programming 4. UDP socket programming 5. TCP socket programming | | | | | Coordination, consistency, and replication in distributed systems | | | Fault tolerance and security in distributed systems | | Intended Learning Outcomes (ILOs) --------------------------------- ### What is the main purpose of this course? Advanced Databases have become ### ILOs defined at three levels #### Level 1: What concepts should a student know/remember/explain? By the end of the course, the students should be able to ... #### Level 2: What basic practical skills should a student be able to perform? By the end of the course, the students should be able to ... #### Level 3: What complex comprehensive skills should a student be able to apply in real-life scenarios? By the end of the course, the students should be able to ... Grading ------- ### Course grading range | Grade | Range | Description of performance | | --- | --- | --- | | A. Excellent | 90-100 | - | | B. Good | 75-89 | - | | C. Satisfactory | 60-74 | - | | D. Poor | 0-59 | - | ### Course activities and grading breakdown | Activity Type | Percentage of the overall course grade | | --- | --- | | Laboratory assignments | 55% | | Final exam | 35% | | Attendance | 10% | ### Recommendations for students on how to succeed in the course Resources, literature and reference materials --------------------------------------------- ### Open access resources * Textbook:. Available online: * Reference:. Available online: * Reference:. Available online: h ### Closed access resources ### Software and tools used within the course Teaching Methodology: Methods, techniques, & activities ======================================================= Activities and Teaching Methods ------------------------------- Activities within each section | Learning Activities | Section 1 | Section 2 | Section 3 | Section 4 | | --- | --- | --- | --- | --- | | Development of individual parts of software product code | 1 | 1 | 1 | 1 | | Homework and group projects | 1 | 1 | 1 | 1 | | Testing (written or computer based) | 1 | 1 | 1 | 1 | | Oral polls | 1 | 1 | 1 | 1 | | Discussions | 1 | 1 | 1 | 1 | Formative Assessment and Course Activities ------------------------------------------ ### Ongoing performance assessment #### Section 1 | Activity Type | Content | Is Graded? | | --- | --- | --- | | Question | ? | 1 | | Question | . | 1 | | Question | ? | 1 | | Question | ? | 1 | | Question | ? | 1 | | Question | ? | 1 | | Question | ? | 1 | #### Section 2 | Activity Type | Content | Is Graded? | | --- | --- | --- | | Question | You have a list of large numbers, and you need to find if they are prime or not. Would you use multithreading, multiprocessing, or sequential programming in order to complete the task asap? Prove it in practice. | 0 | | Question | You need to send multiple requests to a server and receive responses. Assume there is a few msecs of delay before you receive the response from the server. Would you use multithreading, multiprocessing, or sequential programming in order to complete the task asap? Prove it in practice. (Order of the requests/responses doesn't matter) | 0 | | Question | Discuss two ways of creating the threads using threading module in Python: 1) passing the worker function as a target, 2) subclassing the Thread class | 0 | | Question | Given the function implemented locally, make it available to be called through RPC from remote process? Use xmlRPC. | 0 | #### Section 3 | Activity Type | Content | Is Graded? | | --- | --- | --- | | Question | ? | 1 | | Question | ? | 1 | | Question | ? | 1 | | Question | ? | 1 | | Question | ? | 1 | #### Section 4 | Activity Type | Content | Is Graded? | | --- | --- | --- | | Question | Same as above | 0 | ### Final assessment **Section 1** 1. ? 2. ? 3. ? 4. ? **Section 2** 1. **Section 3** **Section 4** 1. Same as above ### The retake exam **Section 1** **Section 2** **Section 3** **Section 4**