Daily Report 13/4

- Tested Notebook for display problems (No Error Found)
- General Receiption Work
- Database Project Proposal created
- Estimated Costs
- Estimated Milestones
- Outline of work and processes to be done
- Analysis on Current Database Table
- Kenny advised of Data Import capability requirement
- able to import from "Order Book"
- able to import from Third party repair centres
- Universe of Discourse created

The Universe of Discourse
Asus Notebook Service Centre, Brisbane

Customer has First Name
Customer has Last Name
Customer has Phone Number
Customer has Mobile Number
Customer has Fax Number
Customer has E-mail address
Customer has company name
Customer has Address

Address has Street
Address has Post Code
Address has City
Address has State

Street has Street Number
Street has Street Name

Customer owns a Notebook

Notebook has a Serial Number
Notebook has a Model
Notebook has a Specification
Notebook has a Purchase Date
Notebook has a Warranty Expiry Date (2 yrs from purchase date or 2 yrs from Serial Number, whichever is later)
Notebook has a Service Job

Service Job is fixed by Staff
Service Job is delivered by Staff
Service Job is received by Staff
Service Job has failure symptoms…
Service Job has Service Charge of ($)
Service Job has diagnosis description
Service Job has Action Taken
Service Job uses Parts
Service Job is serviced at Location (def: Brisbane)
Service Job was received on (Time)
Service Job was started on (Time)
Service Job was ended on (Time)
Service Job was delivered on (Time)

Parts has Part Number
Parts has Serial
Parts has Description
Parts has Status (New/Used)
Parts has Price

Staff has FirstName
Staff has LastName
Staff has StaffID

Call is taken by Staff
Call is calling from a Customer
Call is related to Notebook
Call maybe about Service Job
Call has Inquiry Detail
Call has Advise Given
Call has start time
Call has finish time
Call has call_type (in/out)