CSA 05: Module 9-10

https://tarleton.instructure.com/courses/52128/assignments/844683?module_item_id=2429780 1/4
CSA 05: Module 9-10
Due Nov 14 by 11:59pm Points 100 Submitting a file upload
File Types doc and docx Available Oct 31 at 12am – Nov 14 at 11:59pm
This assignment was locked Nov 14 at 11:59pm.
This Case Study Assignment (CSA) covers the material in Module 9 (Chapter 9 –
Data Design) and Module 10 (Chapter 10 – System Architecture). The purpose of
this CSA is to:
Create a logical Entity Relationship Diagram (ERD)
Create a physical Entity Relationship Diagram (ERD)
Populate database tables with “dummy” data
Research Enterprise Resource Planning (ERP) for service center software and
make a recommendation for AW [Writing Intensive (WI) Component].
Discuss issues related to Scalability.
Discuss issues related to Online versus Batch Processing.
Discuss issues related to Networking topology.
Discuss issues related to Security requirements.
1. Carefully read the narrative provided and complete the deliverables required in the
attached document entitled 3389_CaseStudyAssignment_05, adhering to the Case
Study Assignment Guidelines
(https://tarleton.instructure.com/courses/52128/pages/case-study-assignment-guidelines)
provided.
2. Include the following identification information on the Title Page of the case study
assignment report:
Name
9-Digit ID
Case Study Assignment Number (i.e., Case Study Assignment #5)
Due Date
Date Submitted
3. Name your case study assignment report (i.e., single word processing document
containing all contents) using the following naming convention:
CourseNumber_LastNameFirstInitial_CSAXX (e.g., 3389_FloresJ_CSA05)
15/11/2023, 15:08 CSA 05: Module 9-10
https://tarleton.instructure.com/courses/52128/assignments/844683?module_item_id=2429780 2/4
3389 CSA05 Rubric
4. Submit under the CSA 05: Module 9-10 link in the Case Study Information and
Assignments Module (https://tarleton.instructure.com/courses/52128/modules/371375) .
Attachments
(https://tarleton.instructure.com/courses/52128/files/8004109?wrap=1)
3389_CaseStudyAssignment_05
(https://tarleton.instructure.com/courses/52128/files/8004168?wrap=1)
(https://tarleton.instructure.com/courses/52128/files/8004167?wrap=1) Service Records
Sample (https://tarleton.instructure.com/courses/52128/files/8004190?wrap=1)
(https://tarleton.instructure.com/courses/52128/files/8004124?wrap=1)
15/11/2023, 15:08 CSA 05: Module 9-10
https://tarleton.instructure.com/courses/52128/assignments/844683?module_item_id=2429780 3/4
Criteria Ratings Pts
2.5 pts
2.5 pts
2.5 pts
5 pts
10 pts
5 pts
50 pts
5 pts
5 pts
5 pts
Title Page
Identifies the name, 9-Digit ID, case study assignment number, due date, and
date submitted.
2.5 pts
Full
Marks
0 pts
No
Marks
Table of Contents
A nice enhancement is to make hyperlinks to page numbers, diagrams, etc.
2.5 pts
Full
Marks
0 pts
No
Marks
Executive Summary
One-half page or so, providing a synopsis of the purpose and contents of the
report (see “How to Write an Executive Summary” in the Introduction Resources
folder).
2.5 pts
Full
Marks
0 pts
No
Marks
Logical ERD
Create a logical Entity Relationship Diagram (ERD) based upon the Data Flow
Diagram (DFD), Use Case Diagram, and Class Diagram created previously.
5 pts
Full
Marks
0 pts
No
Marks
Physical ERD
Create a physical Entity Relationship Diagram (ERD) based upon the logical
ERD in 3NF (3rd normal form.
10 pts
Full
Marks
0 pts
No
Marks
Populate Tables
Create a word processing table representing each of the database tables and
place at lest 3 records of “dummy” (sample) data in each of the tables.
5 pts
Full
Marks
0 pts
No
Marks
ERP System Recommendation
[Writing Intensive (WI) Component]: Research ERP systems on the market and
make a recommendation for which system AW should consider.
50 pts
Full
Marks
0 pts
No
Marks
Scalability
Discuss issues related to Scalability as identified in the narrative.
5 pts
Full
Marks
0 pts
No
Marks
Online versus Batch Processing
Discuss issues related to Online versus Batch Processing and provide your
justification for one over the other.
5 pts
Full
Marks
0 pts
No
Marks
Networking topology 5 pts 0 pts
15/11/2023, 15:08 CSA 05: Module 9-10
https://tarleton.instructure.com/courses/52128/assignments/844683?module_item_id=2429780 4/4
Total Points: 100
Criteria Ratings Pts
5 pts
2.5 pts
0 pts
Discuss issues related to Networking and make a recommendation for the most
appropriate topology.
Full
Marks
No
Marks
Security Requirements
Discuss issues related to Security requirements for the system, classes of
users, access, and protection as described in the narrative.
5 pts
Full
Marks
0 pts
No
Marks
Conclusion
Summary of report and any pertinent conclusions, recommendations, etc.
2.5 pts
Full
Marks
0 pts
No
Marks
Late Penalty
11 point per day late penalty
0 pts
Full
Marks
0 pts
No
Marks