Module Information Summary
Module Description – General
Module Code Module Name
Year Level (Module) Credit Value Semester(s) Oered
Copyright By PowCoder代写 加微信 powcoder
Module Leader
ITS62904 Database Systems 1
March August
Students are introduced to understand the fundamental approaches and concepts. The learning and teaching approach for the module will include understanding the basics of database technologies, engaging with practical tasks during the designing database and creating tables. They also present their ideas and thoughts within the group. The module is supported by a combination of dwelling explores the ideas and thoughts. The module is supported by a combination of online lectures and eldwork sessions. This module is an introduction to database systems. This module covers the fundamental issues of the relational model, relational languages, database design, and query processing. It starts with a structured overview of database systems, their history, and their applications. The relational model is then covered in detail. Relational languages such as relational algebra and calculus are discussed before introducing the SQL language. Then we cover the Entity-Relationship model and discuss how ER diagrams are translated into the relational model. Topics on database design principles in this module further include functional dependencies and normalization. Students will gain a good understanding of database design theory and principles and be able to develop database systems and application programs on a DBMS.
This module uses three methods of assessment including an individual’s knowledge base, problem-based, and use case-based. To assess students’ knowledge, descriptive questions will be used. This method is used in Test 1 and the nal exam. A problem-based assessment helps to assess and evaluate students’ problem-solving skills. This assessment approach is applied in all the module’s assessments but is mainly used in Test 2 and Final exams. The use case-based assessment approach is oering an opportunity of dealing with real cases that students may face in the future. This approach is used in the assessment and nal exam.
General Pre-Requisite Module Pre-requisite General Co-requisite Module Co-requisite General Anti-requisite Module Anti-requisite
Module Owner
Domain Name (for free electives only) Module Oered as
Nil – Nil – Nil –
School of Computer Science & Eng ineering –
Primary Major – Core
MLO1 MLO2 MLO3 MLO4
Description
Describe the concept of database management systems topics including Data modelling, Normalization, and Transactions.
Demonstrate the ability to analyze an appropriate data model based on dierent case studies using System Requirement Specication (SRS).
Demonstrate the personal ability to implement various use of database systems through visual, written and oral forms eectively over a set timeline.
Demonstrate the capability to interact positively in a group of peers, consider others’ points of view, and foster stable and harmonious relationships in solving computational problems related to design Conceptual model and Logical model of a selected scenario.
40 10 20 30
Module Description – Module Learning Outcomes (MLO)
Module Learning Outcomes (MLO)
TGC Attributes
TGC 1 Discipline-specic knowledge and Skills
TGC 2a Problem Solving Skills
TGC Sub- Attributes
1.2 2a.1 2a.2 5.3
Description of sub-attributes
Knowledge – Demonstrate a broad and coherent theoretical and technical knowledge to communicate and understanding relating to the discipline- specic content
Comprehension – Demonstrate comprehension of disciplinary concepts Identify the problem
Propose solutions to existing and emerging problems
Persevere in overcoming obstacles and setbacks (Measuring: Grit/Res ilience)
Flexibility in handling change, multiple demands, and adapting to ideas or approaches (Measuring: behavioural exibility/adaptability)
Set and monitor progress towards personal and academic goals (Measuring: students goal-setting ability i.e set, monitor and fulll goals over set timeline)
Take perspective and empathize with others (Measuring: Empathy)
Recognize and appreciate individual and group similarities and dierences. (Measuring: Social Awareness/Sensitivity)
Build positive relationships, establish and maintain cooperative relationships and actively participate within a group (Measuring: Relationship Management and Active Participation)
TGC 5 Personal Competencies
Social Competencies
Module Description – Align MLO to PLO & TGC Sub-Attribute
Transferable Skills
TGC TGC Attribute Description of TGC Attributes Sub-Attribute Description of sub-attributes
TGC 1 Discipline-specic knowledg e and Skills Discipline-specic knowledg e and skills refers to the ability to demonstrate professional 1.1 competence, adapt discipline specic knowledg e, and be able to integ rate knowledg e across
dierent perspectives.
Knowledg e – Demonstrate a broad and coherent theoretical and technical knowledg e to communicate and understanding relating to the discipline-specic content
1.2 Comprehension – Demonstrate comprehension of disciplinary concepts
TGC 2a Problem Solving Skills Problem Solving Skills refer to the ability to deal with problems/tasks/situations, formulate a 2a.1 Identify the problem plan to resolve a problem, implement a solution and monitor the process. In addition students
need to be able to reect on and evaluate the process and outcome to answer an open-ended 2a.2 Propose solutions to existing and emerg ing problems question or achieve a desired g oal.
Personal Competencies
Personal Competencies refer to the ability to be self-aware and to self-reg ulate emotions 5.3 throug h skillful manag ement of one’s personal g oals, intentions, responses and behaviour.
Persevere in overcoming obstacles and setbacks (Measuring : Grit/Resilience)
5.4 Flexibility in handling chang e, multiple demands, and adapting to ideas or approaches (Measuring : behavioural exibility/adaptability)
5.5 Set and monitor prog ress towards personal and academic g oals (Measuring : students g oal-setting ability i.e set, monitor and fulll g oals over set timeline)
Social Competencies
Social Competencies refer to the ability to empathize with others, interact positively with them 6.1 and foster stable and harmonious relationships.
Take perspective and empathize with others (Measuring : Empathy)
6.2 Recog nize and appreciate individual and g roup similarities and dierences. (Measuring : Social Awareness/Sensitivity)
6.3 Build positive relationships, establish and maintain cooperative relationships and actively participate within a g roup (Measuring : Relationship Manag ement and Active Participation)
Module Description – Transferrable Skills
Description of Assessment Components
The assessment for this module is external (Taylor’s College) NO
Resit Opportunity TU-UWE
Assessment Tasks
Assessment T ask Weig ht MLO Assessed T GC Assessed Due Dat e Maximum Mark (T ask Level) Maximum Mark (MLO Level)
Test 10% MLO2 2a 6 10 10
PracticalTest 20% MLO3 5 9 20 20 Group Assignment 30% MLO4 6 12 30 30 FinalExamination 40% MLO1 1 16 40 40
Module Description – Align MLO to Assessment Tasks and T&L Strategies
Module Description – Resit Assessment
Description of Resit Assessment
Resit Opportunity –
Assessment Tasks
Assessment T ask Weig ht MLO Assessed T GC Assessed Maximum Mark (T ask Level) Maximum Mark (MLO Level)
Resit Coursework 60% MLO2 TGC 2a 60 10 MLO3 TGC5 20 MLO4 TGC6 30
Resit Final Examination 40% MLO1 TGC 1 40 40
Assessment Task MLO Assessed
Demonstrate the ability to analyze an appropriate data model based on dierent case studies using System Requirement Specication (SRS).
Test: (MLO Assessed: MLO2 )
Crit eria Weig ht ag e
Exploring one of the top applications that exists in the world as a real mini-world and analyzing how a successful application uses database systems to address the requirements of a project/problem. 10%
Practical Test
Demonstrate the personal ability to implement various use of database systems through visual, written and oral forms eectively over a set timeline.
Practical Test: (MLO Assessed: MLO3 )
Crit eria Weig ht ag e
Designing simple to complex SQL statements according to a given scheme using equality, similarity and range conditions. The statements cover dropping and truncate a table, inserting, updating, and deleting records as well as dierent JOIN queries. 20%
Group Assignment
Demonstrate the capability to interact positively in a group of peers, consider others’ points of view, and foster stable and harmonious relationships in solving computational problems related to design Conceptual model and Logical model of a selected scenario.
Group Assignment: (MLO Assessed: MLO4 )
Crit eria Weig ht ag e
Build positive relationships, and actively participate within a group in seeking a solution to a given Scenario to design, develop, and implement a logical model – Database Design – ERD model. 30%
Final Examination
Describe the concept of database management systems topics including Data modelling, Normalization, and Transactions.
Final Examination: (MLO Assessed: MLO1 )
Crit eria Weig ht ag e
Describe the concept of database management systems topics including Data modeling, Normalization, and Transactions. 40%
Module Description – Rubrics for Assessment Tasks
A student must achieve at least 50% for the overall assessment and a nal grade of C to pass the module. A student who obtains a minimum of 40% for the overall assessment and an overall grade of D or higher for the module may be allowed to re-sit the examination. The maximum passing grade awarded for the resit examination will be a grade C. A student who obtains 39% and below for the nal assessment, will result in failing the module irrespective of the overall marks earned, even though he/she has achieved 50% or more in the overall assessment. He/she will not be allowed to resubmit the nal assessment.
Section 8 Module Description –
Week Guided Learning F2F (Lecture)
Introduction to Database Systems
Data Modeling
Data Modeling
Week4 1 Normalization
Week5 1 Normalization
Week6 1 SQLProgramming
Week7 1 SQLProgramming
Week9 1 SQLProgramming
Guided Learning F2F (Tutorial)
Guided Learning Guided Guided Learning F2F (Practical) Learning F2F NF2F/Online
Independent Student Learning Time
Assessment Task (F2F)
Assessment Task (Online)
Assessment Task (Independent SLT)
Student Learning Time(SLT)
Total Hour 4
HOURS 0012
Introduction to Introduction to Database Systems Database Systems
Data Modeling Data Modeling Data Modeling 2026
Data Modeling Data Modeling Data Modeling 2026 Normalization Normalization Normalization 2620
020 Test 000
SQL Programming
Database Systems – Group Assignment
1 SQLProgramming
Stored Programs & Functio ns
Normalization
2 SQLProgramming 2 SQLProgramming 0
2 SQLProgramming 2 SQLProgramming
Transaction, Concurrency and Control
Database Technology
Database Technology
Test Preparation 0
Normalization 26
SQLProgramming SQLProgramming 26 SQLProgramming SQLProgramming 13 SQLProgramming SQLProgramming 26 SQLProgramming SQLProgramming 26 SQLProgramming SQLProgramming
Stored Programs & Stored Programs & Functions Functions
Week12 1 0
Transaction, Concurrency and Control
Week13 1 0
Database Technology
Week14 1 0
Database Technology
Week15 0 0 Week16 0 0
Week17 0 0 Total 13 0
Transaction, Database Systems – Concurrency and Group Assignment
Control 026000
Database Database Technology Technology
Database Database Technology Technology
Database Systems – Final Exam Preparation
000000 6 26 77 2 4 10
Transaction, Concurrency and Control
Module Description – Student Learning Time (SLT) normal-long semester
Main references supporting the module
1 . Korth; S. Sudarshan; , Professor
Year of Publication
Database System Concepts
McGraw-Hill Education
0078022150; 9780078022159
0359518044; 9780359518043
3658245484; 9783658245481
ISSN Form Source
– google_books – google_books
ISSN Form Source
– google_books – google_books
Other Additional Information
2019-02-19
2020-04-18
– Publishing Factory
Edition Publisher
– Lulu.com
– Wiesbaden
Year of Publication
2019-05-05
2019-07-16
Relational Database Systems – Why and How
SQL & NoSQL Databases
Module Description – Reference
Eective Study Intake/Semester
Revision Number
Special Requirements to deliver the Module Nil
Please tick ( ) if this module is /Clinical Placement/Practicum/WBL using 2 weeks, 1 credit for SLT
Approved by SPC
SPC Approval Date Discipline Code
Information Technology
202203 1.05
School of Computer Science & Eng ineering Feb 11 2022
Module Description – Approval Details
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com