Purchase Solution

San Juan Sailboat Charters: Entities, Identifying Primary and Foreign Keys

Not what you're looking for?

Ask Custom Question

San Juan Sailboat Charters is an agent that leases sailboats to customers for a fee. San Juan does not own any sailboats; it leases boats on behalf of the owners who wish to earn income when they are not using their boats. San Juan charges a fee for its service. San Juan specializes in boats that can be used for multi-day or weekly charters? the smallest sailboat in its inventory is 28 feet and the largest is 51 feet.

Each sailboat is fully equipped at the time it is leased. Most of the equipment is provided by the owners, but some is added by San Juan. The owner-provided equipment includes what is fixed on the boat, such as radios, compasses, depth indicators and other instrumentation, stoves, and refrigerators. Other owner-provided equipment is not installed as part of the boat. Such equipment includes sails; lines; anchors; dinghies; life preservers; and (in the cabin) dishes, silverware, cooking utensils, bedding, and the like. San Juan provides consumable equipment, (which can also be considered supplies) such as charts, navigation books, tide and current tables, soap, dishtowels, toilet paper, and similar items.

An important part of San Juan's responsibilities is keeping track of the equipment on the boat. Much of it is expensive, and some of it, particularly what is not attached to the boat, can easily be lost or stolen. Customers are responsible for all equipment during the period of their charter. San Juan likes to keep accurate records of its customers and the charters, not only for marketing but also for recording the trips that customers have taken. Some itineraries and weather conditions are more dangerous than others, so San Juan likes to know which customers have what experience.

Most of San Juan's business is bare-boat chartering, which means that no skip-per or other crew is provided. In some cases, however, customers request the services of a skipper or other crew member, so San Juan hires such personnel on a part-time basis.
Sailboats often need maintenance. San Juan is required by its contracts with the boat owners to keep accurate records of all maintenance activities and costs, including normal activities (for example, cleaning or engine-oil changes) and unscheduled repairs. In some cases, repairs are necessary during a charter.

A boat engine, for example, might fail while the boat is far away from San Juan's facility. In this case, the customers radio the San Juan dispatcher, who determines the best facility to make the repair and sends the facility's personnel to the disabled boat. To make these decisions, the dispatchers need information about repair facilities as well as past histories of repair quality and costs.

1. Identify all the entities and their attributes listed in the case study above.

2. Suggest some primary keys for each entity (Primary and Foreign).

Purchase this Solution
Solution Summary

Primary and Foreign keys and attributes are briefly identified in this solution.

Solution Preview

1. Identify all the entities and there attributes listed in the case study above.

Entities:
(1) Sailboat - Attributes: Boat_Code, Charter_Type, Size, Fixed_Equipment, Uninstalled_Equipment,
...

Purchase this Solution
Free BrainMass Quizzes
Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

View More Free Quizzes
Related BrainMass Solutions

  • Diagram for the San Juan Boat Company

    131386 Create an ER Diagram for the San Juan Boat Company San Juan Sailboat Charters is an agent that leases sailboats to customers for a fee.

  • Huffman Trucking Virtual Organization

    Indicate primary keys, foreign keys, and new attributes as in the entity relationship diagram.

  • RDMS Implementation: 1-N, N-1, and N-N relationships

    Describe the three types of relationships and explain your examples. For each example, name the entities and attributes, select the primary and foreign keys, and present it in the common shorthand method. Hi, Please check the attachment.

  • ERD using MySQL modeling tool

    The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a).

  • Important information about Database Definitions Exercise

    Primary Key- A primary key is an exclusively identifying key in the design of a database table. f. Foreign Key- A foreign key is a database key utilized as a reference which relates separate entities to one another.

  • How are relationships established?

    Relationships are established by declaring foreign keys on the data base entity. Steps to establish relationships between entities: ? Define certain attributes in each table as primary key.

  • supporting data integrity in a database

    Primary Key Domains The values of primary keys must be unique and nulls are not allowed. Foreign Key Domains The data type, length, and format of primary keys must be the same as the corresponding primary key.

  • Database Design Questions

    The foreign keys will always inherit the attribute characteristics from the primary keys that they point to. c. The primary keys will always inherit the attribute characteristics from the foreign key that they point to. d.

  • strategic planning for database class

    What entities would be involved? What would the primary keys of each of the entities be and why? Here is a basic structure of table's one need to keep track of an ordering system.

View More Related Solutions