Question: Please convert this data model to a database design. Specify tables, primary keys, and foreign keys. Use only the following 4 entities: OWNER, BOAT, CHARTER,

Please convert this data model to a database design. Specify tables, primary keys, and foreign keys.

Use only the following 4 entities: OWNER, BOAT, CHARTER, and CUSTOMER.

Look at the 'conceptual' design and convert it to a 'logical/physical' design using MS Access database software. .

Create as many tables as required and associated fields.

Relate (join) the tables together adding appropriate foreign key fields as necessary.

Please convert this data model to a database design. Specify tables, primary

Coastauard regNumtr Boat iane SCHEDULED MAINTENANCE RequiredDate BoatModel Boattype Coot NumberOMBerths BankpooountNumber CHARTER EQUIPMENT tsmiDTabNumber CUSTOMER DepartureDate ReturnDate NumberlnParty FirstName temSerialNumber ? ?Address Boat EquipmentCost CreditCardNumber CharterlD EntryNumber EntryTime EntryLocation DepartingFrom SailingTo Coastauard regNumtr Boat iane SCHEDULED MAINTENANCE RequiredDate BoatModel Boattype Coot NumberOMBerths BankpooountNumber CHARTER EQUIPMENT tsmiDTabNumber CUSTOMER DepartureDate ReturnDate NumberlnParty FirstName temSerialNumber ? ?Address Boat EquipmentCost CreditCardNumber CharterlD EntryNumber EntryTime EntryLocation DepartingFrom SailingTo

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Convert this data model to a database design. Specify tables, primary keys, and foreign keys. Create 4 tables and associated fields. (Normalize into 4 tables or just choose the 4 tables in which you...

Convert this data model to a database design. Specify tables, primary keys, and foreign keys. Create 4 tables and associated fields. (Normalize into 4 tables) Relate (join) the 4 tables together...

The Queen Anne Curiosity Shop is an upscale home furnishings store in a well-to-do urban neighborhood. It sells both antiques and current-production household items that complement or are useful with...

Convert this data model to a database design. Specify tables, primary keys, and foreign keys. Using Figure 6-43 as a guide, specify column properties. Describe how you have represented weak entities,...

A Convert this data model to a database design. Specify tables, primary keys, and foreign keys. Using Figure 6-43 as a guide, specify column properties. Duplicate the following table as needed to...

Convert this data model to a database design. Specify tables, primary keys, and foreign keys. Using Figure 6-43 as a guide, specify column properties. Duplicate the following table as needed to...

Referring to the model above, please convert the data model you constructed for James River Jewelry into a relational database design by Microsoft ACCESS or by hand/on paper. Please also document...

OVERVIEW This lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. In the FLIX2YOU product...

Assignment brief Quiet Attic Films is a film production company based in London, England who specialize in making short information films and advertisements for television. They want you to design...

A company is considering investing in one of three projects - Project A, Project B, or Project C. Each project has a different expected return and a different level of risk. The following table shows...

Relative to depreciation, why is comprehensive allocation an example of rigid uniformity and partial allocation an example of finite uniformity?

Which of the financial statements tells us how a firm performed.?It shows us flows of funds over a specified time period.

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Teamwork.With a partner read alternate sentences from the following paragraph aloud to each other. (Objective 2) ehT qaimtimg also qroved that, sa well sa being a great humter, Cro-Wagmom Nam saw a...

Global.Contact an international center at a university (visit, call, or send e-mail).Ask about a study abroad or work abroad program. Develop and present your findings to your class. (Objectives 4...

Technology. Global. India is a well-known location for offshore sites and outsourcing operations for large corporations. Using an encyclopedia, website URLs in this chapter, or other resources,...