Management Informational System

Answer Review questions 2, 3, 5, 7, 8, 10, 13, 16, 18, & 22 in your own words. First, create verb aloney the questions, and then answer with proper explanation. 1. Define the term selective in categoryationbase. How is it different from a informationbase management system? Database is simply a collection of information. A database helps and provides managers and determination making people with timely and relevant information that leads the fraternity to organisational success. A database management system is totally different than regular database. A (DBMS) is a group of programs that manipulates the database. . What is the pecking order of data in a database? The hierarchy of data in a database is bits, records, files, database, fields, and characters. 3. What is the purpose of a primary come across? How is it white plagueful in controlling data redundancy? The purpose of a primary key is identifying records and make real they can be accessed and organized. It makes sure t hat each record in a file is crotchety therefore, no two files can dumbfound the same information. 4. What are the advantages of the database approach everyplace the conventional approach to database management?Most companies use database approach more(prenominal) over the traditional approach because it allows them the ability to make out data and information. It allows them to share a pool of data with multiple different types of information systems. 5. What is data modeling? What is its purpose? Briefly describe three commonly apply data models. Data modeling is an approach to modeling organizational objects and associations that mesh both text and graphics. To come up with a solution to a problem after the company has gathered and analyzed information. Enterprise data modeling investigate data and information needs of the organization * Entity- kin diagrams uses in writing(p) symbols to show the organization of and relationship between data * Data model diagram of ent ities and their relationships 6. What is a database strategy, and what is its purpose? A database schema is a explanation including the logical and physical structure of the data and the relationship among the data. The purpose of database schema is to define the tables and other database associated with a user. 7.What is the difference between a data definition language (DDL) and a data manipulation language (DML)? DDL is a touch on of instruction manual and commands used to define and describe data and relationships in a unique(predicate) database. DML is a language that allows user to access and condition the data, to make queries, and to generate reports. 8. What is a data store, and how is it different from a traditional database used to support OLTP? A data warehouse holds all of the headache information such as the processes, products, and customers of a company.It was designed to help with ending making for management and also stores historical data from operational systems and outer sources. Data warehouse is more advanced and complex compared to using a traditional database. 9. What is the relationship between the Internet and database? The Internet transmits data from unity computer to another and database is a collection of organized data. 10. What is omenive analysis, and how does it help bloodlinees in gaining competitive advantage?Predictive analysis is a form of data mining that combines historical data with assumptions about proximo conditions to predict outcomes of events. It helps them find new market segments that could be profitable for their businesses. PART II Fill in the Blanks with appropriate words 1. A(n) Database Administrator is a technical and trained IS professional who directs all activities related to an organizations database, including providing gage from intruders. 2. A(n) Character is a basic building block of information, consisting of uppercase letters, lower-case letter letters, numeric digits, or special symbols. . A(n) Entity is a generalized class of people, places, or things for which data is collected, stored, and maintained. 4. A(n) Primary Key is a field or set of fields that uniquely identifies the record. 5. A(n) Data Model is a diagram of entities and their relationships. 6. A(n) comparative Model database model that describes data in which all data elements are placed in two-dimensional tables, called relations, which are the logical equivalent of files. 7. A(n) straightaway file is a simple database program whose records fuddle no relationship to one another. 8.A(n) Data Definition Language (DDL) is a collection of instructions and commands used to define and describe data and relationships in a specific database. 9. A(n) Data Administrator is responsible for defining and implementing consistent principles for a revolution of data issues, including setting data standards and data definitions that apply across all the databases in an organization. 10. A(n) Data Wareho use is a database that holds business information from more sources in the enterprise, covering all aspects of the companys processes, products, and customers. 1. A(n) Data grocery is a subset of a data warehouse. 12. Data Mining is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse. 13. Predictive Analysis is a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events, such as future product sales or the probability that a customer will default on a loan. PART III Case 1 Managing International Trades with Powerful Database Systems Discussions questions 1.What unique challenges do databases that deal with financial markets face? They use the database to fuel business intelligence tools to allow it to process data. The company maintains a data warehouse on which it runs queries. 2. How does Internaxx separate data in its database for annual reports from the data that fuels real-time analytics? Inernaxx data warehouse provides data that gives out the annual reports that are updated frequently. Whereas, the useful databases that feed into the warehouse provides it with the real-time information.Critical thinking questions 1. In what ways does Internaxx use its database to provide the company with a competitive advantage? The Internaxx database fuels both keen investment decision-making for Intenaxx customers and wise business decision-making for Internaxx executives. It uses it database to fuel business intelligence and the company maintains the data in the warehouse. This insight helps to make a competitive advantage. Their database allows consumers to memorize the rise and fall assembly line prices and market conditions. . What unique capabilities must the Internaxx database have in order to support trading in 15 stock exchanges most the world? They must deal with a numerous center of data and the data collected by Internaxx originates from the many trading operations carried out by its customers. The company needs to make sure they have reliable network connection to make sure the exchanges are expeditious and happen. Internaxx must have both a e-commerce and m-commerce to accomplish all of these exchanges around the world.