Typically, a hospital patient receives medication that have been ordered by a particular doctor. Because the patient often receives several medication per day, there is a 1:M relationship between PATIENT and ORDER. Similarly, each order can include several medications , creating a 1:M relationship between ORDER and MEDICATION.a. Identify the business rules for PATIENT, ORDER and MEDICATIONb. Create a Crow's Foot ERD that depicts a relational database model to capture these business rules.

Create an ER database model to include the following business rules for the Products company: Each sales representative writes many invoices. Each invoice is written by one sales representative. Each sales representative is assigned to one department. Each department has many sales representatives. Each customer can generate many invoices. Each invoice is generated by one customer.

Create ER duagram of the foloowing information and also find entity identification, Rekationship identification, Cardianlity identification, Identify attributes.

Swing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information.   Remember the ERD will eventually turn into the design for a database from a top down view.  Make sure you resolve any many to many conflicts.  Label an identifier or primary key and all pertinent attributes given.   If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity.  Therefore, all entities should end up with at least an identifier and another attribute that makes sense.  You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common.  Make sure you show entities, relationships, cardinality, and optionality.  Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons.  Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…