ITEC150 Systems Design and Data Management Assignment

Assignment Help Database Management System
Reference no: EM133148566

ITEC150 Systems Design and Data Management - Sydney Institute of Business and Technology

Case Study - Good Health Clinic

ACTIVITY 1
1. Use the background information to create a short summary (one short paragraph) about the Good Health Clinic.
2. Create an organisation chart for the Good Health Clinic.
3. Use the information above to describe the area of the organisation under study (i.e. the business' functions that will be handled by the new information system).
4. Add the background information, organisation chart, and business functions to your Report document in Part A: Initial Investigation.

Case Study - ISSUES

ACTIVITY 2
1. Either by yourself or with another class member, brainstorm all the functions that the Good Health Clinic might require. Keep it at a very high level.
2. Prepare a draft System Vision Document for the new information system for the Clinic. This system vision document will be revised when you find out more about the requirements for the system. An example system vision document can be seen in Matt to provide a sample.
3. Add your system vision document to your report document in Part A: Initial Investigation.

CASE STUDY - FACT FINDING AND SYSTEM REQUIREMENTS

ACTIVITY 3
1. Create a table, listing all tasks separately, with their duration;
2. Identify all dependencies, and indicate what predecessor tasks are required;
3. Construct a Gantt chart in Microsoft Project or other project management software;
4. Identify the PERT/CPM chart in the software, and identify the critical path;
5. Determine the overall duration of the project;
6. Take clear screenshots of the Gantt chart and PERT/CPM chart and paste into your Report document in Part A: Initial Investigation under Project Management.
7. Include the overall duration and critical path in your report.

CASE STUDY 4

ACTIVITY 4
1. What are the risks associated with this project? Create a list of up to 10 risks and their likelihood of happening (see Study Guide topic 4, activity 4.6 for an example of how this should be set out).
2. Define the anticipated benefits of the new system. This should include both tangible and intangible benefits. Wherever possible, translate the intangible benefits into anticipated tangible benefits.
3. Define the expected costs of the new system. Look at the examples given in workshop activities for some examples of expense categories. It is ok to give estimates at this point.
4. Use two or more cost-benefit analysis techniques to decide whether to proceed with the project.
5. Identify any assumptions and interpretations that you are making with respect to the information that you have been given, that you are estimating, and that you are projecting (into the future).
6. Create a new section in Part A of your report: Risk and Cost Benefit Analysis. Insert your work from above, and give a clear indication as to whether it is feasible to continue with the project.
7. Does the proposed system present a strong business case? Why or why not? Include a recommendation as to whether the system should proceed, as the final part of your preliminary report. The Preliminary Investigation part of your Report can now be submitted.

CASE STUDY

ACTIVITY 5
1. What fact-finding techniques, apart from interviews, would you recommend to find out the requirements for the new system?
2. Identify at least two staff members with different primary job roles of interest to this project.
3. Develop a list of questions for an interview with each staff member. Identify the time anticipated for the interview. Review your topic on creating interview questions, and make sure you include suitable question types.
4. Include the interview plans in the Appendices for your Report.
5. Include the recommendations for other fact-finding techniques, in your Report.

CASE STUDY PART 6
ACTIVITY 6

1. Write down a list of the main functions needed to be handled by the new system.
2. What are the roles that will be interacting with the system?
3. Using all the information that you know about the Clinic's business operations so far, create a use-case diagram for the new system.
4. Select four use-cases and write a brief use-case description for them.
5. Pick one of these use-cases and write a full use-case description for it. Use an activity diagram in the full description.
6. Include the following in your report:
• the use-case diagram;
• the brief use-case descriptions;
• the full use-case description, including your activity diagram.

CASE STUDY 7

ACTIVITY 7
1. Review the Good Health Clinic's fact-finding summary and all other information you have about the required system. Be willing to critically analyse this for duplications and inconsistencies.
2. Draw an ERD with crows-foot cardinality notation. Assume that system entities include patients, practitioners (doctors, therapist and nurses), procedures, costs, appointments, dates, times etc....
3. Design tables - making sure each table only refers to one "thing". As you create the database design, identify primary and foreign keys by underlining primary keys, and making foreign keys italic.
4. If you add primary keys which use codes - for example a code for the procedureID, then identify the format of these codes.
5. Create suitable sample data to populate the fields for at least three records in each table.
6. Include the following in your report:
• The ERD you have completed;
• The database design (schemas);
• Formats of codes used;
• Sample data for each table.

CASE STUDY 8

ACTIVITY 8
1. Create a system sequence diagram for one of the use cases identified in Activity 6.
2. Add this system sequence diagram to your report in the appropriate area.
3. Search online for any potential commercial software packages that could be suitable. Identify two packages, and compare their features and their suitability to be used as the new system.
4. Present at least three options for the new system in your report. One of these must be in-house development, and two of the others may be the commercial packages in (3) above.
5. Review your feasibility analysis for the new system. Taking all options into consideration, make a recommendation for the new system, in your "Conclusion and Recommendations" section.

Attachment:- Case Studies for your Project.rar

Reference no: EM133148566

Questions Cloud

How much will you have in this account : You placed $1,697 in savings account today that earns an annual interest rate of 16.86 percent, compounded semi-annually. How much will you have in this account
What is the balance of the cash account : Sold merchandise on account for $25,000. The inventory sold had cost $14,000. What is the balance of the cash account at the end of 2020
Develop answers to basic interview questions : Instructions: It is wise to be prepared for an upcoming interview. One way is to write down answers to basic interview questions. Develop answers to these basic
Describe two different benefit delivery models : Describe two different benefit delivery models and outline the key components of each.
ITEC150 Systems Design and Data Management Assignment : ITEC150 Systems Design and Data Management Assignment Help and Solution, Sydney Institute of Business and Technology - Assessment Writing Service
Media of climate change : "The Media of Climate Change" Personally I believe Climate Change is a perpetual happening. Nature has shown us this throughout the years and scientists can eas
Identify five countries in the world including canada : 1) Identify five countries in the world including Canada and check if they are going up on down on the international corruption scale.
What is the VIX and why is it important : Explain the differences between holding period return, an average rate of return and the true annual rate of return. What is the VIX and why is it important
Explain the tourism and travel industry : Consider this statement. this is based around the tourism and travel industry

Reviews

Write a Review

Database Management System Questions & Answers

  What is the lowest number of channel by country

What is the lowest number of channel by country - What are the least 3 viewed categories in terms of number of uploaded videos

  Include any number of childrens names in addressbook

Explain how the problem of including any number of children's names in AddressBook can be solved by defining an additional relation that has only single-valued entries.

  The strayer oracle server may be used to test and compile

the strayer oracle server may be used to test and compile the sql queries developed for this assignment. your

  Prepare a use case diagram for the case study

Case Study based on an Interview contained in a separate document (Please see the details in page 221 of your text book). Carefully read this case study. You are required to answer the following questions based on the Case Study.

  Create a database and import text files into tables

Mr Sev N O'Nine, your manager, has set up the following tasks for you to complete for this phase of the project: Create a Database and import the four (4) Text files into four (4) Tables, Modify Table Design and Set Primary Keys

  What is difference between machine learning and data mining

Describe what the Machine Learning is, and what is the difference between Machine Learning and Data mining.

  What is the minimal adequate model and why do we build it

What is the minimal adequate model? Why do we build it? Provide a one-paragraph, masters-level response.

  Draw a conceptual data model for your database

Draw a conceptual data model (entity-relationship model diagram) for your database. There should be at least four entities with their relations. Clearly describe and explain all the symbols you use for your ER model diagram.

  Identify all the relationships

Identify all the entities and Identify all the relationships - Draw the ERD Diagram - Apportion cardinality ratios appropriately in the ERD Diagram

  Draw decision tree to represent the big state university

A student who completes either one of these prerequisites and obtains the instructor's permission, however, will be allowed to take MIS 260.

  Compare the pros and cons of consolidating data

Compare the pros and cons of consolidating data on a SAN central data facility versus the dispersed arrangement it replaces. Evaluate the issues raised from the Carlson SAN mixing equipment from a number of vendors and determine the management option..

  How low coupling and high cohesion enables modular design

Briefly explain how low coupling and high cohesion enables modular design. What is the main difference between a framework and a toolkit?

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