代做Accounting Information Systems Assignment代写留学生SQL 程序

Accounting Information Systems

Assignment

This assignment consists of 4 questions (2 pages), totaling 100. Instructions to students: Type or hand-write answers on A4-size white papers. Please submit both hard copy and soft copy (see note) by 5.00 p.m., Wednesday, April 10, 2024. Late submissions will not be graded. This is an individual assignment. You are not expected to use ChatGPT for Questions 1 to 3. Note: Upload a soft copy to iSpace, and hand in a hard copy to your course assistant instructor. Only Word or PDF file format is allowed, photos/pictures are NOT accepted. (Hand-written assignment needs to be scanned and saved as a Word or PDF file for the upload).

Q1 BPMN [20 marks]

Read the description of the following sales business process and prepare a corresponding BPMN diagram.

Assume that you are the business analyst in a company (e.g. X) and your company has the following sales process. Upon receiving a new order from a customer, the order is acknowledged, and the customer service team verifies any applicable discounts before generating an invoice. Simultaneously, the warehouse team readies the goods for shipping. Following a review of shipment priorities, the products are sent out for delivery either via express service for high-priority orders or standard delivery for regular orders. Subsequently, the customer is notified of the shipment status for tracking purposes.

Q2 UML [20 marks]

Draw a UML class diagram with multiplexities for each scenario described below.

• Each employee works for one company (which can have 0 employees)

• Each AdministrativeAssistant has one or more supervisors (who can have 0 or more employees)

• Each Company has exactly one BoardOfDirectors (and vice versa)

• Each Office is allocated to zero or more Employees (an Employee can have no office or at most one)

• A Person is boardMember of 0 or more BoardOfDirectors (each BoardOfDirectors has from 3 to 8 Persons)

Q3 SQL [20 marks]

Assume that you are using Microsoft Access with the following two tables.

Table 1 Name: CUSTOMER

CUSTOMER ID | NAME

1, Robert

2, John

3, Peter

Table 2 Name: INVENTORY

INVOICE ID | CUSTOMER ID | AMOUNT

100, 1, $49.95

200, 1, $105.95

300, 2, $400.00

400, 3, $150.00

500, 1, $25.00

Write an SQL statement to produce the following information.

CUSTOMER ID | NAME | TOTAL AMOUNT

1, Robert, $180.90

2, John, $400.00

3, Peter, $150.00

Q4 ChatGPT – Open Question [40 marks]

Galaxy Education Limited is an educational institution. You (Amy Chen) are the course development manager at the institution. The institution wants to develop a course on machine learning. Your boss (David Luo), the CEO of the institution, knows that ChatGPT is very powerful and wonders whether it can used to create the course curriculum. Specifically, you are required to answer the following questions.

1. What is a course curriculum?

2. What is a good course curriculum?

3. Can ChatGPT provide you with a course curriculum under your instructions?

4. If your answer to (3) is positive, write (a) a prompt for inputting into ChatGPT and (b) the output from ChatGPT for a 36-hour course curriculum of machine learning for a university year 3 students majoring in business.

5. If your answer to (3) is positive, write (a) a prompt for inputting into ChatGPT and (b) the output from ChatGPT for a 36-hour course curriculum of machine learning for a university year 3 students majoring in computer science.

6. What other two scenarios you can use ChatGPT?

7. What is the provider name(s) of the ChatGPT you used in this question?