Hi this is an ER modelling question. Please if anyone can solve this it would be helpful

to not be considered late if not submitted in Blackboard Question 1. (90 points total) Draw an ER diagram using crow's footnotation to represent the proposed database described below. When and if a relationship needs to be modeled as an associative entity, show is correctly on the diagram Show all minimum and maximum cardinalities . Do not show attributes for my of the cities, except where (1) attributes should be designated as a primary key of foreign key, (2) attributes need to be specified in order to properly relate supertype entities to their subtype entities. Several attributes are provided as examples in the story so that you can better understand what is being stored and the structures they require. Again these should not be shown on your diagram, unless you determine that they are part of key fields or discriminator attributes. Be sure to clearly mark whether an attribute is a PK or FK, and if it isa composite key, clearly munk all components as such. Also be sure to clearly mark any discriminator attributes and give them an intuitive name . Do not include any structures in your diagram that would be needed to resolve multi-valued attributes Identifying vs non-identifying relationships do not have to be distinguished for this diagram.c, this will not be a grainspo However, do make sure that all entity relationships have appropriate primary and foreign keys associated with them Clearly lost any non-obvious assumptions you made ifanye needed). If your diagram does not match what I expected to see and you did not spell out any assumption that you made. I can give credit. In no case should your assumptions violate anything that is already explicitly spelled out in the story Background: This hypothetical database project is being initiated by the Executive Council of the Association for Information Systems (AIS: httpincodca). Als is the premier international organization for academies who do indormation systems feat. AIS ponsors several premier conferences cach you, and also sponsors several top ranked research journals. It also sponsors student organizations within universities, matches job seekers with open positions, and maintains an e-library of affiliated research publications Problem Statement and Business Value The database will support member account services as well as conference registrations (Feel free these she AIS membership page if you wish, hurrealise that I have made modifications to their actual operations for the purpose of keeping this assigmentas simple as possible. The business value of the database comes from the ability to improve conference planning, send utomated tenewal prompts, plan campaigns to increase membership in particulares or demographic groups and ensure that member records are kept 1o-date to maximize income (for example, once a PhD student graduates, they should be converted to a much more expensive academic membership). The database will also be able to support member-to- member networking with other individuals holding allied interests Database Description There are three types of AIS members that we are particularly interested in: Academie, Student and Professional. It is not possible to be considered a member of more than one of these categories time. However, there may be other types of members besides there three (note: if you go to the AIS white and pretend to sige for acow will see exactly how many membershipper hari reale, Attributes that are tracked regardless of the membership type include first and la selected user name and aatumaaralia, 1- eads a tai That why plicitly spell out the Barrand: : | This hypochutica de probeing in the lms in the intere AS. AS - potice, and many dach fratham stantiaeat and aler The taste imple the best of the date.com to this maprake paaaapam Tamilar paneer More , , shmi miralgi The dratest matering serial Dutabase Describe Ther three tyraNAE-air int is Hailers, Sukathaliar u atanal time llama, there is like ale hailasa tree ta - wwwwwwwwwww Aaluastrachod inspiteralearlier tists: tri -- als, pme , . Lindia pai very lwy list of cheese amesteck bering to the ABS Forcar, Allah dan Als fully dry. For power the de teaching and fully directory in field wreck l dialogam alathra Chas a tera As earler, yalatially your medias a A dumatice of their academic care o assed y AIS A Maria . , is date arting them are all pure comples am the AIS wcharts AS laaSE" Spostal Lutaar tas he has has Aarilie materish kalya terat. The care of the sic, le SAD als mathile Malarati - SIC Tk dmibuse it is incot n st antennia As regler for a conference at all. Apalme AS 2021, 101S 2001, ICIR INT) y have any le, the MCI AMLE aanal is the datae iam are whake the coalarese AIM Ias tara arya aalum mariammalar l, hurthariyyramia coatians here thats = AS the past hair is piliath l Extra Credit Opportunities preces The ch