Investigate a business and propose business solution

Assignment Help Database Management System
Reference no: EM131983061 , Length: word count:3500

Systems Analysis and Design Assignment -

Group Assignment Requirements

In this assignment you are required to use the systems approach to investigate a business and propose business solution for the Holmes College-Case Study. You, as a team, are required to produce a business report between (2500 and 3500 words). The following sections are suggestions for the groups' consideration:

1. Introduction - State the purpose of the report

2. Business Overview - Write up a brief overview of the company:

  • Structure,
  • Key Activities
  • Problems,
  • Gaps,
  • Opportunities,
  • Functional Decomposition

3. Analysis

  • Current processes,
  • Requirements Determination,
  • DFD (Context, Level 0 and Level 1)
  • Logical Modelling

Design a decision table for a process in this system with all possibilities

Draw a decision tree that reflects a process used in the system

Data Modelling (ER Diagram)

4. Requirement Specification - Functional and Non-Functional

5. Proposed Business Solution - Forms, Reports, User Interface design

6. Project Feasibility - Cost, Benefit, Risk Analysis

7. Implementation - Options

8. Maintenance - Maintenance Request and Requests for Implementing Changes

9. Conclusions - Recommend a key area for detailed analysis. Justify your suggestions

10. Appendices - If any

For Group Report, students are required to use Microsoft VISIO tools to design Context & DFD diagrams and Data Modelling Process.

Construct an Entity Relationship Diagram using Microsoft VISIO tools based on the case study described below. The ER model should include the following:

  • A brief description of the notation used in the model
  • A statement of all business rules adopted in the development of the diagram
  • A definition of all the entities
  • An English interpretation of all the relationships
  • The actual Entity Relationship Diagram showing all details (Modality, Cardinality, Primary and foreign Keys ... etc)
  • All many to many relationships must be resolved and should not appear on the diagram as many to many. Any one to one relationships used should be justified)
  • A List (at least 3) of the possible attribute associated with every entity identified.

Construct a Context Diagram, Function Decomposition & Data Flow Diagrams (Level 0 and level 1 only) based on the case study provided. There should be one level 0 diagram only, and for each function/process defined in the level 0 diagram, one level 1 diagram is required. (Might be pushing it to get a full set of level ones with the amount of information you have given them. You might consider asking for a couple of level 1 diagrams.)

All diagrams must be computer generated using VISIO tools and balanced in conformance to the rules and standards specified in lectures and tutorials.

Attachment:- Assignment Files.rar

Reference no: EM131983061

Questions Cloud

Describe steps that you would use in order to convert tables : Describe the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form.
Emotional bank account in line : Work on building positive credits with your manager, reportee or colleague in his or her Emotional Bank Account in line with what you have identified
Predict the selected companys ability to adapt : Evaluate management's decision on its use of vendors and spokespersons. Indicate the organizational impact of these decisions.
What steps might have been taken to detect davids alleged : What steps might have been taken to detect David's alleged industrial espionage? What steps might have been taken to prevent his perpetrating such an offense?
Investigate a business and propose business solution : HS2011 Systems Analysis and Design Assignment - Investigate a business and propose business solution for the Holmes College-Case Study
Deming and crosby approach : What is the difference between Deming's and Crosby's approach? How does Crosby plan to attain Zero Defects? How does Juran differ from Cosby.
Bond valuation-holding period return for the one-year period : If you were to sell the bond today what would be your holding period return for the one-year period?
Commitment to corporate social responsibility : Imagine you are a supervisor at Allstate. Suggest a few ways you could help carry out Allstate's commitment to corporate social responsibility.
What evidence of healthy public policy do you see : What information stood out most to you from this case study that you might be able to apply in your local community?

Reviews

len1983061

5/15/2018 3:03:01 AM

Assignment Submission: Assignment Date Due: Friday Week 10, by 5:00 PM. Assignment Submission Guideline: Please submit your softcopy online using the respective Black Board assignment submission link. All diagrams must be computer generated using VISIO tools and balanced in conformance to the rules and standards specified in lectures and tutorials.

len1983061

5/15/2018 3:02:55 AM

Introduction (purpose of the report), Business Overview (Structure, Key activities, Problems, Gaps, Opportunities, functional decomposition), Analysis (Current processes, Requirement Determination, DFD (Context, Level 0 and Level 10, Logical Modelling (Decision Table Decision Tree …..), Data Modelling (ER Diagram), Class, Use Case, Activity and Sequence Diagrams) requirement specification (Functional, Non- Functional) Business proposed solution (forms, reports, user interface design) Project feasibility (cost, benefit, risk analysis) Implementation (options and Issues) Maintenance issues (maintenance request, requests for implementing changes) Conclusion (Recommend a key area for detailed analysis. Justify your suggestions).

Write a Review

Database Management System Questions & Answers

  Explain factors necessary to ensure referential integrity

Determine and explain the factors necessary to ensure referential integrity. Create an object-oriented model to show how the tables are interrelated.

  Perform logical design on the proposed database environment

Database Design and ERD- Creation Perform a logical design on the proposed database environment without going through the full normalization process.

  List the book code and title of each book

List the book code and title of each book that has the type MYS and a price of less than $20.

  Explain your experiences related to your setup of mysql

Explain your experiences related to your setup of MySQL. Include any difficulties or issues that you had encountered during the installation.

  Create a report where sales query is filtered for only az

Create a report where 'Sales Query' is filtered for only AZ. Make the report look nice. Save the report as a HTML file. Add the report to the PowerPoint presentation on slide 3.

  Produce an entity-relationship model for the scenario

Produce an Entity-Relationship Model for the scenario, Query your database, Optimize your Database,Secure your Database, and built Building a Web Interface

  What are the vulnerabilities associated with nosql database

CSIS 343- Our text discusses SQL injection attacks. Consider a NoSQL database, is it still vulnerable to an SQL injection attack? Why or why not? What are the vulnerabilities associated with a NoSQL database?

  Create the hr database using sql data files

Need to take the SQL files included to create the HR database (sql to create included). Then need to have a couple sub-views created.

  Describe the different procedure performed in dbms

Describe the different procedure performed in DBMS for student database in which fields are student id, student name, student class, marks.

  Explain the factors necessary to ensure referential integrit

Imagine that you have been hired as a consultant to assist in streamlining the data processing of an international based organization that sells high-end electronics. The organization has various departments such as payroll, human resources, finan..

  What is the key value of the 4th index

What is the key value of the 4th index record on the top level, assuming each index record points to the record with the highest key value in a block of the next level down?

  Develop a data dictionary and create an e-r diagram

Identify the entities and relationships that are relevant for a system to manage SEAMM. Develop a data dictionary (catalogue) and create an E-R diagram.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd