COMP2147 Systems Analysis, Design and Testing Assignment

Assignment Help PL-SQL Programming
Reference no: EM132404485

Comp2147 - Systems Analysis, Design and Testing - George Brown College

Project: ABC clinic

Your company has been awarded the contract to create a "Clinical Management System"software using Object Oriented /Unified Process methodology for the ABC family medicine and walk in clinic.

My Name is John Doe and I am the clinic manager and your main contact for the client. We met during your lecture class on September 5, 2019 and you guys interviewed me about the requirements for the software system. Here is a brief summary of the requirements discussed during the interview.

Please note that I am relying on my memory and to write up all the items discussed during the interview so these requirements are not complete/comprehensive by any means. You should further clarify these by scheduling an interview with one of the stakeholder/potential usersuch as the manager, doctor, nurse, patient, and receptionist.

(**Your instructor will play these roles during the lab/lecturesessions and you may ask him to assume the role of the manager, doctor, nurse, patient, receptionist etc. to further clarify your requirements)

Project Deliverables

1. Create a system service request for creating a Clinical Management System for ABC clinic as requested by its Manager John Doe (use template from chapter 3-slide 8)

2. Develop a professional scale project charter (1-2 pages) as stipulated by PMBOK®. Please research find some suitable template for project charter.

3. Develop a Feasibility Analysisdocument (4-5 page long) to justify the project from financial, organizational, and technical view point (use various templates from chapter 4).

4. Create a Base Project Plan by entering a Work Breakdown Structure in MS Project®
a. Use the Inception, Elaboration, Construction and Transition phases of OOSAD-based development approach as summary tasks for your project.

b. Please only add the WBS (tabular part) in your project submission showing tasks, durations, dependencies, and resource assignment columns. DO NOT add the Gantt chart or Network Diagrams.


5. Perform textual analysis of thebusiness processes of ABC clinic as described above in this document in order to identify the candidate actors and use cases and create a use case diagram (first cut).


6. Pick any TEN (10) use cases from your project and create Written Use Cases at the Kite Level (bird-eye view, use the template in chapter7 of the text book (fig 7-32, 7-34 on page 226/228).

7. Create Three (3)Activity Diagrams for any three business processes belonging to your project, use the template in chapter7 of the text book (fig 7-37, 7-38, and 7-39 on page 233/234).

8. Modify the first cut use case diagram created in the above step based on the additional details derived from the written use cases activity diagrams and create a refined and detailed use case diagram by incorporating <<include>>, <<extend>>, and <<generalizations>>relationships.

9. Create a context level data flow diagram (DFD) to capture the scope of your project, use the example in chapter7 of the text book (fig 7-4 on page 187)

10. Decompose the context level data flow diagram to create the Level-0DFD (text book names it as Level-0 but the Visual Paradigm tutorials name it as Level-1).

11. Create a decision table to capture the process logic for your system (use the reduced version on page 204, fig 7-19). The table should contain at least 2 conditions and 4 courses of action.

12. Pick any THREE Use cases and create System Sequence Diagrams (SSD) for them (One SSD for each use case).

13. Create a conceptual Data Model (ER) model (incorporate entity generalization hierarchies, if any, and business rules for overlap and disjoint)-[use MS Visio]

14. Create a class diagram that would display class names, attributes, associations and relationships (generalization, composition, and aggregation)

15. Create an ER Model for fully normalized relations (Logical Data Model), use example 9-16 on page 331.

16. Create wireframes for at least Five (5) important forms and reports for your project, use example in fig 10-3 on page 358

17. Create a Dialogue diagram for any one actor/scenario, use example in fig 11-19 on page 406.

18. Create a testing strategy for your system which should include the test types and testing process you would specify [One page document] (use information provided in chapter 13, page 457-464)

Reference no: EM132404485

Questions Cloud

What are the most important ratios : What are the most important ratios that need to be managed well at Walmart Think about Financial, Customer, Internal and External.
Improve organizational communication and productivity : Discuss how your organization utilizes Web Analytics to help improve organizational communication and productivity.
What should be ytm in market when investor bought bond : After three years YTM is 9% in market. Investor decided to sell bond after holding it for three years.
Recognize security policy violation occurred : How do you recognize a security policy violation occurred in an organization? Explain three security policy violations that had occurred previously in the organ
COMP2147 Systems Analysis, Design and Testing Assignment : Comp2147 Systems Analysis, Design and Testing Assignment Help and Solution, George Brown College - Assessment Writing Service - Create a system service request
Write sql queries for the books database : Write SQL queries for the books database (discussed in Section 18.3) that perform each of the following tasks
Conduct comprehensive literature search : For this task, you will use your weekly reading as background information and then conduct a comprehensive literature search.
Contribution to the practices of information technology : How can obtaining a doctorate impact your contribution to the practices of information technology? Where do you see yourself after obtaining a doctorate from UC
Discuss the best practices for incident response in cloud : Discuss the best practices for incident response in the cloud.

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

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