Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create business rules for each of the exercises (below is an example of the format needed) A writer may create many novels. A novel is
Create business rules for each of the exercises (below is an example of the format needed)
A writer may create many novels. A novel is created by a writer A consumer may buy many novels. A novel may be bought by may consumers. Exercise A United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small database used to track artists, paintings, and galleries. A particular painting can be duplicated and exhibited in multiple galleries, provided the galleries have the space. UBA accepts work from artists, many of whom provide multiple paintings to be presented at available galleries. Exercise B An insurance company sells home, auto, and life insurance. The company has three departments one for each type of insurance - and every department has its own group of agents. A customer is assigned an agent based on the type of insurance he or she desires. The agent then creates a policy for the customer. Exercise A publisher wants a database to store the books it publishes along with their authors. An author can write many books, and a book can have more than one author. When the publisher and author(s) agree to produce a book, a contract is created for the book, one for each author. The contract specifies the percentage of the profit the author will receive back. Exercise D A supermarket has many departments, each of which has employees. A few of the employees in each department manage it. An employee can only work in one department at any given time. A department has many products, some of which can be offered in more than one department at the same time. For instance, batteries are offered in the electronics, toys, photo, groceries, and hardware departments Exercise E A rapidly growing health care organization has a number of clinics across the state that offer outpatient services. Each doctor is assigned a specific clinic. A patient can schedule an appointment at a specific clinic or with a specific doctor. If the patient has no specific doctor in mind, one is assigned based on availability. As an outcome of the appointment, the doctor may choose to prescribe one or more medications for the patient. A given prescription is written for a specific medication and indicates the strength, daily dosage, and instructions for the patientStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started