• Use Draw.IO
• Make sure you use proper ERD notation for attributes, entity types and relationships
• Show all cardinalities, primary keys and foreign keys
• Resolve all multi-valued attributes & M:N relationships properly
• Use verbs for all non-associative relationship

1. A bank provides credit cards to its clients. Each credit card has a unique number. The credit card also has a PIN Number, Type (Master Card, Visa, etc.) Expiration date, Credit Limit, and up to five User Names (these are names of family members that can use the card). Each Credit Card is assigned to a Primary Card Holder. The Primary Card Holder has a unique Client Id. They also have a Name (First, Last, MI), Phone Number, Zip Code. Not all clients of the bank get a credit card and some clients get more than one card (possibly a Master Card and a Visa). Each credit card, once issued, must be assigned to at least one client and not more than one client.

2. Students have a unique ID. They also have a Name and have one or more PO Boxes. A Major has a unique Code and Hours Required. All Students must declare a Major and they cannot declare more than one major. Some Majors have more than one Student declared and some Majors do not have any Students declared. We must know the Date a Student declares a Major.

3. Committees are composed of Faculty. Each committee has a unique Committee Code. Committees also have a Name and a Charter. Faculty has a unique ID and a Name. Faculty can serve on more than one committee but must serve on at least one. Committees must have one or more Faculty on them. Each committee is chaired by one faculty member, who can manage several committees. All Faculties must have a partner which is another Faculty member. Committees generate Reports. Each report has a Name, Date and a Narrative. Each committee can generate multiple reports and a report must come from one single committee. Reports can only be generated by Committees.

4. A company (telemarketer) hires Solicitors to help get contributions. Each solicitor has a unique ID, Name, and a Phone Number. Solicitors get contributions from Contributors for a particular Charity. Each charity has a unique Charity Name, Mailing Address and Phone Number. Contributors have a Contributor Id, Name, and Address (Street, City, Sate, Zip). Contributions are assigned a Contribution Id and have an Amount and Date. Each contribution is for a single charity. A contributor may make many contributions to the same charity or they make them to different charities. Each contribution is from a single contributor who is involved with one solicitor. Draw the ER diagram for this scenario.