home

=__**HSC Assessment Task 3 **__=

__Software Application:__ Microsoft Access __Due Date:__ Friday 25th July, 2050 __Weight:__ 25% __Outcomes to be assessed:__ H2.1 Analyses and describes a system in terms of the information processes involved H2.2 Develops and explained solutions for an identified need which addresses all of the information processes H6.1 Analyses situations, identifies needs, proposes and then develops solutions H6.2 Selects, justifies and applies methodical approaches to planning, designing or implementing solutions H7.1 Implements and explains effective management techniques H7.2 Uses methods to thoroughly document the development of individual and team projects ||
 * ﻿H1.1 Applies and explains an understanding of the nature and function of information technologies to a specific practical situation

__Scenario:__  "Music Online" is an online music store which stores and sells music. The online store currently has an unorganised and confusing storage system containing song names but does not contain any further relevant information about the song or artist. The store is becoming very untidy and Mr Music, the store's manager is always losing customers because they are unable to search the database to find what they want. Mr Music would like to implement a newly developed electronic database for the online store. Your task is to develop a proposed database system for Mr Music's "Music Online﻿" store. You will need to work through the five stages of the System Development Cycle and follow effective project management procedures to complete the task.  <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">__Task:__ <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;"> <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">**System** **Development Cycle Documentation:**
 * <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;"><span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">UNDERSTANDING THE PROBLEM (H2.1, H6.1, H7.2)
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Preliminary Investigation- Can the problem be solved with a "quick fix" solution (150 words)
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Problem definition (100 words)
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Requirements of the new system Report (brief description)
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">PLANNING (H2.1, H2.2, H6.1, H6.2, H7.1)
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">A Feasibility Study including:
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Requirement Report (200 words)
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Feasibility of the new system (technical feasibility, schedule feasibility only) (250 words)
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Recommendations for the new system (200 words)
 * <span style="font-family: 'Times New Roman',Times,serif; font-size: 120%;">Designing Specifications for the database (Can be in bullet points) (100 words)
 * <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">DESIGNING
 * <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">A Data Flow Diagram for Searching for music in the store (1 page)
 * <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">An Entity Related Diagram (ERD) (This can be printed straight from Microsoft Access)
 * <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">A description of at LEAST five queries used in your database. (Three of these queries must involve relationships between tables)
 * <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">IMPLEMENTING (H6.1, H7.1)
 * <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">Explanation of the method of conversion to be used when implementing the new system into the online store (400 words)
 * <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">TESTING, EVALUATING, MAINTAINING (H6.1, H7.2)
 * <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">Brief description of the testing and evaluation of the new system (300 words)
 * <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">Evaluation of whether or not the initial needs were met through the development of the new system (150 words)

<span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">**Development of a proposed working prototype (H1.1)** <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">Access 2007, and should contain a minimum of five queries and a number of related tables. <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">(No reports or forms are necessary for the purpose of this assessment.) <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">
 * <span style="display: block; font-family: 'Times New Roman',Times,serif; font-size: 120%;">Construct a database which could be implemented in the online music store. This relational database should be developed using Microsoft