Question

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 C

 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.

Answer 1

Business rules for Exercise A :

• The UBA(United Broke Artist) is a broker for not so famous artists.
• The UBA might be a broker for famous artists.
• The UBA maintains database for tracking artists, paintings and galleries.
• Duplication can be done of a particular painting.
• The painting is exhibited in multiple galleries depending upon availability of space.
• Multiple galleries may contain multiple paintings depending upon availability of space.
• An artist may draw multiple paintings.
• A painting is drawn by an artist.
• The UBA accepts the work from many artists.
• An artist may submit his works to UBA.

Business rules for Exercise B :

• Home, auto and life insurance are sold by an Insurance company.
• Many Insurance companies might sell auto, home and life insurance.
• The insurance company consists three departments.
• The insurance company may consists many departments.
• Each type of insurance has one particular department.
• Every department has it's own group of agents.
• A customer is assigned an agent depending on the type of insurance he/she desires.
• The agent may have many customers.
• The agent creates policy for a customer.
• The customer can have many policies and agents.

Business rules for Exercise C :

• A publisher wants a database.
• Many databases can be created by publishers.
• The database may store many books published and respective authors.
• A book and an author might be stored in a database.
• The publisher and author produce a book.
• The publishers and authors may produce many books.
• A contract is created for a book.
• A contract belongs to an author.
• An author may sign multiple contracts.
• The contract specifies the profit percentage the author will earn.

Business rules for Exercise D :

• A supermarket has many departments.
• A department has many employees.
• Many employees may work in many departments.
• Each department is managed by few employees.
• Few employees may manage many departments.
• At a given point of time an employee can work in one department.
• A department has many products.
• A product may be offered in many departments.

Business rules for Exercise E :

• A health care organisation has many clinics.
• A clinic may have many health care organizations.
• Many clinics across the states offer outpatient services.
• Appointment at specific clinic or with a specific doctor can be made by a patient.
• A patient may make appointment with many clinics and with many doctors.
• Based on the doctor's availability appointment is made if patient doesn't know a particular doctor.
• The doctor may choose to prescribe one or more medications for the patient.
• The prescription contains strength, daily dosage and instruction for the patient.
• A patient may have multiple prescriptions.