Reference no: EM132330803

ASSESSMENT TASK 1

Question 1 - Describe database identifiers and their impact on database usability

Question 2 - Describe normalisation rules and processes for the following:
• UNF: Unnormalized form
• 1NF: First normal form
• 2NF: Second normal form
• 3NF: Third normal form
• BCNF: Boyce-Codd normal form
• 4NF: Fourth normal form
• 5NF: Fifth normal form
• 6NF: Sixth normal form

Question 3 - Describe the following type hierarchies related to development of structured data types:
• Super-types
• Sub-types
• Root-types

Question 4 - Describe validation procedures and processes.

Question 5 - Describe the function and features of the entity-relationship model approach to data modelling.

Question 6 - Describe the function and features of the following;
• Primary Keys
• Foreign Keys
• Unique Keys
• Composite Keys
• Candidate Keys

Question 7 - Describe the function and features of time stamps related to the use of keys

Question 8 - Describe the function and features of the following;
• User defined types
• Structured types
• Reference types
• User defined functions

Question 9 - Describe the function and features of data types and their application.

Question 10 - Discuss modelling rules and conventions with reference to naming processes and events.

Question 11 - Outline features and functions of process mappers.

Question 12 - Explain features of data analysis, particularly in determining process flows.

Question 13 - Describe processes and techniques, using logical design concepts related to designing process models.

Question 14 - Class Presentation

Select a topic from Question 1 to Question 13, you need to prepare a 5 to 10 minutes class presentation for your selected topic in Week 05.

ASSESSMENT TASK 2 - Project + Presentation

You will be provided with a business case related to the unit of competency undertaken in your course. You are required to complete a practical project by using appropriate data,objects, models and processes to simulate an implementation for the given business case. Your practical project must include a well-defined business domain, methods of information gathering, use cases (conceptual and physical), Business Process Model and Notation (BPMN) diagrams, Entity Relationship Diagram (ERD - conceptual, logical and physical), a completed data dictionary and a proposed DBMS. Thispractical projectis intended to assess you level of knowledge and practical skills in relation to various aspects of the unit/s.

It is important that you read each question carefully prior to starting the assessment and seek clarification if any question is unclear. Please note your assessor can only provide more information to clarify the intent of the question, not provide details of the required answer.

Business Case (Scenario)

You are starting an online bookstore that specialises in educational and foreign language children's books and novels. You're just 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.

You are required to complete a practical project by using appropriate data, objects, models and processes to simulate an implementation for the given business case. To support your practical project,

1. You are required to submit a business proposal to your client seeking the final approval for your business case,
2. With your final submission, you are also required to prepare a project presentation for your client final approval.

Business Domain
Document the business domain
Identify and document business rules.
Requirement Analysis (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.

UML - Use Cases diagrams
Generate UML Use Case diagrams incorporating all users/actors and identify system boundaries.
Document every Use Case identified in the UML Use Case diagrams.

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 of the 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 diagrams with the client

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
In a simulated mode, generate MySQL CREATE TABLE statements from the Physical Model ERD
Validation (Data Objects and Processes)
In a simulated mode, validate the ERD, Data Dictionary, and SQL statements. Identify any issues then provide appropriate recommendations

Class Presentation
Final presentation for the completed business case.

Attachment:- Model data processes.rar