MIS 3353 Exam II Quizzes

Happy Snarl Pet Products company typically sells 15 ten-pound bags of Swellkibble Dog Food each day. It takes about three weeks from the time an order is placed for ten-pound bags of Swellkibble Dog Food until those bags arrive at the store and are available for sale. Given this, which of the following would be the most reasonable ReorderPoint value for Happy Snarl to enter into the Product table instance for ten-pound bags of Swellkibble Dog Food, given that the company would prefer to never be out of stock of this item? 275 60 350 35 45

350

Which of the following terms represents a customer receiving a 5% discount if paying within 12 days of receiving an invoice, while invoices are considered due within 80 days of receipt? 5/12Net80 12/5Net80 80Net12/5 80Net5/12

5/12Net80

To which of the following companies would the production cycle almost certainly apply? (Mark any/all that apply.) A charity that cuts hand-made "snowflakes" out of paper, then sells them at auction. A company that uses logs, ink, and resin to manufacture baseball bats. A kennel that specializes in boarding out-of-control pets. A law firm specializing in bird law.

A charity that cuts hand-made "snowflakes" out of paper, then sells them at auction A company that uses logos, ink, and resin to manufacture baseball bats

Which of the following best describes the difference between a purchase requisition and a purchase order? A purchase requisition is created by a line manager, while the purchase order is an official order placed by that manager's supervisor. A purchase requisition is an input, while a purchase order is an output. A purchase requisition is an initial request placed by the business unit, while a purchase order reflects an actual order placed by purchasing. A purchase requisition is made by the company's customer, while a purchase order is placed by the company and sent to a vendor. A purchase requisition is an initial request from the vendor, while a purchase order is the placement of a formal, actionable order.

A purchase requisition is an initial request placed by the business unit, while a purchase order reflects an actual order placed by purchasing

Which of the following is true regarding inputs, processes, and outputs? A vendor's invoice is an input, a SQL query is a process, and a sales invoice is an output. An invoice is never an input, software performs processes, and reports are always only outputs. A product is an input, manufacturing is a process, and a sale is an output. A sale is an input, manufacturing is a process, and a product is an output.

A vendor's invoice is an input, a SQL query is a process, and a sales invoice is an output

It would make sense to consider creating a super-type/sub-type relationship when... Several reference tables might otherwise be necessary. An entity's instances share some, but not all, attributes. An entity contains multiple composite attributes. Instances within an entity have no relationships with each other.

An entity's instances share some, but not all, attributes

According to the default expenditure cycle ERD, an instance of POLine can relate to many instances of PReqLine. This means... A purchase order can be related to no PReqLine instances. A PReqLine instance does not need to be associated with any POLine. A single purchase requisition can become part of two or more POs. An instance of purchase order line can include lines from several different purchase requisitions.

An instance of purchase order line can include lines from several different purchase requisitions

Choose the best answer. A report that details, in 30-day increments, the outstanding payments owed to a company is... An output. An invoice report. An open invoice. An amortization statement. A threat exposure.

An output

An entity that contains attributes specific to the relationship between instances within one or more entity(-ies) is called a(n)... (Select any/all that apply.) Connecting entity Intersectional entity Indirect entity Associative entity

Associative entity

A property or characteristic of an entity type that is of interest to the organization is called a(n): Functional value Cross-functional value Coexisting entity Relationship Attribute

Attribute

An attribute for which an instance's value can only be one or zero is called a(n)... Binary Attribute Kill Switch Alternating Attribute Bipolar Attribute Derived Attribute

Binary attribute

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity Limit Degree Counter constraint Cardinality constraint

Cardinality constraint

An attribute that can be broken down into smaller parts is called a(n) ________ attribute Composite Complex Simple Associative

Composite

Which of the following are included in the receiving report? (Mark any/all that apply.) Date of Receipt Purchase Requisition Number Bill of Materials PO Number Referenced Supplier's Invoice Identity of the Supplier

Date of receipt PO number referenced Identity of the supplier

The number of entities that participate in a relationship is called the _____. Counter Entquant Degree Number Identifying characteristic

Degree

The total quiz points for a student for an entire semester would most likely be an example of a(n) ________ attribute Mixed Addressed Stored Derived

Derived

Customers, cars, and parts would most likely be examples of which one of the following? Relationships Entities Cardinalities Attributes

Entities

The relationship between a weak entity type and its owner is a form of which one of the following? Submissive relationship Member chain Chain link Identifying relationship Jump path

Identifying relationship

UPS, FedEx, and the US Postal Service would most reasonably be... Instances in the Carrier entity. Attributes in the ShipmentOut entity. Threats against which the segregation of duties controls. Considered part of a cycle other than the revenue cycle.

Instances in the Carrier entity.

Which documents are matched in the three-way matching process? Bill of Lading, Bill of Materials, Bill of Rights Purchase Order, Purchase Order Line, Product Purchase Requisition, Purchase Order, Receiving Report Invoice, Receiving Report, Purchase Order Invoice, Bill of Materials, Purchase Order

Invoice, Receiving Report, Purchase Order

Choose the best answer. The bill of materials... Is like an invoice received for raw materials purchases. Is analogous to the Sales Order in the revenue cycle. Performs an important role cash disbursement. Is a control for the mis-production of products.

Is a control for the mis-production of products

Recording each customer's assigned credit limit in the database... Is a form of control. Is a required part of the revenue cycle. Can result in system failure. Is an example of a data process.

Is a form of control

An attribute included in the super-type... Is an affront to civil society. Is inherited by each of the sub-types. Cannot be shared among the sub-types. Cannot be null.

Is inherited by each of the sub-types

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship. One-to-many Strong Many-to-many One-to-one

Many-to-many

Which of the following would be considered a "threat" to an organization? (Mark any/all that apply.) Meteor striking the production facility Putting locks on warehouse doors Paying the same invoice multiple times Inconsistent quality of manufactured products

Meteor striking the production facility Paying the same invoice multiple times Inconsistent quality of manufactured products

When combining the default revenue cycle and expenditure cycle ERDs... Many of the cardinalities will need to be changed. Hilarity is bound to ensue. The company needs to decide whether to use the attributes from the revenue cycle ERD or the attributes from the expenditure cycle ERD. None of the other answers is correct. It is important to keep the Products entity from the revenue cycle separate from the Products entity from the expenditure cycle.

None of the other answers is correct

The default expenditure cycle ERD shows an optional-one cardinality in the relationship between Employee and PReqLine. This is important, because... Otherwise all employees would have to approve a PReqLine to be in the database. Otherwise a purchase order could be placed without having been approved. Otherwise only unapproved PReqLines would become purchase orders. Correct! Otherwise a PReqLine instance could not be stored in the database before having been approved by purchasing.

Otherwise a PReqLine instance could not be stored in the database before having been approved by purchasing

The default expenditure cycle ERD shows an optional-one cardinality in the relationship between DeliveryIn and PaymentOut. Why is this important? Otherwise payment could not be made on a delivery that was not yet made. Otherwise there could be no record of a delivery prior to the company having paid for the delivery. Otherwise there is insufficient control against the threat of inventory theft. Otherwise the company might pay for the same delivery multiple times.

Otherwise there could be no record of a delivery prior to the company having paid for the delivery

If I... 1. Had a super-type of Personnel with sub-types Volunteer, Donor, and Employee; 2. Was okay with having people in my Personnel table about whom I wasn't sure their role in the organization; and 3. Was okay with, employees volunteering for events, volunteers making donations, and donors also being employees. What constraints would I want to place on my super-type/sub-type relationship? Total Specialization Rule, Overlap Rule Total Specialization Rule, Disjoint Rule None of the other options are correct. Partial Specialization Rule, Overlap Rule Partial Specialization Rule, Disjoint Rule

Partial specialization rule, overlap rule

Who is ultimately responsible for vetting and approving vendors? Purchasing Accounts Receivable Cashier The business unit requesting purchases Accounts Payable

Purchasing

The disjoint rule and the overlap rule... Refer to whether instances of a super-type are required to be part of a sub-type. Refer to whether an instance can belong to multiple sub-types or not. Can coexist within the same super-type/sub-type relationship. Can be swapped out for a completeness constraint at any given time. Refer to the number of sub-types that can exist within an EERD.

Refer to whether an instance can belong to multiple sub-types or not

Threat exposure... Reflects a combination of both the magnitude and probability of a threat. Is an important consideration for publicly-traded companies, but not important to non-profits. Can be eliminated through the use of databases. Is mitigated through avoidance strategies.

Reflects a combination of both magnitude and probability of a threat

In the conceptual design context, the common types of entities are... (Select any/all that apply.) Strong entities Weak entities Associative entities Ambivalent entities

Strong entities Weak entities Associative entities

The attribute within the super-type entity that is used to specify the sub-type(s) to which an instance belongs is called what? Type Indicator Super-Type Determiner Sub-Type Indicator Type Delimiter Sub-Type Discriminator

Sub-type discriminator

It turns out that the marketing department wants to spend $100,000 buying local radio advertising. Who would most likely complete the purchase req for this? The vendor (i.e., the radio station) from whom the advertising is being purchased. No one; purchase requisitions are only for purchase of goods (not services). The advertising agency that works with the marketing department. The marketing manager in charge of advertising. The purchasing department, after consulting with the marketing department.

The marketing manager in charge of advertising

In the default revenue cycle ERD, why are there three different relationships between Employee and ShipmentOut? The three lines enables the "segregation of duties" among the picking, packing, and shipping activities. To ensure that each package is inspected at three different point of time. One represents the original order being placed, another the order being shipped, and the third represents the order being received. One for each threat that the shipping process poses to the company.

The three lines enables the ''segregation of duties" among the picking, packing, and shipping activities

As a part of their regular manufacturing process, a company frequently pre-assembles parts, then stores these pre-made assemblies in inventory until they are used, later, to make finished products. Which of the following is true of the ERD that is needed to model and track this? (Mark any/all that apply.) A separate entity should be created exclusively for the use of storing inventory information about raw materials that will be used to make other raw materials. There should be a raw materials bill of materials entity with two relationships between itself and the raw materials entity. Each line of the raw materials bill of materials entity includes information about the finished product and the product's cost. There should be at least two relationships between the raw material and bill of materials entities. There should be a raw materials entity with an attribute indicating whether a raw material is made out of other raw materials.

There should be a raw materials bill of materials entity with two relationships between itself and the raw materials entity

In the relationship between <SalesOrderLine> and ShipmentOut, why is the one-side cardinality optional-one rather than mandatory-one? This allows a sales order to exist without it having been shipped yet. This allows a sales order line to exist without it having been picked yet. This allows a shipment to exist regardless of whether there's a sales order line instance. This allows for partial shipment of an order.

This allows a sales order to exist without it having been shipped yet

Regarding completeness constraints... Total specialization means each instance of the super-type must belong to at least one sub-type. Partial specialization means that instances of the super-type can be part of multiple sub-types. The total specialization rule is shown in the EERD by including a t within the circle. The partial specialization rule is shown in the EERD by two vertical lines between the super-type and the circle.

Total specialization means each instance of the super-type belong to at least one sub-type

Suppose that a given raw material can be supplied by many vendors and that a single vendor can supply many raw materials. Also suppose that each vendor that supplies a raw material does so at a unique price (i.e., not all vendors charge the same price for the same raw material). Given this, in what default production cycle ERD entity would you expect to find a specific vendor's price charged for a specific raw material? BillOfMaterials Product VendorRM RawMaterial Vendor

VendorRM

An entity type whose existence depends on another entity type is called a ________ entity Social Weak Codependent Strong Variant

Weak

Under the _____ _____ method of invoicing, all orders delivered within a given month are invoiced on a single invoice at the end of the month. balance forward open invoice net terms cash accounting

balance forward