PDF4PRO ⚡AMP

Modern search engine that looking for books and documents around the web

Example: marketing

Object-Based Databases

Back to document page

C H A P T E R22Object-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 tablesportsCar12Chapter 22Object-Based Databases (horsepowerintegerrenteragerequ irementinteger)undervehiclecreat

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.

  Programming, Language, Programming language

Download Object-Based Databases


Information

Domain:

Source:

Link to this page:

Please notify us if you found a problem with this document:

Spam in document Broken preview Other abuse

Related search queries