BIS1002 Data and Information Management Assessment-1 Assignment Help

BIS1002 Data and Information Management 

Trimester 1, 2025 

Assessment 1: Database Interrogation


Assessment Overview

Weighting 

40% of unit total

Due Date 

Weeks 2, 4, 6, 8, 10

Assessment Type

Individual assessment

Word Count / Length 

2500 words +/- 10%

Unit Learning Outcomes 

In this assessment, you will be tested on whether you have successfully met the  following Unit Learning Outcomes (ULOs):  

ULO-1: Understand and evaluate the role of database management  systems in information technology applications within organisations. ULO-2: Identify organisational requirements for data and develop data  models using conceptual data modelling techniques. 

ULO-3: Explain and apply database design techniques for relational  database systems.

Submission Type and  Required Format

The type of assessment you will be completing is an individual assessment. It should include solutions of in-class activities represented in the form of data  model diagrams or SQL queries. The solutions must be imbedded in the provided  Database Interrogation Word document and uploaded in Canvas. 

Assessment Details

Assessment Purpose 

The purpose of this assessment is to assess students’ ability to apply theoretical  knowledge to practical database questions. 

Each Database Interrogation activity contains 2-3 practical exercises  related to corresponding steps in relational database design process:  Conceptual Design, Logical Design, Physical Design, Implementation and  Testing. 

Students will gain practical skills in creating Conceptual and Logical Data  Model diagrams, database normalization, and writing SQL queries.

Assessment Instructions 

In this assessment, you will need to complete the following steps: 1. Download the MS Word database interrogation document from Canvas. 2. Work on the in-class exercises using app.diagrams.net online software or  XAMPP MySQL software.



3. Embed the solution in the Database Interrogation document and submit it  in Canvas.

Artificial Intelligence (AI)  Use

In this assessment, the use of generative artificial intelligence (AI) tools is NOT  PERMITTED. In this assessment, you must NOT use generative artificial  intelligence (AI) to generate any materials or content in relation to the assessment  task.  

This means you are NOT allowed to use any AI tools such as chatbots, text  generators, paraphrasers, summariser, or solvers to complete your assessment.  You are expected to produce your own work and cite any sources properly.  

Engaging with AI tools for this assessment will be treated as a breach of academic  integrity. Refer to the Academic Integrity Policy and Procedure for more details.

Other Important Information

Assessment Resources 

It is strongly recommended that you use the following to find academic peer reviewed sources of information. 

ECA Library catalogue and databases  

Unit Readings (Course Reserves)

Subject Guide: Information Technology   

For in-text citation and referencing, follow the ECA HE Student Guide to APA 7th Referencing.

Submission  

Requirements

On completion of your assessment:  

Follow the Assessment Presentation Guidelines 

Submit your document as a MS Word document via the assessment  submission link in Canvas.  

Save drafts of your work.

Assessment Support 

For academic support or feedback on a draft of your assessment, please email  [email protected] 

For assistance with finding resources, such as books and journal articles, please  email [email protected]  

For information and guides on tackling assessments and developing your academic  skills, please visit in the ECA Library and Learning Support website:  https://eca.libguides.com/ 

For queries about this specific assessment task, please contact the Unit Coordinator.

2