Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribed

image text in transcribed

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 patient

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Murach's SQL Server 2012 For Developers

Authors: Bryan Syverson, Joel Murach, Mike Murach

1st Edition

1890774693, 9781890774691