Lab_4_Answers (1)

docx

School

Algonquin College *

*We aren’t endorsed by this school

Course

8215

Subject

Economics

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by MegaRainLyrebird35

Lab 4 – Answer the following questions and upload this file along with the ER diagram  Referring to the Describing Relationships section in the Relationships and Cardinality page in Module 4, describe the relationships. Note: you will produce four sentences describing the relationships  Name each table and the column making up the primary keys  Name the table and the colum making up the foreign keys   What’s the relationship type between car_ vehicle_class and fuel_consumption  What’s the relationship type between car_make and fuel_consumption a brand of car (car_make) has many amounts of fuel consumption. a vehicle class has many amounts of fuel consumption. a fuel consumption belongs to one vehicle class. A fuel consumption belongs to one car brand 1. Car_vehicle_class : columns are class_id, vehicle_class / Primary key is class_id 2. Fuel_consumption: colums are fuel_consumption_id, make_id, class_id, fuel_consumption / Primary key is fuel_consumption_id 3. Car_make: colums are make_id, make / Primary key is make_id 1. Car_vehicle_class: foreign key is vehicle_class 2. Fuel_consumption: foreign keys are make_id, class_id, fuel_consumption 3. Car_make: foreign key is make Table car_vehicle_class has a one to many relationship to table fuel_consumption Table car_make has a one to many relationship to table fuel_consumption

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

Econ 113 Study questions_conceptual.docx

Assignment 2 BUAN 6312.docx

HmW 1_202_ONLINE.docx

HmW 2_202_ONLINE (1).docx

Realestate- questions - ww.docx

Problem Set #1..docx

Answers to Chapter 12 pre-lecture questions 16-23.pdf

PS5 (1).pdf

Midterm.docx

Graduation Rates group activity.docx

HULT10.docx

Week 1 MBA 5030 Porters Five Forces.docx

Recommended textbooks for you

Microeconomic Theory

Economics

ISBN:9781337517942

Author:NICHOLSON

Publisher:Cengage

MACROECONOMICS FOR TODAY

Economics

ISBN:9781337613057

Author:Tucker

Publisher:CENGAGE L

Micro Economics For Today

Economics

ISBN:9781337613064

Author:Tucker, Irvin B.

Publisher:Cengage,

Economics For Today

Economics

ISBN:9781337613040

Author:Tucker

Publisher:Cengage Learning

Survey Of Economics

Economics

ISBN:9781337111522

Author:Tucker, Irvin B.

Publisher:Cengage,

Economics Today and Tomorrow, Student Edition

Economics

ISBN:9780078747663

Author:McGraw-Hill

Publisher:Glencoe/McGraw-Hill School Pub Co

SEE MORE TEXTBOOKS

Recommended textbooks for you

Microeconomic Theory
Economics
ISBN:9781337517942
Author:NICHOLSON
Publisher:Cengage
MACROECONOMICS FOR TODAY
Economics
ISBN:9781337613057
Author:Tucker
Publisher:CENGAGE L
Micro Economics For Today
Economics
ISBN:9781337613064
Author:Tucker, Irvin B.
Publisher:Cengage,
Economics For Today
Economics
ISBN:9781337613040
Author:Tucker
Publisher:Cengage Learning
Survey Of Economics
Economics
ISBN:9781337111522
Author:Tucker, Irvin B.
Publisher:Cengage,
Economics Today and Tomorrow, Student Edition
Economics
ISBN:9780078747663
Author:McGraw-Hill
Publisher:Glencoe/McGraw-Hill School Pub Co