Question

Microsoft Access - Relationship

----------------------------------------------------------------------------

Using Microsoft Access to implement this database (ERD of the picture below), how does the Access Relationship Window look like?

-----------------------------------------------------------------------------

San Juan Sailboat Charters San Juan Sailboat Charters is an agent that leases sailboats. It 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. The sailboats are in different the sizes of the boat and have different leasing rates. San Juan earns a fixed commission on the lease of any boat. Each sailboat is fully equipped with the equipments either provided by the boat owner or added by San Juan. There are fixed equipments such as radios, compasses, depth indicators, stoves, refrigerators etc.., and non-attached equipments such as sails, lines, anchors, dinghies, silverware, cooking utensils, bedding etc... San Juan also provides other supplies such as charts, tide and current map, dishtowel, toilet paper, and similar consumable items. San Juan pays specific attention to keeping track of equipment on the boat. Much of it is expensive, especially non-attached equipment, can easily be lost or stolen. Customers are responsible for all equipment during the period of their charter. Therefore, San Juan would like to keep accurate records of its customers, charters, and obviously the boats and their various equipments. Most of San Juan's business is bare-boat chartering, which means that no skipper or other crew is provided. But in some cases, at customers' requests San Juan would offer the service with an extra fee. In such case, it hires these personnel on a part-time/on- call basis.

Answer 1

The below are the two table as well as the relationship between the database

File Home Crate External Data Database Tools Design Analyze Pertormance Compact and Visual Run Relationships Object Repair Database Basic Macro DependendiesTable Analyze SOL Access SharePoint Add-ins Server Database Tools Macro Move Data Add-In «San boats Relationships All Access Objects Search. Tables San Jaun boarts List of Boats Select boats Facilities Loaction Address Text Text Date/Time Text Text Text Charter List of availble boats date and time Type of facilities required Locate boat Enter address San boats Reports Relationships for Databasel Field Pro General Lookup

File Home Create External Data Database Tools Design Hide Table Direct Relationships X Clear Layout ditRelationship Report Show Close Relationships Table All Relationships Tools Relationships All Access Objects ) << ■ San boats-, Relationships Search Tables San boats San boats.1 San Jaun boarts List of Boats Select boats Facilities San Jaun boarts List of Boats Select boats Facilities Loactiorn San boats Reports Relationships for Database1