Hi let me know is it can be done and the price for this assignment
Homework #1 – ERD in Visio
Please work on the following issues:
[Part-I]
1. Please create the equivalent Visio drawing as illustrated in Determine A2.25 in Appendix A2: Visio Tutorial.
2. Add your identify, class – homework#, and date to the textual content field at the high of the Visio file, e.g.:
– Identify: Jane Dow
– Class: IS-613 – HW1 – Visio Tutorial
– Date: 2/10/2022
three. Save your Visio information file as -YourLastName_Enrolls.vsdx-
[Part-II]
The Jonesburgh County Basketball Convention (JCBC) is an novice basketball affiliation.
Every metropolis in the county has one workforce as its consultant.
Every workforce has a most of 12 gamers and a minimal of 9 gamers.
Every workforce additionally has as much as three coaches (offensive, defensive, and bodily coaching coaches).
Throughout the season, every workforce performs two video games (house and customer) in opposition to every of the different groups.
For every recreation performed, please maintain observe of:
– Statistics for every workforce: factors scored, complete variety of fouls, variety of timeouts used;
– Statistics for particular person gamers, together with factors scored, variety of fouls dedicated, variety of free throws taken, and variety of free throws made.
Given these circumstances, do the following:
a. Determine the connectivity of every relationship.
b. Determine the kind of dependency that exists between CITY and TEAM.
c. Determine the cardinality between groups and gamers and between groups and metropolis.
d. Determine the dependency between coach and workforce and between workforce and participant.
e. Draw the Crow’s Foot ERDs to characterize the JCBC database.
Submission Guideline
In your laptop, create
• YourLastName_Enrolls.vsdx: your Visio drawing for Appendix A2 – Determine A2.25
• YourLastName_JCBC.vsdx: your Visio drawing for the JCBC case research
-Each drawings ought to include a text-box exhibiting (1) class (2) homework# (three) your identify (four) Date
-Submit the above information utilizing the [HW1] hyperlink

Published by
Medical
View all posts