Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

BISY1002 Database Management For Business

tag 0 Download 4 Pages / 877 Words tag 20-10-2021

Questions:

HTH started as a small family business and for the past five years has been managing their business activities using an Excel spreadsheet. With view to their expanding business and under the new management, they decided to investigate the option of implementing a database system. Accordingly, they hired you to design a relational database to better track and record their operational data.

HTH discovered business rules/constraints for your ERD:

A customer calls HTH to request a home repair job:
 
Details about the customer and the requested job need to be recorded.
 
Each tradesperson specialises in only one trade, and details of their trade and the date acquired need to be kept on record.
 
HTH has several trucks (including equipment) and allocates a truck for each tradesperson to do a job. Although some tradespersons have their own truck and equipment and advise HTH about this, so not to be assigned a truck.

A requested job may require different specialisation depending on the job type – that is, a job may require more than one tradesperson to complete.

At a later interview with the manager you learnt that HTH appoint one of the tradespersons to supervise others and oversee the work done by the other tradespersons.

Also HTH wants to keep records of how the customer was referred to them – by what source (ie- TV add, Friend, Internet, etc.)
 
Customers have the option to make partial payments for a service, as long as they pay no later than one week after the completion of any service -- Details about each payment relating to a service, amount of payment and date need to be recorded.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 4 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help (2021) Database Management For Business [Online]. Available from: https://myassignmenthelp.com/free-samples/bisy1002-database-management-for-business/understanding-the-hth-discovered-business-rules.html
[Accessed 06 December 2022].

My Assignment Help. 'Database Management For Business' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/bisy1002-database-management-for-business/understanding-the-hth-discovered-business-rules.html> accessed 06 December 2022.

My Assignment Help. Database Management For Business [Internet]. My Assignment Help. 2021 [cited 06 December 2022]. Available from: https://myassignmenthelp.com/free-samples/bisy1002-database-management-for-business/understanding-the-hth-discovered-business-rules.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?