Question: Imagine you are creating a database for a car dealership What 3 tables / entities would you include? Which attributes / columns / fields (different

Imagine you are creating a database for a car dealership

  1. What 3 tables / entities would you include?
  2. Which attributes / columns / fields (different names for the same thing) would be in each table?
  3. Which fields in each table would join to which other field to form relationships?
  4. For each table, list the primary key(s) and any foreign keys
  5. Create a Visio diagram of your tables showing their connections.

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 General Management Questions!

Q:

Consider the following facts and identify those that would be necessary to (1) disclose or (2) include in an antenuptial agreement. 1 Mac is a widower who has three adult children. All the children...

Q:

Imagine you are creating a database for new business (this question doesnt need a word count) Describe the business and its data needs. What 3 tables / entities would you include in the database?...

Q:

SHIPMENT_LINE SHIP_ID INV_ID SL_QUANTITY SL_DATE_RECEIVED Number Number Number Date/ Time 25 09/10/2006 2 25 09/10/2006 2 25 5 200 6 200 7 200 12 100 08/15/2006 13 100 08/25/2006 23 50 08/15/2006 24...

Q:

I need help writing the code in Codio with the instructions attached. I also attached a screenshot of the error code that I was given. Terminal X mysql> USE QuantigrationRMA; Reading table...

Q:

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

Q:

USE ONLY CPLEX/AMPL Instructions: 2. Questions are divided into 3 sections: a, b and c that walk you through the step-by-step process of creating a database. 3. Make sure to properly explain the...

Q:

Instructions: 2. Questions are divided into 3 sections: a, b and c that walk you through the step-by-step process of creating a database. 3. Make sure to properly explain the choices you made while...

Q:

VALLEY FURNITURE DELIVERY DATA MODELING ASSIGNMENT MGMT 4013 TC1, Spring 2018 Your assignment is to create a data model based on the scenario and data below. For your convenience, I have included the...

Q:

Needing help with this project anything is appreciated. The model with the relationships is throwing me through a loop. Thanks Database Project Part 1: 150 points Due: See Canvas for Due Dates...

Q:

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Q:

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Q:

Go to the Shell website and examine the sustainability report. Examine the report and other information on the website and comment on the following: a. What approach did Shell take in undertaking its...

Q:

6. Use Tesla's information below to answer this question: Tesla Inc (TSLA) 2/27/23 Stock P = 207.63 Call 30.40 Strike Price Days Put 185 32 6.90 190 32 26.90 8.45 195 32 23.70 10.15 185 53 35.25...

Q:

All of the following, except for one, would result in a misstatement. Which of the following would NOT result in a misstatement? Recognizing revenue as soon as the merchandise for the customer was...

Q:

Question 1 (5 points) A company wants to reduce the time a customer is on the phone with their customer service department. They select 35 employees at random to take a training on customer service....