midterm 2: coursework

Some organizations consider custom development the best way to create a new system. What is a compelling reason for choosing custom development?

the business need is particular

Organizations adopt packaged software as it makes little sense to reinvent the wheel when addressing everyday business needs. What is an advantage of packaged software?

it takes less time to deploy a packaged system than build one

System integration consists of building new systems by combining existing systems. What is a major challenge in systems integration?

use the data produced by one system in another system

Outsourcing is the approach to building a system that requires the least in-house resources. What is outsourcing?

hiring an external entity to build the system

The CTO of an energy provider company in Texas decides to implement a new system to manage the power grid as part of a bigger modernization project. Commercially available solutions are not an option, and the company does not have the technical expertise to construct the system. What approach should the CTO follow to build the new system?

outsourcing

class engagement 5

class engagement 5

relationship between Patient and Appointment?

1.1 > 0.*

(one to many)

relationship between HOD and Department

1.1 > 1.*

(one to many)

relationship between Department and Subordinate

HINT: must make the ERD diagram one to many from department and from subordinate to a shared table

many to many

relationship between Manufacturer and Car

1.1 > 0.*

(one to many)

relationship between Car and Sale

1.1 > 0.*

(one to many)

relationship between Buyer and Sale

1.1 > 1.*

(one to many)

relationship between Researcher and Research Article

many to many

study guide sample questions

study guide sample quuestions

What does the department_id attribute in the entity Assigment represent?

A foreign key that allows the assignment of a subordinate with a department.

A foreign key that allows the association of any subordinate with only one department.

A foreign key that allows the association of a department with many HODs.

A foreign key that allows multiple associations between a subordinate and a department at different times.

HINT: assignment vs association?

A foreign key that allows the assignment of a subordinate with a department.

• As patient owners pay the bills, the system must store their details: unique ID, name, address (composed of a street address, suburb, city, and postcode), home phone, and business phone. 

• Every effort is made to recognize animal patients on return visits and use the same patient number, even though the owner may vary over time. Varying ownership is not rare since the clinic also provides pet adoption services.

How would you describe the relationship between animal patients and patient owners?

Many-to-many

One-to-one

One-to-many

Zero-to-many

many to many