Q&A Hero

Q: In IDEF1X, extended E-R model weak, but non-ID-dependent relationships are called ________. A) identifying connection relationships B) nonspecific relationships C) category clusters D) There is no equivalent IDEF1X term.

Q: In IDEF1X, extended E-R model ID-dependent relationships are called ________. A) nonidentifying connection relationships B) identifying connection relationships C) nonspecific relationships D) category clusters

Q: In IDEF1X, extended E-R model N:M relationships are called ________. A) nonidentifying connection relationships B) identifying connection relationships C) nonspecific relationships D) category clusters

Q: In IDEF1X, extended E-R model 1:N relationships are called ________. A) nonidentifying connection relationships B) identifying connection relationships C) nonspecific relationships D) category clusters

Q: In IDEF1X, extended E-R model 1:1 relationships are called ________. A) nonidentifying connection relationships B) identifying connection relationships C) nonspecific relationships D) category clusters

Q: IDEFIX domains are numbered sets of values.

Q: IDEF1X category clusters may be either complete or incomplete.

Q: IDEF1X category entities are mutually exclusive within a cluster.

Q: IDEF1X categories are put into a cluster.

Q: A categorization relationship is an IS-A relationship.

Q: The IDEF1X standard excludes the concept of domains found in the extended E-R model.

Q: The IDEF1X equivalent of the extended E-R model subtype is the category entity, and category entities are placed in categorization clusters.

Q: The IDEF1X default cardinality of a nonidentifying connection relationship is indicated by a dashed line with a filled-in circle by the child and no other notation.

Q: The IDEF1X default cardinality of a nonidentifying connection relationship is one-to-one, with a mandatory parent and an optional child.

Q: IDEF1X identifying connection relationships correspond to ID-dependent relationships in the extended E-R model.

Q: IDEF1X nonspecific relationships correspond to N:M relationships in the extended E-R model.

Q: Extended E-R model weak, but non-ID-dependent relationships are called nonidentifying connection relationships in IDEF1X.

Q: Extended E-R model N:M relationships are called nonidentifying connection relationships in IDEF1X.

Q: Extended E-R model 1:N relationships are called identifying connection relationships in IDEF1X.

Q: Extended E-R model 1:1 relationships are called nonidentifying connection relationships in IDEF1X.

Q: IDEF1X entities are the same as the entities in the extended E-R model.

Q: What activities take place during the component design step of the systems development life cycle (SDLC)?

Q: What are the five steps or stages of the systems development life cycle (SDLC)?

Q: How does Michael Porter define support business activities? What do they include?

Q: How does Michael Porter define primary or operational business activities? What do they include?

Q: Briefly define and discuss what an information system is, the five components that comprise an information system, and what the purpose of an information system is.

Q: Which of the following does a Statement of work (SOW) typically not contain? A) Non-functional requirements (speed and time, capacity and reliability) B) An identification of who will do the work C) The objectives of the work to be done D) The location of where the work will be done

Q: Which of the following does a User Requirements Document (URD) typically NOT contain? A) A data model B) Functional requirements C) The scope of the work to be done D) Project delivery requirements

Q: The system is updated with patches, service packs and new software releases during the ________ step of the SDLC. A) requirements analysis B) component design C) implementation D) systems maintenance

Q: People are hired (if necessary) and trained during the ________ step of the SDLC. A) system definition B) requirements analysis C) component design D) implementation

Q: Hardware is installed and tested during the ________ step of the SDLC. A) requirements analysis B) component design C) implementation D) systems maintenance

Q: Hardware specifications are determined during the ________ step of the SDLC. A) system definition B) requirements analysis C) component design D) implementation

Q: Databases are created in a DBMS during the ________ step of the SDLC. A) system definition B) requirements analysis C) component design D) implementation

Q: Database designs are created during the ________ step of the SDLC. A) system definition B) requirements analysis C) component design D) implementation

Q: Data models are created during the ________ step of the SDLC. A) system definition B) requirements analysis C) component design D) implementation

Q: A deliverable from the requirements analysis step is a ________. A) user requirements document (URD) B) user requirements statement (URS) C) statement of work (SOW) D) A and sometimes C

Q: User interviews are conducted during the ________ step of the SDLC. A) system definition B) requirements analysis C) component design D) implementation

Q: The classic systems analysis methodology is called the ________. A) Systems Development Life Cycle (SDLC) B) Analysis Development Life Cycle (ADLC) C) Component Development Life Cycle (CDLC) D) Information Development Life Cycle (IDLC)

Q: Which of the following is not included in Michael Porter's list of support activities? A) Technology management B) Customer service C) Human resources management D) Firm infrastructure management

Q: Which of the following is not included in Michael Porter's list of primary or operational activities? A) Procurement B) Inbound logistics C) Manufacturing operations D) Outbound logistics

Q: Which of the following is not a component of a computer-based information system? A) Hardware B) Software C) The inventory in the warehouse D) Data

Q: Which of the following is not a definition of information? A) Data presented in a meaningful context B) Knowledge derived from data C) Data processed by summing, ordering, averaging, grouping, comparing or other similar operations D) A list of facts

Q: Data is composed of ________. A) facts B) numbers C) information D) Both A and B are correct

Q: Databases are created in a DBMS during the implementation step.

Q: Database designs are created during the component design step.

Q: Data models are created during the component design step.

Q: One deliverable from the requirements analysis step is a statement of requirements (SOR).

Q: User interviews are conducted during the requirements analysis step.

Q: The classic systems analysis methodology is called the Analysis Development Life Cycle (ADLC).

Q: Systems analysis and design is the process of creating and maintaining information systems.

Q: Information systems are used to support business processes.

Q: A business process is a set of activities that transforms materials into products.

Q: Michael Porter includes manufacturing operations in his list of primary activities.

Q: Information systems must be both developed and used to help businesses reach their goals and objectives.

Q: A computer-based information system has four components.

Q: An information system is a set of components that interact to achieve some purpose or goal.

Q: One definition of information is knowledge derived from data.

Q: Data is facts and numbers.

Q: Explain how to run an SQL query in Microsoft Access.

Q: Explain how to create a relationship in Microsoft Access. Include an example.

Q: What is a surrogate key and how does Microsoft Access 2013 create surrogate keys?

Q: Describe the Microsoft Access 2013 Navigation Pane.

Q: Describe the tabbed Ribbon.

Q: What is the Microsoft Office Fluent User Interface?

Q: What Microsoft Access file format is used by default in Microsoft Access 2013? When was it introduced, and what was the previous format?

Q: Microsoft Access is considered a "personal database" product. What is a personal database?

Q: Microsoft Access Datasheet view can be used for all of the following tasks except ________. A) writing join queries B) inserting new rows C) updating existing rows D) deleting rows

Q: Each of the following is a way of inserting data into a Microsoft Access table except ________. A) Datasheet view B) a data entry form C) QBE D) SQL

Q: Data in columns defined using which of the following data types in Microsoft Access cannot be changed by the user? A) Long Text B) Date/Time C) Number D) AutoNumber

Q: In Microsoft Access 2013, the maximum length in characters of a "Short Text" data type column is ________. A) 25 B) 255 C) 65535 D) unlimited

Q: Tables are created in Microsoft Access using the ________ button. A) Table Design B) Table Wizard C) Create Table D) Create Relation

Q: Microsoft Access is a good tool for forms and reports because ________. A) the form and report generators do not exist within Access itself B) Access forms and reports are very simplistic C) Access wizards make it easy to create the forms and reports D) Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows

Q: In Microsoft Access, tables are added to a Query window by ________. A) selecting the tables from the Use Table dialog box B) selecting the tables from the Show Table dialog box C) selecting the tables from the Tables section of the Navigation Pane D) selecting the tables from the Queries section of the Navigation Pane

Q: To open a new Microsoft Access Query window ________. A) click the New button on the Home command tab B) click the New Query button on the Home command tab C) click the Create Query button on the Create command tab D) click the Query Design button on the Command tab

Q: Microsoft Access SQL commands are run in ________. A) the SQL window B) the QBE window C) the SQL View of a Query window D) the Design View of a Query window

Q: In Microsoft Access, the relationship between two tables is not actually created until ________. A) the OK button in the Create Relationships dialog box is clicked B) the Create button in the Create Relationships dialog box is clicked C) the OK button in the Edit Relationships dialog box is clicked D) the Create button in the Edit Relationships dialog box is clicked

Q: In Microsoft Access, referential integrity constraints are created ________. A) by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box B) by setting a property value on the foreign key in the table which contains it C) by setting a property value on the primary key in the Relationships window D) by setting a property value on the foreign key in the Relationships window.

Q: In Microsoft Access, any relationship between two tables is created ________. A) by entering the name of the foreign key in the appropriate table in Design View B) by dragging the primary key column of one table onto the primary key column of the other table in the Relationships window C) by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window D) by dragging the foreign key column of one table onto the primary key column of the other table in the Relationships window

Q: In Microsoft Access, relationships between tables are created ________. A) by the Relationships button on the Create command tab B) by the Relationships button on the Home command tab C) in the Relationships window D) in the Table window of the table containing the primary key

Q: The Microsoft Access 2013 Close button is actually a ________. A) Save and Close button B) Save and Exit button C) Close and Exit button D) Print and Close button