Question

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?

Answer 1