A network of vehicle repair services would like to create a database to store

information about their activities.

The network consists of a number of vehicle repair centers located all over a

country. A vehicle repair center is described by a unique address $($city name,

street name, and building number$),$ unique phone number, unique fax number, and

unique web site address. A vehicle repair center is also described by its

maximum capacity, i$.$e$.$ the largest number of cars and the largest number of

trucks that can be repaired at a moment.

The network specializes in the repairs of vehicles such as cars and trucks and

no other vehicles. Information about a vehicle left by an owner for repair

includes a vehicle registration number, make, model, and telephone contact

number to an owner. Additionally, trucks are described by a capacity and

manufacturing date.

A vehicle can be repaired many times in many different vehicle repair centers.

The network records date and time when a vehicle has been brought to a garage by

an owner, a short description of a problem, date and time when a vehicle was

released from a vehicle repair center and collected by an owner, and short

description of the outcomes. Note, that when a vehicle is brought to a garage,

release date and time, and the outcomes are still unknown.

Each repair needs zero or more spare parts used. A spare part is described by a

unique name, unique bar code, and price. The network would like to store in the

database information about all parts used for each repair.