Speclad

Rate this solution

About this Solution

Problem description excrept

Solution Image

Solution Files

Other Solutions for the same Problem

A web design company, called Webmedia, is organised in 4 departments: the HR (Human Resources), the Graphic Designers, the Developers and the Managers. Each employee may work in one or two Departments and is under the supervision of only one manager.

Additional important information to be recorded for each employee includes the name, surname and age as well as the paid leave allowance per year (number of paid days the employee can take as leave).

Rate this solution

About this Solution

Problem description excrept

Solution Image

Solution Files

Other Solutions for the same Problem

Rate this solution

About this Solution

Problem description excrept

Solution Image

Solution Files

Other Solutions for the same Problem

Rate this solution

About this Solution

Problem description excrept

Solution Image

Solution Files

Other Solutions for the same Problem

The Local Council has an Emergency Control Vehicle System (ECVS) to manage and control the allocation of emergency vehicles during any emergencies that arise within a 40 km radius. The Local Council owns 10 emergency vehicles; four ambulances, three fire emergency vehicles and three smaller patient care and transport vehicles. For each vehicle a registration number, the buying cost and the vehicle's brand (either a Ford, a Subaru or a Toyota) are stored. Each vehicle has an allocated driver during an emergency call.

Rate this solution

About this Solution

Problem description excrept

Solution Image

Solution Files

Other Solutions for the same Problem

In our organisation we have many students from all levels and staff. For all we record their names (family, first and sometimes their previous name), and for our students we record their current level of study (either primary, secondary or tertiary).
For our Graduate students we also record their latest qualification. Qualifications are various, and we need to recall the name of that qualification, along with the year and place it was awarded.
Our Top Group of students has 3 members: 2 Graduates: Pattie and Kelly, and one student we're not yet sure about his status: Michael.

The Rent-by-Nite car rental company wants you to design a software system for car rentals that manages the rental and return of vehicles. A driver (customer) rents a vehicle for a certain period of time, specified through the agreed pick-up and return dates and times. The vehicle must be returned to the rental location by the agreed return date otherwise surcharges are applied. Vehicles are classified into different categories (economy, standard, luxury) for which different rates apply. Rental charges are calculated from the daily rate for that vehicle multiplied by the number of rental days.