Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Using the data presented in Problem 1, develop an object space diagram representing the objects state for the instances of Truck listed below. Label

3. Using the data presented in Problem 1, develop an object space diagram representing the objects state for the instances of Truck listed below. Label each component clearly with proper OIDs and attribute names.

a. The instance of the class Truck with TRUCK_NUM = 5001.

b. The instances of the class Truck with TRUCK_NUM = 5003 and 5004.

4. Given the information in Problem 1, define a superclass Vehicle for the Truck class. Redraw the object space you developed in Problem 3, taking into consideration the new superclass that you just added to the class hierarchy.

image text in transcribed

The RRE Trucking Company database FIGURE PG.1 E TRUCK Table IVEHICLE NUM IEASE CODE TYPE CODE VEHICLE MILES VEHCLE BUY DATE VEHICLE VIN 5001 101 1 162123.50 08-Nov-O3 AA-322-1221 5002 102 1 276984.30 23-Mar-01 AC-342-221 34-Q23 503 101 2 212346.60 27-Dec-02 AC-445-75555. Zgg 50004 101 1 998 94.30 21-Fck-03 -112-23144-T34 505 103 2 24567310 15- Apr 02 FR-sca-32245-vr 2 5008 101 6 293245.70 30 Aug 01 AD-456-00845-R45 50007 102 3 132012.30 01-Dec 02 AA 34 1-S6573-zas 500B 102 3 14421360 21-Sep-02 DR-S59-22189 D33 5003 103 2 50932.90 16. Jan-04 DE-aa7-95456-ese4 5010 104 1 3421340 12-Apr-D5 FD-221-21100 F32 5011 101 1 42326.50 09-Nov-05 DT-24-04056-H22 5012 2339.1 23 -May-D3 GF-657-22131-HA8 5013 101 3 298 145.50 11 Apr 01 HR. 344-54560-32 5014 8122.20 09-Sep-D3 RN 2B9-38956-HB7 5m5 103 1 154567 90 25-Mar 03 HH 231-55498-K37 1200.60 501 05 B-Mar-06 FR-332-23459-355 507 105 1 334550 23-Feb-05 DD-S45-7B896-X39 Record: of 17 BASE Table BASE CODE BASE CITY BASE STATE BASE AREA CODE BASE PHONE BASE MANAGER 102 Lexi 606 234-5678 George H. Delarosa Mana J. TalIndo 6-7 B90 Peter F. Mcafee 104 Athens GA 901 Lee A. Chau Record of 5 TYPE Table TYPE CODE TYPE DESCRPTION 1 Singe bo 2 single box, single-sole 3 Tandem trailer sin de-axe 4 Tandem trailer, double-axle 5 Util 6 Dump truck e-axle 7 Dump truck, double-axle ord Rcc of 7

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

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

9th Edition

ISBN: B01JXPZ7AK, 9780805360479

More Books

Students also viewed these Databases questions

Question

1. Define mass and mediated communication

Answered: 1 week ago