Reference no: EM132330554
Assignment - Practical
Scenario
You are starting an online bookstore that specialises in educational and foreign language children's books and novels. You'rejust starting up your website. Your distribution centre is located within the Melbourne metropolitan area. You need a website that allows customers to browse titles, place orders, and pay online. Behind the user-friendly web-interface you need a database that maintains real time data about stock levels, manages customer details such as order details and delivery details, and can be used by management to identify trends in sales. You need a system that facilitates growth as you know interest is strong. eBay sales have been good over the past few months, but it's time to give the business a professional makeover with an amazing looking website to attract customers far and wide including schools and libraries.
Business Domain
Document the business domain.
Identify and document business rules.
Specific standard -
Student must prepare a business domain with data object and model to serve the business case.
Your business domain should be incorporated in a professionally presented report which includes:
• Well defined business domain,
• Business rules imposed by the system,
• Data models and data processes supported,
• Business and IT users,
• Stakeholders,
• System charts and boundaries.
Gather Information
Identify and document information gathering methods and modelling methodologies to be used.
Identify and document suitable business data. Analyse the data to understand business operations and document the business operations.
Student must demonstrate the application of appropriate requirement analysis and data gathering techniques together with the appropriate tools (interview questions or survey forms).
Your requirement analysis should be incorporated in a professionally presented report which includes:
• Description for selected methodology,
• Analytical Results the process,
• Validation of employed methodology and business domain,
• Documents used in the process,
• Completed documents from relevant stakeholders,
• Steps in performing your analysis.
Use Cases
Generate UML Use Case diagrams incorporating all users/actors and identify system boundaries.
Document every Use Case identified in the UML Use Case diagrams.
Student must represent the business case with UML case diagram. Your UML - Use Cases diagram should be incorporated in a professionally presented report which includes:
• A completed Use Cases (diagram) for your system,
• At one completed Use Case Template,
• Well defined actors and boundaries,
• Include and extend,
• Generation and specialisation.
Model Data Processes
Identify and document business processes and functions. Identify and document external events, procedures and results.
Generate Business Process Model and Notation (BPMN) diagrams to define the ways in which business operations are carried out to accomplish the intended objectives ofthe business.Review the business rules to determine the impact on the process models and make changes as required.
Have the client validate the BPMN diagrams to determine inaccuracies. Incorporate identified changes as required, then validate the completed BPMN diagramswith the client.
Student must demonstrate the application of data object or data process techniques using the BPMN to represent the business case. The presented BPMN must capable to serve the given business case. Your Model Data Processes should be incorporated in a professionally presented report which includes:
• Well defined functions/processes supported,
• List if events, procedures and expected results,
• A completed BPMN for your system,
• Validation of business rules are supported by your BPMN,
• Indicate any insufficiency in your developed model,
• Adjustments from your domain model and Use Cases,
• Impacts on modifications to your systems.
Database Model
Create a Conceptual Model Entity Relationship Diagram (ERD).
Create a Logical Model ERD.
Decompose and normalize the Logical Model ERD.
After completing the normalization process, compare the target data against original source data. Document and reconcile any differences between the data and review the business rules to determine impact.
Create a Physical Model ERD.
Document the completed ERD in a Data Dictionary.
Generate MySQL CREATE TABLE statements from the Physical Model ERD and add them to the appendices.
Have the client validate the ERD,Data Dictionary, and SQL statements.
Resolve any issues or recommendations that the client may have.
Student muse be able to represent the given business case using appropriate conceptual, logical and physical ERDs.
After the completion of ERDs, student must be able to transfer the ERD model to database model.
The completed database model must be fully normalised to at least 3NF.
Selected simulated system (MySQL, Access, etc) must be capable to communicate and work with the completed database model to serve at least the CRUD operational requirements.
Your Database Model should be incorporated in a professionally presented report which includes:
• Your conceptual, logical and physical ERDs,
• Completed fully normalised database model,
• Capacity to support basic CRUD,
• SQL statements to import/export data,
• Simulation of your data model to support all data processes.
Submission / Final Approval
Submit to client for final approval.
The document you submit must be presented professionally and should be free of spelling and grammatical errors and must include;
• Cover Page
• Table of Contents
• Introduction
• Body
• Conclusions and Recommendations
• References
• Appendices
• Bibliography
• Glossary
All work must be submitted to Moodleat least one week prior to the end of term.