Order Now
Uncategorized

Database Design Consultant For My Computer Specialist Pty Ltd (MCS)

7 min read
Posted on 
April 23rd, 2025
Home Uncategorized Database Design Consultant For My Computer Specialist Pty Ltd (MCS)

 

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

BUSINESS_ACCOUNT

ACCOUNT_NUMBER(PK)

ACCOUNT_NAME

TAX

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

ABN_NUMBER

ACCOUNT_STATUS

ACCOUNT_DATE

ACCOUNT_TYPE

CONTACT_PEOPLE

CONTACT_PEOPLE_ID(PK)

ACCOUNT_NUMBER* (FK)

CONTACT_DETAIL

CONTACT_PEOPLE_ID *(PK,FK)

CONTACT_DETAIL_TYPE (PK)

DETAIL

CONTACT_ADDRESS

CONTACT_PEOPLE_ID*(PK,FK)

CONTACT_ADDRESS_TYPE(PK)

DETAIL

BUSINESS_ACCOUNT_CONTACT_DETAIL

ACCOUNT_NUMBER*(PK,FK)

CONTACT_DETAIL_TYPE(PK)

DETIAL

BUSINESS_ACCOUNT_CONTACT_ADDRESS

ACCOUNT_NUMBER*(PK,FK)

CONTACT_ADDRESS_TYPE(PK)

DETAIL

PART

PART_ID*(PK)

PART_CATEGORY

MANUFACTURER

DESCRIPTION

CURRENT_PART

SUPPLIERS_DETAIL

SUPPLIER_ID(PK)

PART_ID*(PK,FK)

PART_NUMBER

SELL_PRICE

SELL_TAX

SELL_PRICE_DATE

LOCATION

SUPPLIER_ACCOUNT

ACCOUNT_NUMBER*(PK,FK)

SUPPLIER_ID(FK)

PURCHASE

PART_TRANSACTION_ID(PK)

PART_ID(FK)

SUPPLIER_ID(FK)

PART_SERIAL_NUM

SUPPLIER_INVOICE_NUMBER

INVOICE_DATE

PART_STATUS

PURCHASE_PRICE

TAX

FREIGHT_COST

CLIENT_JOBS

CLIENT_JOB_NUMBER(PK)

REFERENCE_NUMBER

JOB_OPENED_DATE

WORK_REQUIRED

JOB_STATUS

EMPLOYEE_NAME

CLIENT_NAME

CLIENT_ACCOUNT

ACCOUNT_NUMBER*(PK,FK)

CLIENT_JOB_NUMBER(PK)

HOURLY_CHARGE_RATE

PREFERRED_INVOICE_NAME

INVOICE_ATTENTION_NAME

COMMENCE_DATE

SOLD

SOLD_NUMBER*(PK)

SUPPLIER_ID*(FK)

SELL_PRICE

SELL_TAX

FREIGHT_COST

CLIENT_JOB_NUMBER*(FK)

JOB_DETAIL

JOB_DETAIL_ID(PK)

CLIENT_JOB_NUMBER(FK)

START_DATETIME

END_DATETIME

TOTAL_TIME

CHARGEABLE_TIME

DETAIL_OF_WORK_DONE

PART_TRANSACTION

PART_TRANSACTION_NUMBER(PK)

CLIENT_JOB_NUMBER*(FK)

SALE_PRICE

SERIAL_NUMBER

DESCRIPTION

INVOICE

INVOICE_NUMBER(PK)

CLIENT_JOB_NUMBER*(FK)

INVOICE_DATE

DUE_DATE

TOTAL_AMOUNT

TAX

INVOICE_STATUS

PAID_DATE

CURRENT_SUPPLIER_DETAIL

SUPPLIER_ID*(PK,FK)

PART_ID*(PK,FK)

CUREENT_PART_PARICE

CUREENT_DATE
  1. Supplementary Design requirements: –

BUSINESS_ACCOUNT

Attribute name

Data type

size

Primary key

Foreign key

Relational table

ACCOUNT_NUMBER

INT

30

PK

–

–

ACCOUNT_NAME

VARCHAR

100

–

–

–

TAX

DOUBLE

–

–

–

–

ABN_NUMBER

INT

50

–

–

–

ACCOUNT_STATUS

VARCHAR

40

–

–

–

ACCOUNT_DATE

DATE

–

–

–

–

ACCOUNT_TYPE

VARCHAR

100

–

–

–

CONTACT_PEOPLE

Attribute name

Data type

size

Primary key

Foreign key

Relational table

CONTACT_PEOPLE_ID

INT

10

PK

–

–

ACCOUNT_NUMBER

INT

30

–

FK

BUSINESS_ACCOUNT

CONTACT_DETAIL

Attribute name

Data type

size

Primary key

Foreign key

Relational table

CONTACT_PEOPLE_ID

INT

10

PK

FK

CONTACT_PEOPLE

CONTACT_DETAIL_TYPE

VARCHAR

255

PK

–

–

DETAIL

VARCHAR

255

–

–

–

CONTACT_ADDRESS

Attribute name

Data type

size

Primary key

Foreign key

Relational table

CONTACT_PEOPLE_ID

INT

10

PK

FK

CONTACT_PEOPLE

CONTACT_ADDRESS_TYPE

VARCHAR

255

PK

–

–

DETAIL

VARCHAR

255

—

–

–

BUSINESS_ACCOUNT_CONTACT_DETAIL

Attribute name

Data type

size

Primary key

Foreign key

Relational table

ACCOUNT_NUMBER

INT

30

PK

FK

BUSINESS_ACCOUNT

CONTACT_DETAIL_TYPE

VARCHAR

255

PK

–

–

DETAIL

VARCHAR

255

–

–

–

BUSINESS_ACCOUNT_CONTACT_ADDRESS

Attribute name

Data type

size

Primary key

Foreign key

Relational table

ACCOUNT_NUMBER

INT

30

PK

FK

BUSINESS_ACCOUNT

CONTACT_ADDRESS_TYPE

VARCHAR

255

PK

–

–

DETAIL

VARCHAR

255

–

–

–

PART

Attribute name

Data type

size

Primary key

Foreign key

Relational table

PART_ID

VARCHAR

30

PK

–

–

PART_CATEGORY

VARCHAR

255

–

–

–

MANUFACTURER

VARCHAR

255

–

–

–

DESCRIPTION

VARCHAR

255

–

–

–

CURRENT_PART

VARCHAR

255

–

–

–

SUPPLIERS_DETAIL

Attribute name

Data type

size

Primary key

Foreign key

Relational table

SUPPLIER_ID

VARCHAR

10

PK

–

–

PART_ID

VARCHAR

30

PK

FK

PART

PART_NUMBER

VARCHAR

30

–

–

–

SELL_PRICE

DOUBLE

–

–

–

–

SELL_TAX

DOUBLE

–

–

–

–

SELL_PRICE_DATE

DATE

–

–

–

–

LOCATION

VARCHAR

255

–

–

–

SUPPLIER_ACCOUNT

Attribute name

Data type

size

Primary key

Foreign key

Relational table

ACCOUNT_NUMBER

INT

30

PK

FK

BUSINESS_ACCOUNT

SUPPLIER_ID

VARCHAR

10

–

FK

SUPPLIERS_DETAIL

PURCHASE

Attribute name

Data type

size

Primary key

Foreign key

Relational table

PART_TRANSACTION_ID

INT

10

PK

–

–

PART_ID

VARCHAR

30

–

FK

SUPPLIERS_DETAIL

SUPPLIER_ID

VARCHAR

10

–

FK

SUPPLIERS_DETAIL

PART_SERIAL_NUM

INT

20

–

–

–

SUPPLIER_INVOICE_NUMBER

INT

10

–

–

–

INVOICE_DATE

DATE

–

–

–

–

PART_STATUS

VARCHAR

100

–

–

–

PURCHASE_PRICE

DOUBLE

–

–

–

–

TAX

DOUBLE

–

–

–

–

FREIGHT_COST

DOUBLE

–

–

–

–

CLIENT_JOBS

Attribute name

Data type

size

Primary key

Foreign key

Relational table

CLIENT_JOB_NUMBER

VARCHAR

10

PK

–

–

REFERENCE_NUMBER

INT

–

–

–

–

JOB_OPENED_DATE

DATE

–

–

–

–

WORK_REQUIRED

VARCHAR

255

–

–

–

JOB_STATUS

VARCHAR

100

–

–

–

EMPLOYEE_NAME

VARCHAR

100

–

–

–

CLIENT_NAME

VARCHAR

50

–

–

–

CLIENT_ACCOUNT

Attribute name

Data type

size

Primary key

Foreign key

Relational table

ACCOUNT_NUMBER

INT

30

PK

FK

BUSINESS_DETAIL

CLIENT_JOB_NUMBER

VARCHAR

10

–

FK

CLIENT_JOBS

HOURLY_CHARGE_RATE

DOUBLE

–

–

–

–

PREFERRED_INVOICE_NAME

VARCHAR

255

–

–

–

INVOICE_ATTENTION_NAME

VARCHAR

255

–

–

–

COMMENCE_DATE

DATE

–

–

–

–

SOLD

Attribute name

Data type

size

Primary key

Foreign key

Relational table

SOLD_NUMBER

INT

10

PK

–

–

SUPPLIER_ID

VARCHAR

10

–

FK

SUPPLIERS_DETAIL

SELL_PRICE

DOUBLE

–

–

–

–

SELL_TAX

DOUBLE

–

–

–

–

FREIGHT_COST

DOUBLE

–

–

–

–

CLIENT_JOB_NUMBER

VARCHAR

10

–

–

CLIENTS_JOBS

JOB_DETAIL

Attribute name

Data type

size

Primary key

Foreign key

Relational table

JOB_DETAIL_ID

INT

10

PK

–

–

CLIENT_JOB_NUMBER

VARCHAR

10

–

FK

CLIENT_JOBS

START_DATETIME

DATETIME

–

–

–

–

END_DATETIME

DATETIME

–

–

–

–

TOTAL_TIME

VARCHAR

100

–

–

–

CHARGEABLE_TIME

TIME

–

–

–

–

DETAIL_OF_WORK_DONE

VARCHAR

255

–

–

–

PART_TRANSACTION

Attribute name

Data type

size

Primary key

Foreign key

Relational table

PART_TRANSACTION_NUMBER

INT

20

PK

–

–

CLIENT_JOB_NUMBER

VARCHAR

10

–

FK

CLIENT_JOBS

SALE_PRICE

DOUBLE

–

–

–

–

SERIAL_NUMBER

INT

–

–

–

–

DESCRIPTION

VARCHAR

255

–

–

–

INVOICE

Attribute name

Data type

size

Primary key

Foreign key

Relational table

INVOICE_NUMBER

INT

10

PK

–

–

CLIENT_JOB_NUMBER

VARCHAR

10

–

FK

CLIENT_JOBS

INVOICE_DATE

DATE

–

–

–

–

DUE_DATE

DATE

–

–

–

–

TOTAL_AMOUNT

DOUBLE

–

–

–

–

TAX

DOUBLE

–

–

–

–

INVOICE_STATUS

VARCHAR

100

–

–

–

PAID_DATE

DATE

–

–

–

–

CURRENT_SUPPLIER_DETAIL

Attribute name

Data type

size

Primary key

Foreign key

Relational table

SUPPLIER_ID

VARCHAR

10

PK

FK

SUPPLIERS_DETAIL

PART_ID

VARCHAR

30

PK

FK

SUPPLIERS_DETAIL

CUREENT_PART_PARICE

DOUBLE

–

–

–

–

CUREENT_DATE

DATE

–

–

–

–

 
ASSUMPTION: –

I create database according to the given case study. I just add client name attribute in client jobs table. I used given excel sheet. But excel sheet contains little information according to this case study. So that from excel sheet I take client id, invoice name and account number data.

Chia, K., Seow, E. and Teo, K. (2004). Database. Singapore: Pearson Prentice Hall.

Cronan, J. (2010). Microsoft Office Access 2010. New York: McGraw-Hill.

Eliot, G. (2016). The mill on the Floss. New York: Open Road Integrated Media.

Elmasri, R. and Navathe, S. (2017). Fundamentals of database systems. 1272 Seiten: [Verlag nicht ermittelbar].

Griffith, G., Bradly, T., Long, C., Ranlett, C. and Marshall, K. (2011). Microsoft Access 2010 24-hour trainer. Indianapolis, Ind.: Wrox/Wiley Pub.

Helmers, S. (2015). Microsoft Visio 2013. [Redmond (WA)]: Microsoft Press.

J. Parker, D. (2013). Microsoft Visio 2013 Business Process Diagramming and Validation. Packt Publishing.

Knottingham, E. (2001). How to do everything with Microsoft Visio 2002. Berkeley, Calif.: Osborne/McGraw-Hill.

MacWhinney, B. (2000). The database. Mahwah, NJ [u.a.]: Lawrence Erlbaum.

Munnelly, B. and Holden, P. (2002). ECDL3 for Microsoft Office 95/97. London: Prentice Hall.

O’Leary, T. and O’Leary, L. (2011). Microsoft Access 2010. New York, NY: McGraw-Hill.

Parker, D. (2007). Visualizing information with Microsoft Office Visio 2007. New York: McGraw Hill.

Walker, M. and Eaton, N. (2004). Microsoft Office Visio 2003 inside out. Redmond, Wash.: Microsoft Press.

Wright, A. and Roth, C. (2014). Visio 2013. Indianapolis (IN): Que.

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order
Calculate the price
Pages (275 words)
$0.00
Course Scholars
Company
Legal
How Our Service is Used:
Course Scholars essays are NOT intended to be forwarded as finalized work as it is only strictly meant to be used for research and study purposes. Course Scholars does not endorse or condone any type of plagiarism.
Subscribe
No Spam
© 2025 Course Scholars. All rights reserved.
Course Scholars will be listed as ‘Course Scholars’ on your bank statement.

Order your essay today and save 15% with the discount code GINGER

Order Now