QuestionQuestion

Transcribed TextTranscribed Text

Objective: The purpose of this lab is for the student to dive into MS Access SQL programming by creating a basic database. Database Name: MCDB Table 1: People PersonID First_Name Last_Name Age 1 Your Name 20 2 My Name 30 3 Some Name 40 Table 2: Bikes BikeID Make Model M1 Harley Sportster M2 Harley Dyna M3 Harley Softail M4 Harley VROD M5 Harley Touring M6 Harley CVO Table 3: People_Bikes PersonId BikeID 1 M1 2 M2 2 M3 3 M4 3 M5 3 M6 Procedure: Your task is to make a basic database using SQL in Microsoft Access. The database should be structured as shown above in the diagram. Once completed you should run a single query that returns The First Name, Last Name, Age, Make, and Model of each person and the bike they have.

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

SELECT People.First_Name, People.Last_Name, People.Age, Bikes.Make, Bikes.Model
FROM People INNER JOIN (Bikes INNER JOIN People_Bikes ON Bikes.[BikeID] = People_Bikes.[BikeID]) ON People.[PersonID] = People_Bikes.[PersonID];...

By purchasing this solution you'll be able to access the following files:
Solution.docx and Solution.zip.

$18.00
for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

Find A Tutor

View available Database Development Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.

Decision:
Upload a file
Continue without uploading

SUBMIT YOUR HOMEWORK
We couldn't find that subject.
Please select the best match from the list below.

We'll send you an email right away. If it's not in your inbox, check your spam folder.

  • 1
  • 2
  • 3
Live Chats