Practicum B
Either Practicum A or Practicum B must to be completed. Due date is published on Blackboard.
Question 1 (20 Points)
Build a UML Class Diagram that visualizes the ontology for the terms, attributes, constraints, etc. contained in this set of notes from an information collection session by a business analyst.
Information for Ontology
|
Use Cases (Competency Questions)
|
As you build the diagram, realize that not every noun in the description is a class; some of them are likely attributes (or slots in ontology terminology) and others may not be relevant at all. Use your judgement but be mindful of the use cases (competency questions) that your ontology must be able to support.
While you may use any tool for constructing the diagram, it is recommended that you use either LucidChart or Microsoft Visio. Include a JPG or PDF of your UML Class Diagram in your submission.
While you may use any tool for constructing the diagram, it is recommended that you use either LucidChart or Microsoft Visio. Include a JPG or PDF of your UML Class Diagram in your submission.
Question 2 (15 Points)
Write an XSL style sheet that transforms this Course XML document into a CSV with headers for four columns: cnum, pdu, cdu, price. Extract the data from the XML file with the following mapping:
- the number attribute of the <course> node is mapped to the column cnum
- the child node <pdu> under <course> is mapped to the column pdu; likewise for cdu and price
Include the CSV file as part of your submission, along with the file containing the XSL style sheet.
Question 3 (10 Points)
Inspect the SQL table creation statements in this script and build an Entity-Relationship (ER) diagram using the Crow's Feet notation. While you may use any tool for constructing the diagram, it is recommended that you use either LucidChart or Microsoft Visio. Include a JPG or PDF of your ER Diagram in your submission.
Question 4 (20 Points)
Download this SQL database creation script and use it to create a SQLite or MySQL database. Then create SQL queries that answer the following questions:
- List the course number, title, and name of the author of each Business Analysis course.
- List all courses authored by Greta Deblasio.
- How many courses are offered?
- Which courses are suitable for Business Analysts?
- Who can teach either AD200 or DA100?
Submit the SQL code for each query and a screen shot of its output.
Question 5 (10 Points)
Load the Course Data XML file into Freeformatter.com and then write XPath expressions to obtain the following data:
- List the course number and title of each course.
- List the course numbers of all Business Analysis courses.
Submit the XPath expression for each query and a screen shot of its output.
Question 6 (15 Points)
For the potential information system constructed or used in Question (1), describe a security architecture in at least 1000 words. Specifically describe how you would deal with information security, privacy, and confidentiality. Are there other concerns that would need to be addressed?
Question 7 (15 Points)
Using a tool of your choice (or drawn by hand), sketch a process flow for creating a custom course using the notes from Question (1). The diagram must contain swimlanes, documents, databases, and tasks. If you can anticipate branch points in the flow, add them as well.
Question 8 (5 Points)
Describe (in at least 750 words) an information collection method in detail by which you would conduct a time study of the process described in Question (7). Pay particular attention to techniques used, likely biases to keep in mind, and analysis approach and tools.
Question 9 (10 Points)
What is the expected execution time of the process modeled below? Provide a detailed answer and show calculations.
Scoring
Total Number of Earnable Bonus Points: 100 +20 bonus points
Approximate Time to Complete: 4-6 hours
Due Date: see Calendar or Blackboard
Approximate Time to Complete: 4-6 hours
Due Date: see Calendar or Blackboard