CSYM017 Databases Individual Assessment AS1 Brief | UON

CSYM017 Assessment Task:

Title (Question): Individual assignment work

Setting the scene:

The assignment is designed to prepare students for designing relational and graph models based on a given dataset, implementing them into working databases, performing transactional queries for decision-making, etc. The students are also required to compare and reflect on the data models for the choice of future application scenarios.

This assignment requires students to complete all assignment tasks to achieve the learning outcomes.

The assignment includes two key parts: 

1. Portfolio (40%);
2. Assignment Task (60%)

Learning Outcomes aligned to this Assessment:

On successful completion of this assessment, you will be able to:

1. Explain in depth how relational metadata and SQL's data definition/manipulation language are conceptually underpinned by the relational model.
2. Interpret and discuss in depth the semantics of database modelling techniques.
3. Appraise the functional capabilities of SQL's definition/manipulation language.
4. Obtain good understanding of the NoSQL concepts and various database systems in this category.
5. Recognise how common requirements of database applications are related to database functionality.
6. Design, validate and refine an appropriate model which correspond to a given description of a data related problem.
7. Implement a functional database system based on a given model.
8. Perform database queries using appropriate languages/standards, e.g., SQL, Cypher, etc.
9. Design, build and thoroughly test a series of client-based programs which communicate with the backend database. All software developed must adhere to appropriate Human Computer Interaction (HCI) principles.
10. Critical Thinking: evaluate ideas and concepts.
11. Professional communication: communicate effectively in a variety of situations with different audiences including via electronic media, including face to face group discussions, software demonstrations requiring technical knowledge and language, walkthrough sessions.

Part 1) Portfolio

Students are expected to log their learning activities (e.g., lab exercises and extra work) in the portfolio. There is no standard format, however, the portfolio should be structured well for easy reading (e.g., including a Table of Contents with week numbers). The work each week in the portfolio should include two sections: 1) the learning activities (i.e.,

CSYM017 A51: Postgraduate Marking Rubric