Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Logical ER Model - In this sprint, you will be completing one of the bottom layers of the project - one incremental value towards the
Logical ER Model In this sprint, you will be completing one of the bottom layers of the project one incremental value towards the final project.
In this deliverable, you will submit to me a PDF with the following information:
o Logical Entity Relationship model in this model, you should identify a minimum of strong entities and their names, all relationships : or :M :M M:N no need to yet break down the M:N and show the associative entity Please show all attributes you plan on having in each entity, a minimum of attributes in each entity, and at minimum identifier for each entity.
o You should have one entity that will break down to two categories. For instance, if you had an entity called STUDENTS this may break down to INTERNATIONAL and DOMESTIC. You need to have this identified as you will be modifying your logical ERD in Sprint deliverable.
o Explanations of every single relationship with an example of data.
o For instance, if you have an entity called students, and an entity called courses, and a student takes many courses and a course can be taken by many students, thus, you should have an associative entity that you might want to call enrollment, this is the explanation that I am looking for as part of this submission.
o Example of data: if for instance you had an entity called courses, and the attributes were courseid course name, coursecredits, courseprogramknowing this might be a multivalued field, must be broken up and resolved in Sprint deliverable the example of data I would like to see is the following: OPIM Data Management and Business Process Modeling, MSBAPMMBAFINTECH
o possible reports that you will derive from your database. Pertaining to our previous example with courses and students, one possible report would be the total sum of students per course; or total number of students who are taking two specific courses. Outline possible reports.
o You can design the ERD in draw.io or lucid charts, or Visio. Please make all connections connectivity and cardinalities as large as you can, please have fonts of if possible, and clear screen shots of your diagrams. The submission should be in PDF
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started