Data Modeling

In: Computers and Technology

Submitted By bakory1
Words 7261
Pages 30
True/False Questions

1. A model is a representation of reality

Answer: True Page: 316 LOD: Easy

2. Logical models show what a system is or does. They are implementation independent.

Answer: True Page: 316 LOD: Easy

3. Logical models show how a system is implemented.

Answer: False Page: 316 LOD: Medium Rationale: Logical models are implementation independent.

4. Physical models show not only what a system is or does, but also how the system is physically and technically implemented. They are implementation independent because they specify the technology.

Answer: False Page: 316 LOD: Medium Rationale: Physical models are implementation dependent (not independent).

5. Logical models show not only what a system is or does, but also how the system is implemented.

Answer: False Page: 316 LOD: Medium Rationale: Physical models show not only what a system is or does, but also how the system is implemented; therefore, they are implementation dependent. Logical models are implementation independent.

6. Process modeling is a technique for organizing and documenting the structure and flow of data through a system's processes and /or the logic, policies and procedures to be implemented by a system's processes.

Answer: True Page: 317 LOD: Easy

7. A data flow diagram (DFD) is a tool that depicts the flow of data through a system and the work or processing performed by that system.

Answer: True Page: 217 LOD: Easy

8. An entity relationship diagram (ERD) is a tool that depicts the flow of data through a system and the work or processing performed by that system.

Answer: False Page: 317 LOD: Medium Rationale: A data flow diagram (DFD) is a tool that depicts the flow of data through a system and the work or processing performed by that system. The…...

Similar Documents

System Modeling

...System Modeling Margaret Francies Strayer University Term Paper System Modeling Theory– CIS 331 Richard Guirguis Due on 12/8/2010 System Modeling Systems modeling or systems modelling is the approach to the study of the use of models to imagine and construct systems in business and IT development. In business and IT development the term "systems modeling" has multiple meaning. System Modeling can refer to analysis and design efforts, simulation and or system dynamics, and a study of the many uses of these models. There are different approaches to modeling: Agent based data and mathematical modeling. Quality management adopts a number of management principles that can be used by top management to guide their organizations towards improved performance. Principles such as: customer focus, leadership, people’s involvement, the process, system approach to management, continual improvement, facts, and a mutual benefit. . Decision making is a reasoning or emotional process which can be rational or irrational. The cognitive perspective is that the decision making process must be regarded as a continuous process integrated in the interaction with the environment. From a normative perspective, the analysis of individual decisions is concerned with the logic of decision making and rationality and the invariant choice it leads to it can be based on explicit assumptions or tacit assumptions. In decision making, objectives must be established and placed in the order......

Words: 662 - Pages: 3

Modeling

...EXCEL MODELING AND ESTIMATION IN CORPORATE FINANCE Third Edition CRAIG W. HOLDEN Max Barney Faculty Fellow and Associate Professor Kelley School of Business Indiana University Copyright © 2008 by Prentice Hall, Inc., Upper Saddle River, New Jersey 07458 To Kathryn, Diana, and Jimmy. Contents iii CONTENTS   Preface ..................................................................................... vii  Third Edition Changes .................................................................................... vii  What Is Unique About This Book ..................................................................... x  Conventions Used In This Book .......................................................................xi  Craig’s Challenge ........................................................................................... xiii  The Excel Modeling and Estimation Series .................................................. xiii  Suggestions for Faculty Members ..................................................................xiv  Acknowledgements ........................................................................................... xv  About The Author ................................................................. xvi  PART 1 TIME VALUE OF MONEY ..... 1  Chapter 1 Single Cash Flow ....................................................1  1.1 Present Value .......................................................................................

Words: 33587 - Pages: 135

Database Modeling

...Database Modeling Tool INF322 Instructor June 27, 2011 Database Modeling Tool The company has grown exponentially over the past 6 months and needs to develop a new database to house its financial, inventory, and client data. It has been decided to build this new database in house rather than purchase a system from a third party vendor. As part of the development of this database it is in the company’s best interest to utilize a database modeling tool to help the design effort. Utilizing a database modeling tool will offer the following benefits: 1. Simple graphic representation of the data structure. 2. Visual work flow of how data will be entered, modified, and reported. 3. Bulk editor capabilities. 4. Database design generator. 5. Database reverse engineering. 6. Logical and physical data model reporting. The tool that looks to be the best fit for the company is CA Erwin Data Modeler r8. CA Erwin Data Modeler r8 was developed by Logic Works Inc. Logic Works Inc. has been in business as a database modeling solution since 1988 (Carreon, 1996) and continues to be one of the top data modeling providers. CA Erwin Data Modeler r8 is the most balanced data modeler tool when comparing functionality, simplicity, and cost when to its competitors. CA Erwin has very user friendly graphical representation of both the logical and physical data models. No other competing modeler has both of these capabilities within the same function. It has all......

Words: 477 - Pages: 2

Database Modeling

...Database Modeling Kelli Clipp Business Systems Analysis INF322 Arman Kanooni February 10, 2013 This paper discusses database modeling and one tool that can be used for the process. The tool I’ve chosen is based on the material in our textbook and article ‘Modeling for the future’. Database modeling is the process of software engineering which allows for the creation of an information system. In the article ‘Modeling for the future’, they compare database modeling to constructing a house (Carreon, Wang, & Watt, 1996). This comparison is based on the fact that one would use a blueprint when building a house and database modeling can be considered as the same concept. A data model is in essence a blueprint or a plan for the database and without it the database may not be very well built, as with any program, house or building you need a plan. There are several tools available for database designers to utilize and the key is choosing the tool which is right to be used that will meet all the requirements of the database to be created. In the article ‘Modeling for the future’ they discussed and compared products from 1996, and although this article appeared to cover the four key products for database modeling at that time, the market has......

Words: 690 - Pages: 3

Best Practices in Data Modeling

...Best Practices in Data Modeling Dan English Objectives • • • • • Understand how QlikView is Different from SQL Understand How QlikView works with(out) a Data Warehouse Not Throw Baby out with the Bathwater Adopt Applicable Data Modeling Best Practices Know Where to Go for More Information QlikView is not SQL (SQL Schemas) SQL take a large schema and queries a subset of tables. Each query creates a temporary “Schema” of only a few tables. Query result sets are independent of each other. Query 1 Query 2 QlikView is not SQL (QV Schemas) QlikView builds a smaller and more reporting friendly schema from the transactional database. This schema is persistent and reacts as a whole to user “queries”. A selection affects the entire schema. QlikView is not SQL (Aggregation and Granularity) Store Table Store A B SqrFootage 1000 800 Sales Table Store A A A B B Prod 1 2 3 1 2 Price $1.25 $0.75 $2.50 $1.25 $0.75 Date 1/1/2006 1/2/2006 1/3/2006 1/4/2006 1/5/2006 Select * From Store, Sales Where Store.Store = Sales.Store will return: SqrFootage 1000 1000 1000 800 800 Store A A A B B Prod 1 2 3 1 2 Price $1.25 $0.75 $2.50 $1.25 $0.75 Date 1/1/2006 1/1/2006 1/1/2006 1/1/2006 1/1/2006 Sum(SqrFootage) will return: 4600 If you want the accurate Sum of SqrFootage in SQL you can not join on the Sales table in the same Query! QlikView is not SQL (Benefits) • QlikView allows you to see the results of a selection across......

Words: 1267 - Pages: 6

Data Modeling

...translate ER models into equivalent (as far as possible) relational models. Marc H. Scholl (DBIS, Uni KN) Information Management Winter 2007/08 48 2. The Entity-Relationship Model Introduction Database design (1) Overall goal of DBMS usage: Efficiently develop programs to support given real-world tasks. These programs need to store data persistently. To develop these programs, apply proven methods of software engineering—specialized to support data-intensive programs. Definition (Database Design) Database Design is the process of developing a database schema for a given application. DB design is a subtask of the overall software engineering effort. Marc H. Scholl (DBIS, Uni KN) Information Management Winter 2007/08 49 2. The Entity-Relationship Model Introduction Database design (2) The specification of programs and data is intertwined: The schema should contain the data needed by the programs. Programs are often easy to develop once the structure of the data to be manipulated has been specified. Data, however, is an independent resource: Typically, additional programs will be developed later based on the collected data. Also, ad-hoc queries will be posed against the DB. Marc H. Scholl (DBIS, Uni KN) Information Management Winter 2007/08 50 2. The Entity-Relationship Model Introduction Database design (3) During DB design, a formal model of the relevant aspects of the real world (“mini world”, “domain of discourse”)......

Words: 7024 - Pages: 29

Modeling of Prediction System: an Application of the Nearest Neighbor Approach to Chaotic Data

...137–148 http://amci.unimap.edu.my © 2013 Institute of Engineering Mathematics, UniMAP Modeling of prediction system: An application of the nearest neighbor approach to chaotic data N. Z. A. Hamida,b,*and M. S. M. Nooranib a Department of Mathematics, Faculty of Science and Mathematics, Universiti Pendidikan Sultan Idris 35900, Tanjung Malim, Perak, Malaysia b School of Mathematical Sciences, Faculty of Science and Technology, Universiti Kebangsaan Malaysia, 43600, Bangi, Selangor, Malaysia Received: 20 February 2012; Revised: 12 February 2013, Accepted: 25 February 2013 Abstract: This paper is about modeling of chaotic systems via nearest neighbor approach. This approach holds the principle that future data can be predicted using past data information. Here, all the past data known as neighbors. There are various prediction models that have been developed through this approach. In this paper, the zeroth-order approximation method (ZOAM) and improved ZOAM, namely the k-nearest neighbor approximation (KNNAM) and weighted distance approximation method (WDAM) were used. In ZOAM, only one nearest neighbor is used to predict future data while KNNAM uses more than one nearest neighbor and WDAM add the distance element for prediction process. These models were used to predict one of the chaotic data, Logistic map. 3008 Logistic map data has been produced, in which the first 3000 data were used to train the model while the rest is used to test the performance of......

Words: 4312 - Pages: 18

Data Modeling

...Started 2 4. ‘Bang for the Buck’ Data Models 2 5. Design Patterns 2 6. Master Data Management (MDM) 2 7. Build your Own 2 8. Generic Data Models 2 9. From the Cradle to the Grave 2 10. Commercial Web Sites 2 11. Vertical Applications 2 Appendix A. Business Rules 2 Appendix B. Glossary of Terms 2 1. Introduction 1.1 Our Approach This book adopts a unique approach which is based on using existing Data Models as the basis for designing new ones to meet specific requirements. We have almost 800 Data Models on our Database Answers Website and they define our starting point – * http://www.databaseanswers.org/data_models/index.htm We have used the Dezign Data Modelling Tool to create most of the Data Models in this book. I chose it because it is powerful, flexible and affordable. Members of the Database Answers Community and people who buy this book can purchase Dezign and benefit from a discount of 25%. In order to gain the benefit of this discount, all you have to do is to send an email to dba_requests@barryw.org with your Database Answers Community ID. We will then send you the order instructions. 1.2 Tutorials We have a number of useful Tutorials on our Website. Here are two of them :- * Data Modelling with two young people visiting Windsor Castle * http://www.databaseanswers.org/tutorial4_data_modelling_dimple_and_toby_visit_windsor_castle/index.htm * Beginner’s Guide to Data Modelling using Dezign – ......

Words: 8108 - Pages: 33

Data Modeling

...Vilnius Gediminas Technical University Jelena Mamčenko Lecture Notes on INFORMATION RESOURCES Part I Introduction to Dta Modeling and MSAccess Code FMITB02004 Course title Information Resourses Course volume 3,0 cr. (4,50 ECTS cr.) Teaching methods (Full-time, daytime studies): Lectures - 16 h per semestre Laboratory works - 32 h per semestre Individual work - 72 h per semester Course aim Understandig of models and system of information resourses. Jelena Mamčenko Introduction to Data Modeling and MSAccess CONTENT 1 Introduction to Data Modeling ............................................................................................................... 5 1.1 Data Modeling Overview ............................................................................................................... 5 1.1.1 Methodology .......................................................................................................................... 6 1.1.2 Data Modeling In the Context of Database Design................................................................ 6 1.1.3 Components of A Data Model................................................................................................ 6 1.1.4 Why is Data Modeling Important? ......................................................................................... 6 1.1.5 Summary ................................................................................................................................ 7 1.2......

Words: 16719 - Pages: 67

Cis 321 Ilab Milestone 4 – Data Modeling Part Ii

...CIS 321 iLab Milestone 4 – Data Modeling Part II Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-321-ilab-milestone-4-data-modeling-part-ii/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 321 iLab Milestone 4 – Data Modeling Part II Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-321-ilab-milestone-4-data-modeling-part-ii/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 321 iLab Milestone 4 – Data Modeling Part II Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-321-ilab-milestone-4-data-modeling-part-ii/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 321 iLab Milestone 4 – Data Modeling Part II Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-321-ilab-milestone-4-data-modeling-part-ii/ For More Courses and Exams use this form (......

Words: 1973 - Pages: 8

Cis 321 Week 4 Data Modeling and Analysis Quiz

...CIS 321 Week 4 Data Modeling and Analysis Quiz Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-321-week-4-data-modeling-analysis-quiz/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 321 Week 4 Data Modeling and Analysis Quiz Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-321-week-4-data-modeling-analysis-quiz/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 321 Week 4 Data Modeling and Analysis Quiz Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-321-week-4-data-modeling-analysis-quiz/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 321 Week 4 Data Modeling and Analysis Quiz Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-321-week-4-data-modeling-analysis-quiz/ For More Courses and Exams use this form (......

Words: 1877 - Pages: 8

Cis 321 Week 5 Process Modeling and Data Modeling Part Ii Quiz

...CIS 321 Week 5 Process Modeling and Data Modeling Part II Quiz Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-321-week-5-process-modeling-data-modeling-part-ii-quiz/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 321 Week 5 Process Modeling and Data Modeling Part II Quiz Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-321-week-5-process-modeling-data-modeling-part-ii-quiz/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 321 Week 5 Process Modeling and Data Modeling Part II Quiz Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-321-week-5-process-modeling-data-modeling-part-ii-quiz/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 321 Week 5 Process Modeling and Data Modeling Part II Quiz Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-32...

Words: 2045 - Pages: 9

Data Modeling and Normalization

...and rank at least five (5) entities that would be required for the development of the data repositories.  4. Specify the components that would be required to hold time-variant data for policy enforcement and training management.  5. Diagram a possible 1:M solution that will hold salary history data, job history, and training history for each employee through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length. 6. Plan each step of the normalization process to ensure the 3NF level of normalization using the selected five (5) entities of the personnel database solution. Document each step of the process and justify your assumptions in the process. 7. Diagram at least five (5) possible entities that will be required to sustain a personnel solution. The diagram should include the following: 1. Dependency diagrams 2. Multivalued dependencies Database Modeling and Normalization Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in this process with consideration of the HR core functions and responsibilities of the client. * Identify Entities A data entity is anything real or abstract about which we want to store data. Entity types fall into five classes: roles, events, locations, tangible things,......

Words: 1567 - Pages: 7

Modeling Data Warehouse

...Discussion Question: 1. When developing a successful data warehouse, what are the most important risks and issues to consider and potentially avoid? Data warehouse projects have many risks. Most of them are also found in other IT projects, but data warehousing risks are more serious because data warehouses are expensive, time-and-resource demanding, large-scale projects. Each risk should be assessed at the inception of the project. When developing a successful data warehouse, it is important to carefully consider various risks and avoid the following issues: • Starting with the wrong sponsorship chain. You need an executive sponsor who has influence over the necessary resources to support and invest in the data warehouse. You also need an executive project driver, someone who has earned the respect of other executives, has a healthy skepticism about technology, and is decisive but flexible. You also need an IS/IT manager to head up the project. • Setting expectations that you cannot meet. You do not want to frustrate executives at the moment of truth. Every data warehousing project has two phases: Phase 1 is the selling phase, in which you internally market the project by selling the benefits to those who have access to needed resources. Phase 2 is the struggle to meet the expectations described in Phase 1. For a mere $1 to $7 million, hopefully, you can deliver. • Engaging in politically naive behavior. Do not simply state that a data warehouse will help managers make......

Words: 2805 - Pages: 12

Art of Modeling

...Source: S. G. Powell and K. R. Baker, 2004. The Art of Modeling with Spreadsheets. New York: Wiley & Sons. Copyright © 2004 by John Wiley & Sons, Inc CHAPTER 1 INTRODUCTION MODELS AND MODELING Modeling is the process of creating a simplified representation of reality and working with this representation in order to understand or control some aspect of the world. While this book is devoted to mathematical models, modeling itself is a ubiquitous human activity. In fact, it seems to be one of just a few fundamental ways in which humans understand the world. As an example, a map is one of the most common models we encounter. Maps are models because they simplify reality by leaving out most geographic details in order to highlight the important features we need. A state road map, for example, shows major roads but not minor ones, gives rough locations of cities but not individual addresses, and so on. The map we choose must be appropriate for the need we have: a long trip home across several states requires a regional map, while a trip across town to find a new doctor’s office requires a detailed street map. In the same way, a good model must be appropriate for the specific uses intended for it. A complex model of the economy is probably not appropriate for pricing an individual product. Likewise, a back-of-the-envelope calculation may be inappropriate for acquiring a multibillion-dollar company. Models take many different forms: mental, visual, physical, mathematical...

Words: 4929 - Pages: 20

Atmosfere d'Italia N.25 SPECIALE Campania II Edizione | Sukhwinder Singh | The Dawn Wall