Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

. Assume the following business rules: - A course contains many sections, but each section has only one course. - A section is taught by

image text in transcribed

. Assume the following business rules: - A course contains many sections, but each section has only one course. - A section is taught by one professor, but each professor may teach one or more different sections of one or more courses.

-A section may contain many students, and each student is enrolled in many sections, but each section belongs to a different course. (Students may take many courses, but they cannot take many sections of the same course.) - Each section is taught in one room, but each room may be used to teach several different sections of one or more courses. - A professor advises many students, but a student has only one advisor. Based on those business rules: a. Identify and describe the main classes of objects. b. Modify your description in (a) to include the use of abstract data types such as Name, DOB, and Address. c. Use object representation diagrams to show the relationships between: - Course and Section. - Section and Professor. - Professor and Student. d. Use object representation diagrams to show the relationships between: -Section and Students. - Room and Section. What type of object is necessary to represent those relationships? e. Using an OO generalization, define a superclass Person for Student and Professor. Describe this new superclass and its relationship to its subclasses.

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

Professional Visual Basic 6 Databases

Authors: Charles Williams

1st Edition

1861002025, 978-1861002020

More Books

Students also viewed these Databases questions

Question

Were the decisions based on appropriate facts?

Answered: 1 week ago

Question

Were the right people involved in the decision-making process?

Answered: 1 week ago