diff --git a/UsedCars/UsedCars.xml b/UsedCars/UsedCars.xml index f654a49..6a18719 100644 --- a/UsedCars/UsedCars.xml +++ b/UsedCars/UsedCars.xml @@ -77,7 +77,7 @@ -

As noted above, Happy Joe’s has about one hundred employees. The usual details such as name, address and phone number will be recorded. Employees must be at least 16 years old at the time they are first hired.

+

As noted above, Happy Joe’s has about one hundred employees. The usual details such as name, address and phone number will be recorded. Employees must be at least 18 years old at the time they are first hired.

Note that Service, Sales and Other are all subtypes of Staff, and therefore use the same primary key as Staff.

@@ -155,7 +155,7 @@ -

Hourly_Rate must meet minimum wage requirements: at least 11.00 for “starting out” workers, and at least 13.50 for adults. Total_Hours is measured to the nearest quarter hour and must be in the range 0–3500 (= 40 hours per week 52 weeks per year, plus a generous allowance for overtime).

+

Hourly_Rate must meet the minimum wage requirements of at least 13.50 for adults. Total_Hours is measured to the nearest quarter hour and must be in the range 0–4500 (= 40 hours per week 52 weeks per year, plus a generous buffer to allow for overtime).

@@ -238,7 +238,7 @@ -

Salary must meet minimum wage requirements: at least 22880 (= 11.00 40 hours per week 52 weeks per year) for “starting out” workers, and at least 27040 for those 18 or older.

+

Salary must meet the minimum wage requirement of at least 28080 (= 13.50 40 hours per week 52 weeks per year) for adults.

@@ -321,7 +321,7 @@

Some sales staff are paid on commission (up to 30 of the value of each sale), while others are paid a flat rate per sale that varies depending on the type of car sold (e.g., 100 for a Toyota Corolla vs.500 for a BMW M3; these rates are stored in Car—see ). If the salesrep is paid on commission then On_Commission is “true” and Commission_Rate must be greater than zero. If the salesrep is paid on flat rate then On_Commission is “false” and Commission_Rate must be zero.

-

Gross_Earnings stores the gross amount (i.e., before tax) earned by a salesrep to date in the current financial year (1 April to 31 March). For salesreps who are on commission, this is the sum to date of Commission_RateSale.Amount. For salesreps who are not on commission, this is sum to date of Car.Flat_Rate (via Sale—see and ).

+

Gross_Earnings stores the gross amount (i.e., before tax) earned by a salesrep to date in the current financial year (1 April to 31 March). For salesreps who are on commission, this is the sum to date of Commission_RateSale.Amount. For salesreps who are not on commission, this is sum to date of Car.Flat_Rate for each car sold (see Sale in ).

@@ -419,7 +419,7 @@ -

The usual details will be recorded for each customer: name, address, phone and optionally an email address. The credit rating is also optional.

+

The usual details will be recorded for each customer: name, address, phone and optionally an email address.

@@ -603,7 +603,7 @@ -

Cars may have any number of optional features, such as air conditioning, side airbags, body kit, iPod integration, cruise control, etc.

+

Cars may optionally have any number of special features, such as alloy wheels, side airbags, body kit, iPod integration, cruise control, etc.

Car_Feature is an associative entity that exists only to link cars with features. It has no additional attributes of its own.

@@ -688,15 +688,15 @@ Of warranty in kilometres (see below) - * - Description + o + Notes Up to 250 characters -

The New Zealand government mandates four categories of dealer warranty for used cars. Warranty is a lookup table that records details of these warranty categories and enables them to be easily changed if the regulations change. An excerpt from a government discussion paperDiscussion Paper on Proposed Consumer Information Standard for Secondhand Motor Vehicles, Ministry of Consumer Affairs, New Zealand Government, May 1998, ISBN 0-478-00075-8. defining the different categories of warranty is included as “Appendix 4” at the end of this document; use these details to populate the table with appropriate data.

+

New Zealand legislation mandates four categories of dealer warranty for used cars. Warranty is a lookup table that records details of these warranty categories and enables them to be easily changed if the regulations change. An excerpt from a government discussion paperDiscussion Paper on Proposed Consumer Information Standard for Secondhand Motor Vehicles, Ministry of Consumer Affairs, New Zealand Government, May 1998, ISBN 0-478-00075-8. defining the different categories of warranty is included as “Appendix 4” at the end of this document; use this to populate the table with appropriate data.

@@ -705,9 +705,9 @@ CREATE TABLE Warranty ( W_Code CHAR(1), - Duration NUMBER(1) NOT NULL, - Distance NUMBER(4) NOT NULL, - Description VARCHAR2(250) NOT NULL, + Duration NUMBER(1), + Distance NUMBER(4), + Notes VARCHAR2(250), -- CONSTRAINT Warranty_PK PRIMARY KEY ( W_Code ) ); @@ -773,7 +773,7 @@ -

Purchases are for a single car only (i.e., no bulk purchases). Trade-ins are effectively treated as a special type of purchase (see ).

+

Purchases are for a single car only (i.e., no fleet purchases). Trade-ins are effectively treated as a special type of purchase (see ).

@@ -850,7 +850,7 @@ -

Sales are for a single car only (i.e., no bulk sales). Some sales involve the trade-in of a single car, which is effectively treated as a special type of purchase that is linked to the corresponding sale.

+

Sales are for a single car only (i.e., no fleet sales). Some sales involve the trade-in of a single car, which is effectively treated as a special type of purchase that is linked to the corresponding sale.