System Design and Development Methodologies

Play an AI-generated podcast conversation about this lesson

What is one of the methodologies or standards adopted by an organisation in systems development?

Six Sigma

COBIT

SSADM (correct)

ISO 9001

What is an industry standard used for data exchange?

PDF

HTML

XML (correct)

JSON

What is a constraint on system design that refers to the number of users to be supported concurrently?

Security

Usability

Performance (correct)

Scalability

What is a design strategy in systems development?

A high-level statement defining how the development of an information system should proceed Signup and view all the answers

What is one of the aspects of design identified by Hoffer et al. (2010)?

Dividing requirements into sets of essential and optional requirements Signup and view all the answers

What is the relationship between analysis and design according to Yeates and Wakefield (2003)?

There is considerable overlap between analysis and design Signup and view all the answers

What is the main difference between the analysis stage and the design stage?

The analysis stage deals with the logical representation of data, while the design stage deals with the physical representation. Signup and view all the answers

What is the result of transforming an entity relationship diagram in the analysis phase?

A physical database table definition. Signup and view all the answers

In the top-down design approach, what is specified first?

The overall control architecture. Signup and view all the answers

What is the primary function of the key fields in the Clothez database?

To link different tables together Signup and view all the answers

What is the purpose of the primary key field in a database?

To uniquely identify each record in a table Signup and view all the answers

What is the advantage of the top-down design approach?

It is more commonly employed because many systems are made from existing modules. Signup and view all the answers

What is the result of transforming a dataflow diagram in the analysis phase?

A structure chart. Signup and view all the answers

What is the difference between primary and foreign keys?

Primary keys are used to uniquely identify each record, while foreign keys are used to link tables Signup and view all the answers

What is the term used to describe the way the different tables in a database are linked to one another?

Relational Signup and view all the answers

In the bottom-up design approach, what is designed first?

The individual modules. Signup and view all the answers

What is the purpose of the Customer_id field in the Clothez database?

To link the customer table to the order table Signup and view all the answers

What is the term used to describe a field with a unique code for each record?

Key field Signup and view all the answers

What is the main objective of the designer of an enterprise application?

To deliver access to effective, integrated applications and data across the company Signup and view all the answers

What is a common result of decentralization or poorly controlled investment in information systems?

Applications silos or islands of information Signup and view all the answers

What is an example of a limitation of applications silos?

Inability to access the status of a job in the manufacturing unit Signup and view all the answers

What is a characteristic of applications silos?

Different technology architectures or hardware used in different functional areas Signup and view all the answers

Why do different departmental managers select different systems from different vendors?

Due to decentralization or poorly controlled investment in information systems Signup and view all the answers

What is the primary goal of managing a business applications infrastructure?

To deliver access to effective, integrated applications and data across the company Signup and view all the answers

What is the primary purpose of field validation rules in database design?

To ensure the user has entered valid data Signup and view all the answers

What is the main benefit of data normalization in database design?

To group data items into simple and easily understandable structures Signup and view all the answers

What is the term for the process of defining the characteristics of a field in a database?

Defining field data types and sizes Signup and view all the answers

What is the primary reason for minimizing data duplication in database design?

To reduce the amount of storage required Signup and view all the answers

What is the purpose of specifying a field data size in database design?

To specify the number of digits or characters required Signup and view all the answers

What is the benefit of using a specialized data type, such as currency, in database design?

It ensures that the data is always valid and consistent Signup and view all the answers