Entity Relationship Diagram and File Design

Instructions
Assignment Directions:
Purpose
The purpose of this assignment is to create an Entity Relationship Diagram (ERD) to use as a model for the database design of the Case Study. You will place it in the SRS and SDD specifications and submit both documents.

Directions

  1. SRS. Copy and rename your last submitted and corrected SRS from Assignment 3 like Week6DraftSrsERDLastnameFirstname using your name.
  2. SDD. Copy and rename your last submitted and corrected SDD from Assignment 5 like Week6DraftSDDERDLastnameFirstname using your name.
  3. SRS. Complete Appendix D in your SRS.
    2.1 SRS. Create an ERD (Entity Relationship Diagram) for the Case Study using diagrams.net [website] Your ERD should include entities and their attributes including the designation of primary keys and foreign keys. The ERD diagram includes relationships (like association, inheritance, aggregation, composition, etc.) to other entities. Make certain that you include the names on the association relationships with the multiplicity constraints. See the Tune Source ERD in Figure 6-14 on p. 239 in your textbook. Place your ERD in Section D.1.

2.2 SRS. Complete Section D.2Entity Definitions. Use the template “A NameOfClass is a ….” and complete the sentence. For example, “A Patient is a person who is registered with FCS and receives services”. In this example Patient is the name of class. The relationship is the phrase “is a”.
2.3 SRS. Complete the discussion of your entity relationship diagram in section D.3.
2.4 SRS. Make any corrections to your previous SRS and list them in Section D.4.

  1. SDD. Place a copy of your ERD in Section 5.1 in your SDD and include a description of the design.
    4.1 SDD. In Section 5.2 of your SDD, describe any need for non-DBMS files.
    4.2 SDD. in Section 5.3 list any corrections to the previous SDD.
    Submission Instructions:
    Submit both your SRS and SDD below.
    Be sure to review the following prior to submitting your assignment:
    • Academic Integrity Guidelines [content page]
    • Assignment Rubric
    o If you do not see the rubric, in the blue horizontal navigation bar select Course Tools, then Assignments. Select the appropriate assignment, and the rubric will be located near the bottom of the page.
    This assignment aligns with the following:
    • Course Objective 2, 3 [content page]
    o Lesson Objective 2.5, 3.5 [content page]
    Resources & Supports
    • Office 365 [webpage]: You have free access as an APUS student. Sign in with your MyCampus Email credentials.
    • Submitting and Confirming a Submission : Watch this 3-minute video if you need guidance on submitting your assignment.

Do you need urgent help with this or a similar assignment? We got you. Simply place your order and leave the rest to our experts.

Order Now

Quality Guaranteed!

Written From Scratch.

We Keep Time!

Scroll to Top