MIS 201 Introduction to MIS

UML Class Diagram Exercise #3b

Fall 2010

3 November 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, foreign keys, and association classes/linking tables. Attach the class diagram to me at the end of class. , and then create your tables in Access.

In Access, ensure that your data types correspond to the type of information to be contained in that field, and that you have used the most appropriate data type for each attribute. Use drop down boxes and Boolean operators (yes/no) as required. Create relationships between tables as required, and ensure that the relationships created in Access correspond to the ones in your UML class diagram.