|
Title: Discuss Enterprise Resource Planning systems, and contrast these to data warehouses. What will be ... Post by: nmar on Mar 15, 2018 Discuss Enterprise Resource Planning systems, and contrast these to data warehouses.
What will be an ideal response? Q. 2 The following two SQL statements will produce different results. Select last_name, first_name from customer where state = 'MA' or state = 'NY' or state = 'NJ' or state = 'NH' or state = 'CT';Select last_name, first_name from customer where state in ('MA','NY','NJ','NH','CT'); Indicate whether the statement is true or false Q. 3 Discuss how to map a unary one-to-many relationship. What will be an ideal response? Q. 4 Which of the following is a global network that uses universal standards to connect millions of different networks around the world? A) An extranet B) The World Wide Web C) The Internet D) An intranet E) Verizon Q. 5 The support activities of a firm include: A) inbound logistics, technology, outbound logistics, sales and marketing, and service. B) inbound logistics, organization infrastructure, outbound logistics, technology, and procurement. C) organization infrastructure, human resources, sales and marketing, and technology. D) organization infrastructure, human resources, technology, and procurement. E) sales and marketing, procurement, human resources, and technology. Q. 6 Discuss why alternative IS development approaches have evolved, and provide an overview of a couple of these methodologies. What will be an ideal response? Q. 7 A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype. A) disjoint B) overlap C) completeness D) weak Q. 8 Even with XML, different types of devices will require a different page. Indicate whether the statement is true or false Title: Discuss Enterprise Resource Planning systems, and contrast these to data warehouses. What will be ... Post by: transfer on Mar 15, 2018 An ERP system integrates all functions of the enterprise. ERP systems provide the data necessary for an organization to manage all of its data. While ERP systems rely on operational data, data warehouses are designed to use summarized, historical data and are used more in the role of decision support. FALSE A unary relationship has only one entity type, and this entity type will become a relation in the conversion process. As with any relation, the identifier of the relation will become the primary key and the other attributes of the entity type will become other attributes of the relation. We next add a foreign key attribute, which maps back to the primary key. This is called a recursive foreign key. For example, if we had a relation such as a person supervising one or more persons, the PersonID would be a primary key. In addition, the relation would have a foreign key SupervisorID, which points back to PersonID. C D The SDLC is often criticized for being too long from the time of system start until a finished product is delivered. As such, organizations have begun to adopt rapid application development techniques. One technique is prototyping, where a system is designed as a prototype, given to the user for testing and then corrected as needed. This is an iterative process. Another methodology is Agile software development, which focuses more on people than processes. C FALSE Title: Discuss Enterprise Resource Planning systems, and contrast these to data warehouses. What will be ... Post by: nmar on Mar 15, 2018 Thank you for taking the time to explain this, just got my quiz back: Perfect
|