Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please help me. How do I create those 4 table from the San Juan SailBoat Charters using the owner, boat, charter, and customer.

Can someone please help me. How do I create those 4 table from the San Juan SailBoat Charters using the owner, boat, charter, and customer. And how do I set the relationship between them? I believe the conceptual design is the data model for San Juan sailboat Charters on page 359. I just need help on how to create those for tables on access and how to set the relationship between them. This is urgent please image text in transcribed
image text in transcribed
b. San Juan Sailboat Charters-Case Question A. only Use only the following 4tables: OWNER, BOAT, CHARTER, and CUSTOMER Look at the 'conceptual' design and convert it to a logical/physical' design using MS Access database software. o Open MS Access create a new database called YourLastName_SanJuanSailboatCharters. o Create 4 tables and associated fields o Relate Goin) the 4 tables together adding appropriate foreign key fields as necessary o From within MS Access (under 'Database Tools), save the 'Relationship Report' as a pdf file

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database And Transact SQL

Authors: Lucy Scott

1st Edition

1974679985, 978-1974679980

More Books

Students also viewed these Databases questions

Question

How does the concept of hegemony relate to culture?

Answered: 1 week ago

Question

4. Support and enliven your speech with effective research

Answered: 1 week ago

Question

3. Choose an appropriate topic and develop it

Answered: 1 week ago