System Design
MIS 201 Introduction to MIS
UML Class Diagram Exercise #3b
Spring 2010
21 March 2010
Flying Fish.com
Flying Fish is organizing its corporate information before it creates an extension of their existing business on the Web. Their new business, Flying Fish.com, will provide fish owners with advice on fish health, behavior and nutrition, and sell such products as aquariums, filters, heaters, decorations, and water treatment aids. The web site will also have capabilities for fish owners to exchange electronic messages about their fish and fish care with other owners.
You have been asked to construct a database for Flying Fish.com, organizing their information on customers, fish care products, and fish care books. The following business rules govern the database you are to construct:
Customers can purchase either books or fish care products; a customer may purchase many books or many fish care products, or may purchase none of each. A given book can be purchased by one and only one customer and a given fish care product can be purchased by one and only one customer.
Books are tracked by ISBN number and serial number, as well as by title, author, book type (type of fish), price, date received, date sold, and purchase status (sold or not sold). Flying Fish.com carries only fish care books.
Fish care products are tracked by item number and serial number, as well as by manufacturer, product name, fish type (tropical, domestic), invoice price, purchase price, date sold, and purchase status (sold or not sold). Flying Fish.com only carries fish care products.
Customers are tracked by a customer identification number, last name, first name, and fish type (tropical, domestic, or both).
The company would like to generate reports that show their customers and the products or books they have purchased over the past year.
Assignment:
Create a UML diagram for Flying Fish.com, including the classes, attributes, relationships, primary keys,
UML Class Diagram Exercise #3b
Spring 2010
21 March 2010
Flying Fish.com
Flying Fish is organizing its corporate information before it creates an extension of their existing business on the Web. Their new business, Flying Fish.com, will provide fish owners with advice on fish health, behavior and nutrition, and sell such products as aquariums, filters, heaters, decorations, and water treatment aids. The web site will also have capabilities for fish owners to exchange electronic messages about their fish and fish care with other owners.
You have been asked to construct a database for Flying Fish.com, organizing their information on customers, fish care products, and fish care books. The following business rules govern the database you are to construct:
Customers can purchase either books or fish care products; a customer may purchase many books or many fish care products, or may purchase none of each. A given book can be purchased by one and only one customer and a given fish care product can be purchased by one and only one customer.
Books are tracked by ISBN number and serial number, as well as by title, author, book type (type of fish), price, date received, date sold, and purchase status (sold or not sold). Flying Fish.com carries only fish care books.
Fish care products are tracked by item number and serial number, as well as by manufacturer, product name, fish type (tropical, domestic), invoice price, purchase price, date sold, and purchase status (sold or not sold). Flying Fish.com only carries fish care products.
Customers are tracked by a customer identification number, last name, first name, and fish type (tropical, domestic, or both).
The company would like to generate reports that show their customers and the products or books they have purchased over the past year.
Assignment:
Create a UML diagram for Flying Fish.com, including the classes, attributes, relationships, primary keys,