Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1. Consider the diagrams immediately below. Sample SERVICE_LOG Data SVC_LOG_NUM LOG_COMPLAINT SVC_LOG_CHARGE CAR_VIN STATUS STATUS_DATE 10012 Hard to start. Accelerates poorly. $89.75 2AA-W-123456 Closed

Question 1. Consider the diagrams immediately below.

Sample SERVICE_LOG Data

SVC_LOG_NUM

LOG_COMPLAINT

SVC_LOG_CHARGE

CAR_VIN

STATUS

STATUS_DATE

10012

Hard to start. Accelerates poorly.

$89.75

2AA-W-123456

Closed

02-Jan-2019

10013

Oil change. Rotate and balance tires.

$19.95

5DR-T-8765432

Closed

04-Jan-2019

10014

Temp gauge shows high temps.

$135.70

4UY-D-6543210

Opened

07-Jan-2019

Sample EMPLOYEE Data

EMP_NUM

EMP_FNAME

EMP_LNAME

104

James

Winston

106

Victoria

Lopez

112

Oscar

LeBlanc

114

Vincent

Owens

Sample SERVICE_LOG_LINE Data

SVC_LINE_NUM

SVC_LOG_NUM

SVC_LINE_WORK

EMP_NUM

PART_CODE

1

10012

Cleaned injection nozzles

106

000000

1

10013

Drained oil

112

000000

2

10013

Installed filter

112

FLTR-0156

3

10013

Replaced oil

112

Oil-PZ30/40

4

10013

Rotated tires

114

000000

5

10013

Balanced tires, using four weights (LF0.5oz, RF1.1oz, RR1.2oz, LR0.8 oz)

106

WT-LD10012

1

10014

Drained coolant

104

000000

2

10014

Replaced thermostat

112

THERM-007B

3

10014

Replaced coolant

104

COOL-289XZ

Sample PART_LOG Data

PARTLOG_NUM

PART_CODE

SVC_LOG_NUM

PARTLOG_DATE

PARTLOG_UNITS

10185

FLTR-0156

10013

4-Jan-2019

1

10186

Oil-PZ30/40

10013

4-Jan-2019

8

10187

WT-LD10012

10013

4-Jan-2019

4

10188

THERM-007B

10014

7-Jan-2019

1

10189

COOL-289XZ

10014

7-Jan-2019

1

Questions:

A) What are the entities?

B) What are the attributes for the entities? (Be sure to identify which attributes belong to which entities.)

C) How many tuples are in each table?

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

Databases Demystified

Authors: Andrew Oppel

1st Edition

0072253649, 9780072253641

More Books

Students also viewed these Databases questions

Question

What are the pros and cons regarding Angelica joining the union?

Answered: 1 week ago