In addition, every computer has a short description and purchase price. Furthermore it is necessary to record to which employee a computer has been issued. Stationary computers are allocated to a specific room. They are part of buildings which have a unique building-id and which have an address. In addition, for every computer, the supplier from which it was purchased needs to be recorded.
Every supplier has a supplier-id, a name, an address and a telephone number.
Racing data model. Several companies have invested their money in race cars. Companies are have a company name and number. A race car may be owned by an individual company or may be jointly owned by a group of companies. For every car, the total money invested, the contributions of each company as well as their percentage shares need to be recorded.