IT403_IT402

Annual Report

FY [Year]

[Add a quote here from one of your company executives or use this space for a brief summary of the document content.]

Integrated Enterprise Systems

IT402

Instructions:

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.

It is your responsibility to check and make sure that you have uploaded both the correct files.

Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets or languages other than English or any kind of manipulation).

Email submission will not be accepted.

You are advised to make your work clear and well-presented. This includes filling your information on the cover page.

You must use this template, failing which will result in zero mark.

You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.

Late submission will result in ZERO mark.

The work should be your own, copying from students or other resources will result in ZERO mark.

  • Use Times New Roman font for all your answers.

Name: ###

CRN: ###

ID: ###

3 Marks

Learning Outcome (1):

Explain the interdisciplinary concepts, theories, and trends in ES and their role in supporting business operations

Question One

A company has been using an old MRP system for many years. Recently, management noticed that the system cannot support financial planning, customer management, or collaboration with suppliers.

Evaluate whether upgrading to MRP II or ERP would better support the companys needs. Justify your recommendation by analyzing the differences in scope, integration level, and organizational impact.

Learning Outcome(4):

Design ES architectural models for various business processes.

2 Marks

Question Two

A manufacturing process produces 40 units per hour, and the average cycle time for each unit is 0.75 hours.

Using Littles Law, determine the average inventory within the process. Then explain how reducing cycle time would affect inventory levels and overall process efficiency.

3 Marks

Learning Outcome(6):

Develop robust business intelligence solutions that provide an integrated framework for improved business processes within a global context.

Question Three

Srvice company receives frequent complaints about delays and inconsistent service quality. Management wants to redesign its processes to improve quality and reduce errors.

Propose a quality improvement strategy using techniques such as Poka-Yoke, statistical process control, and continuous improvement methodologies. Explain how each technique would improve the service process.

Annual Report

FY [Year]

[Add a quote here from one of your company executives or use this space for a brief summary of the document content.]

IT403

Fundamentals of Databases

Instructions:

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.

It is your responsibility to check and make sure that you have uploaded both the correct files.

Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets or languages other than English or any kind of manipulation).

Email submission will not be accepted.

You are advised to make your work clear and well-presented. This includes filling your information on the cover page.

You must use this template, failing which will result in zero mark.

You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.

Late submission will result in ZERO mark.

The work should be your own, copying from students or other resources will result in ZERO mark.

  • Use Times New Roman font for all your answers.

Name: ###

CRN: ###

ID: ###

3 Marks

Learning Outcome(s):

CLO4: Design a database starting from the conceptual design to the implementation of database schemas.

Question One

Reflect on the various types of database users mentioned in Module 1. Choose one type of user (e.g., database administrator, end-user, or designer) and answer the following:

  • Describe their primary responsibilities and interactions with the database management system.
  • Discuss at least two challenges they might face in their role, especially regarding security and data access.
  • Suggest strategies that could be implemented to mitigate these challenges.

Answers:

2 Marks

Learning Outcome(s):

CLO4: Design a database starting from the conceptual design to the implementation of database schemas.

Question Two

What is the best concept that describes each of the following definitions/descriptions?

  • Database description; including details about the database structure, relationships, constraints, and data types.
  • An element of the schema or an object within the schema, such as EMPLOYEE, DEPARTMENT, or SNN.
  • Utilized by the DBA and database architects to define the conceptual schema of a database.
  • Integrates all components into a single computer system, including the DBMS software, application programs, user interface processing software, and hardware.

Answers:

Write only one concept each.

1.

2.

3.

4.

3 Marks

Learning Outcome(s):

CLO4: Design a database starting from the conceptual design to the implementation of database schemas.

Question Three

A company is building an e-commerce web application that serves thousands of customers simultaneously.

  • Which DBMS client-server architecture would you recommend for the proposed application, and why?
  • Identify the role of each tier using the e-commerce scenario.

Answers

WRITE MY PAPER


Leave a Reply