Chapter 7 Managerial Overview: Database Management Outline 1. Foundation Da

 www.phwiki.com

 

The Above Picture is Related Image of Another Journal

 

Chapter 7 Managerial Overview: Database Management Outline 1. Foundation Da

Arizona State University, US has reference to this Academic Journal, Chapter 7 Managerial Overview: Database Management Outline 1. Foundation Data Concepts 2. The Database Management Approach 3. Use of Database Software in the Business Environment 4. Types of Databases 5. Data Resource Management Foundation Data Concepts How Data is Organized in Information Systems: Character – Most basic element of data, consists of a single alphabetic, numeric, or other symbol. Field – Consists of a grouping of characters. Record – Consists of a grouping of related fields of data. File – Consists of a grouping of related records. Database – Consists of a grouping of related files.

 Chen, Ted Arizona State University www.phwiki.com

 

Related University That Contributed for this Journal are Acknowledged in the above Image

 

Database Management Approach The Database Management Approach consolidates data records in addition to objects into databases that can be accessed by many different application programs. This Approach Involves Three Basic Activities: 1. Updating in addition to Maintaining Common Databases 2. Sharing the Data in Common Databases 3. Providing an Inquiry/Response in addition to Reporting Capability The Use Of Database Software A software package that uses this approach is the Database Management System(DBMS), which serves as a software interface between users in addition to databases. The Four Major Uses of a DBMS Package are: 1. Database Development – Microsoft Access which allow end users so that easily develop the databases they need. 2. Database Interrogation – Provides a response so that questions from a database. 3. Database Maintenance – Updates continually so that reflect new business transactions in addition to other events. 4. Application Development – Develop custom application programs. Data Resource Management Benefits of Database Management: Limitations of Database Management: 1. Reduces duplication of data 1. Difficult in addition to expensive so that install 2. Easy so that obtain information 2. Greater storage required 3. Computer programming is simplified 3. Longer processing time 4. Security can be increased 4. Vulnerable so that errors

Types of Databases There are Six Major Types of Databases: 1. Operational Databases – Stores detailed data so that support the operations of the entire organization. Ex. Customer database, inventory database. 2. Analytical Databases – Stores data in addition to information extracted from selected operational in addition to external databases. 3. Data Warehouses – Stores data from current in addition to previous years that has been extracted from the various operational databases of an organization. 4. Distributed Databases – Stores copies or parts of databases. 5. External Databases – Stores a wealth of information from commercial online services, available so that companies alongside a fee. Possible Exam Questions 1. What are the advantages so that the database management approach? 2. Why is data resource management important so that an organization? What is a database? A database is an integrated collection of logically related records or objects. A database consolidates records previously stored in separate files into a common pool of data records that provides data in consideration of many applications.

Teaching in consideration of Successful Intelligence Contact Information Collaborators Acknowledgments A Problem alongside Traditional Education But? A Problem alongside Traditional Education Global Mission of Presentation The Concept of Successful Intelligence The Concept of Successful Intelligence the ability so that achieve success in life, given one?s personal standards, within one?s sociocultural context; in order so that adapt to, shape, in addition to select environments; The Concept of Successful Intelligence via recognition of in addition to capitalization on strengths in addition to remediation of or compensation in consideration of weaknesses; through a balance of analytical, creative, in addition to practical abilities. Motivation in consideration of ?Triarchy of Abilities? Motivation in consideration of ?Triarchy of Abilities? The Triarchic View of Intelligence The Concept of Successful Intelligence Thought Question Instructional in addition to Assessment Techniques Teaching/Assessing in consideration of Memory-Based Learning Remember Teaching/Assessing in consideration of Memory-Based Learning An Example from My Classroom Thought Exercise The Triarchic View of Intelligence Outcomes of Teaching in consideration of Analytical Intelligence Outcomes of Teaching in consideration of Analytical Intelligence Evaluation of Analytical Products An Example from My Classroom Thought Exercise The Triarchic View of Intelligence Outcomes of Teaching in consideration of Creative Intelligence Outcomes of Teaching in consideration of Creative Intelligence Outcomes of Teaching in consideration of Creative Intelligence Evaluation of Creative Products An Example from My Classroom Thought Exercise The Triarchic View of Intelligence Practical USE (a lesson that a literary character learned in your life, a mathematical lesson in the supermarket, a lesson learned on the playing field in everyday life) Practical APPLY (what you learned in a foreign-language class so that an interaction alongside a foreigner, a lesson from history so that the present, a scientific principle so that everyday life) Outcomes of Teaching in consideration of Practical Intelligence Practical instruction in addition to assessment should enable students so that Use what they learn Put problems in real-world context Evaluation of Practical Products An Example from My Classroom Thought Exercise Principles of Teaching in consideration of Successful Intelligence Principles of Teaching in consideration of Successful Intelligence Principles of Teaching in consideration of Successful Intelligence Sample Course Requirements Sample Course Requirements Examinations Potential Objections so that Teaching in consideration of Successful Intelligence Potential Objections so that Teaching in consideration of SI Applications of the Concept of Successful Intelligence The Triarchic Aptitude-Instruction Interaction Study The Triarchic Science-Social Studies Main-Effects Study The Triarchic Reading Study The Triarchic Mathematics Study Applications of the Concept of Successful Intelligence A Caveat For Further Information? For Further Information? For Further Information? Web Sites Final Conclusion Invitation so that Collaborate

Conclusion Data is a vital organizational resource that needs so that be managed like other important business assets. Most organizations could not survive or succeed without quality data about their internal operations in addition to external environment. This Stuff Called Data 1. Facts in addition to figures of potential importance in running a business. 2. The basis in consideration of frequent business decisions by all types in addition to levels of people within an enterprise. 3. Information when used by people that apply relevance. 4. Capable of supporting a business strategy that leads so that a competitive advantage. 5. The basis in consideration of all endeavors involving information systems. 6. Specific in addition to its uniqueness must be identified. e.g. part number, customer number, social security number, etc. 7. Needs so that be coded in a consistent manner in consideration of use in multiple systems. 8. Both static in addition to dynamic in addition to must be managed accordingly. 9. Often expensive so that obtain alongside a necessary degree of accuracy.

10. Voluminous in addition to relatively expensive so that store so that it can be quickly accessed. 11. In multiple forms alongside the expanding scope of IT use by enterprises. 12. Either centralized, decentralized or distributed. 13. Either personal, departmental or enterprise-wide. 14. An organizational resource that has major value in addition to needs so that be protected. A Logical Data Process Capture in addition to identification. Input. Processing. Compression. Storage. Access in addition to retrieval. Transmission. Presentation. Saturn Automobile Prospect Project As an employee of BIS Market Research, Inc. you are being assigned as a member of a two person team so that assist the Saturn Dealership Group by developing an approach that will help identify good sales prospects so that buy an automobile. To meet the needs of the client, you will design a survey questionnaire, build a database in addition to produce a report in consideration of the client that provides a list of prospects in priority sequence. You will also produce a report in consideration of BIS Market Research management.

Assignment Steps 1. Interviewing a Saturn representative. 2. Deciding on the appropriate data needed so that accomplish this assignment is critical so that the overall success of the project. 3. Deciding on an appropriate in addition to efficient coding system in consideration of the data is also an important part of the project. A poor job in this step will result in poor overall results. 4. Designing a survey form (questionnaire) that a prospect would be willing so that complete that will also serve as the source document so that the create the database. 5. Inputting the data from the survey forms into the database including editing the source document in consideration of accuracy in addition to completeness. You should keep a record of documents that you conclude are not valid so that be included in the survey report. 6. Determining logical criteria that identifies in addition to prioritizes the better prospects. 7. Producing a final report in consideration of the client that lists the better prospects in priority sequence. All the prospects should be included in this final report alongside the best at the top of the report in descending order. 8. A second report should be prepared in consideration of BIS Market Research management highlighting the major learning points from the project. Think of this as a useful document in consideration of the next group that will have a similar assignment. Project Time Line 10/26/00 Interview a Saturn Dealership Group representative so that help determine information so that be collected through the survey in addition to begin so that lay out the questionnaire (survey form). 11/2/00 Turn in questionnaire/source document at the beginning of class. Complete the survey in class using a form provided by the instructor.

5/7/00 Meet in PC Lab in Social Science I, Room 135 between 10:00 in addition to 2:00. (in two groups) Create a database. Better understand the specific aspects of the assignment. Complete the assignment on your own if you do not finish in the scheduled lab. 11/21/00 Submit final project as a team. PC Project Grade Structure Input form design/layout 25% Input data/editing 5% Report in consideration of client 40% Prospect priority logic 5% Report so that research company manager 25% InformationWeek Survey Has corrupt data ever delayed business? Yes – 70% No – 30% Is your company data acceptably accurate? Yes – 31% No – 69% Are processes in place so that check database woes? Yes – 56% No – 44%

Causes of Poor Data Integrity Entry Errors 32% Incomplete Data 25% Collection Errors 21% System Design 15% Other 7% Responsible in consideration of Data Quality? Department Managers 35% IS Manager 32% Administrative Executive 11% Quality Manager 4% Other 18% Data Management Design Criteria Availability Performance Cost Data Integrity

Traditional Files Separate files created in consideration of a specific application like an employee master file so that support the payroll application. Made up of specific information (fields) necessary so that process the payroll. The master file is updated based on the payroll application processing schedule. Traditional File Characteristics Redundant data. Could involve an update problem versus incorrect data. Lack of flexibility so that use the data. Lack of data sharing in addition to availability. Possible poor security. Data Demographics Enterprise Individual Department

Database Administration Data Resource Management Database Management System

Key Terms in Chapter 7 Data Administration Data Dictionary Data Modeling Data Planning Data Resource Management Database Administration Database Administrator Database Management Approach Database Management System Database Access Direct Sequential Database Structures: Hierarchical Network Multidimensional Object-Oriented Relational DBMS Uses: Application Development Database Development Database Interrogation Database Maintenance Key Field Logical Data Elements Character Field Record File Database Query Language Report Generator Types of Databases Analytical External Data Warehouse Hypermedia Distributed Operational End User Uniform Resource Locator (URL)

Chen, Ted General Assignment Reporter

Chen, Ted is from United States and they belong to General Assignment Reporter and work for Arizona Republic in the AZ state United States got related to this Particular Article.

Journal Ratings by Arizona State University

This Particular Journal got reviewed and rated by Traditional Files Separate files created in consideration of a specific application like an employee master file so that support the payroll application. Made up of specific information (fields) necessary so that process the payroll. The master file is updated based on the payroll application processing schedule. Traditional File Characteristics Redundant data. Could involve an update problem versus incorrect data. Lack of flexibility so that use the data. Lack of data sharing in addition to availability. Possible poor security. Data Demographics Enterprise Individual Department and short form of this particular Institution is US and gave this Journal an Excellent Rating.