1.Wynwood District
Provide all appropriate connectivities using the following business rules:
An art collector can purchase many artworks but a purchase order is placed by one art collector only.
An artist owns at least one artwork but a given artwork is owned by one artist only.
An artwork is classified into one art style only. Each art style must have at least one artwork.
An art collector may review/rate more than one artist.
2. Book Club
Provide all appropriate connectivities using the following business rules:
A book is printed by one publisher only and a publisher prints many books.
A reader follows at least one author and an author may be followed by many readers.
A reader may be part of many reading groups and a reading group has at least one reader.
An author wrote at least one book and a book may have been written by many authors.
3. Tech Support
Using Crow’s Foot Model, provide all appropriate cardinalities using the following business rules:
Each ticket is assigned to at least one topic area but no more than three topics per ticket. A topic can include many tickets.
Each staff is part of one of the five IT Teams (Helpdesk, Server, Network, Desktop, Email) and a team may have many staff members.
Each user will have the ability to submit as many tickets as needed, and each ticket must be tied to a single user.
4. Traffic Ticket
Using Chen Model with the (min, max) notation, provide all appropriate cardinality using the following business rules:
A law enforcement officer issues many fine tickets and a motorist may have received many fine tickets.
A vehicle is owned by one and only driver. A driver owns at least one vehicle.
5. Heath Clinics
Using Crow’s Foot Model, provide all appropriate connectivities using the following business rules:
A physician can prescribe one or more medications to several patients and a patient can obtain many prescriptions from several physicians.
A physician works at one and only one clinic location and a clinic has at least one physician worker.
6. Lead Management
Using Crow’s Foot Model, provide the appropriate connectivity using the following business rules:
A real estate agent may manage more than one property at a time but a property is managed by one manager only.
A property is owned by a single homeowner but a homeowner may have multiple properties.
A property may be purchased by one single buyer but a buyer can purchase many properties.
