Transcription of Object-Based Databases
{{id}} {{{paragraph}}}
Example: marketing
Object-Based Databases
C H A P T E R22 Object-Based DatabasesPractice car-rental company maintains a database for all vehicles in its cur-rent fleet. For all vehicles, it includes the vehicle identification number,license number, manufacturer, model, date of purchase, andcolor. Spe-cial data are included for certain types of vehicles: Trucks: cargo capacity. Sports cars: horsepower, renter age requirement. Vans: number of passengers. Off-road vehicles: ground clearance, drivetrain (four- ortwo-wheeldrive).Construct anSQLschema definition for this database. Use inheritancewhere :For this problem, we use table inheritance. We assume thatMyDate,ColorandDriveTrainTypeare pre-defined typeVehicle(vehicleidinteger,licensenumb erchar(15),manufacturerchar(30),modelcha r(30),purchasedateMyDate,colorColor)crea te tablevehicleof typeVehiclecreate tabletruck(cargocapacityinteger)underveh iclecreate tablesportsCar12 Chapter 22 Object-Based Databases (horsepowerintegerrenteragerequ irementinteger)undervehiclecr
CAD tools are typically used in a programming language envi-ronment needing to access the database. b. A system to track contributions made to candidates for public office: A relational system would be apt for this, as data types are ex-pected to be simple, and a powerful querying mechanism is es-sential. c.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: