Premium Essay

Database Systems Cornel/Morris Chapter 1 Summary

In: Computers and Technology

Submitted By accardap
Words 2824
Pages 12
Chapter 1 Database Systems
Why Databases? * At the heart of all of these systems are the collection, storage, aggregation, manipulation, dissemination, and management of data * Databases are specialized structures that allow computer-based systems to store, manage, and to retrieve data very quickly

Data vs. Information * Data – raw facts * Raw indicates that the facts have not yet been processed to reveal their meaning * You transform the raw data into a data summary * Information – the result of processing raw data to reveal its meaning * Data processing can be as simple as organizing data to reveal patters or as complex as making forecasts or drawing inferences using statistical modeling * To reveal meaning, information requires context * Raw data must be properly formatted for storage, processing, and processing * Ex: dates must be stored in Julian calendar formats and yes/no responses must be converted to Y/N or 0/1 * Data are the foundation of information which is bed rocked of knowledge * Knowledge – body of information and facts about a specific subject * Knowledge implies familiarity, awareness, and understanding of information as it applies to the environment * A key characteristic of knowledge is that “new: knowledge can be derived from “old” knowledge * Key Points: * Data constitute the building blocks of information * Information is produced by processing data * Information is used to reveal the meaning of data * Accurate, relevant and timely information is the key to good decision making * Good decision making is the key to organizational survival in a global environment * Data Management – a discipline that focuses on the proper generation, storage, and retrieval of data

Introducing the Database * Database –…...

Similar Documents

Premium Essay

Accounting Information System Chapter 1

... Overview of Accounting Information Systems Chapter 1 The Information System: An Accountant’s Perspective 3 Introduction to Transaction Processing 31 Ethics, Fraud, and Internal Control 91 Chapter 2 I Chapter 3 1 CHAPTER The Information System: An Accountant’s Perspective nlike many other accounting subjects, such as intermediate accounting, accounting information systems (AIS) lacks a well-defined body of knowledge. Much controversy exists among college faculty as to what should and should not be covered in the AIS course. To some extent, however, the controversy is being resolved through legislation. The Sarbanes-Oxley Act (SOX) of 2002 established new corporate governance regulations and standards for public companies registered with the Securities and Exchange Commission (SEC). This wide-sweeping legislation impacts public companies, their management, and their auditors. Of particular importance to AIS students is the impact of SOX on internal control standards and related auditing procedures. Whereas SOX does not define the entire content of the AIS course, it does identify critical areas of study that need to be included for accountants. These topics and more are covered in the chapters of this text. The purpose of this chapter is to place the subject of AIS in perspective for accountants. Toward this end, the chapter is divided into three major sections, each dealing with a different aspect of information systems. The first section explores the......

Words: 13048 - Pages: 53

Free Essay

Kotler's Summary Chapters 1-19

...mercadólogos, junto a otras influencias de la sociedad, influyen en los deseos. Producto u oferta La gente satisface sus necesidades y deseos con productos. Un producto, es cualquier ofrecimiento que pueda satisfacer una necesidad ó un deseo. Una marca es un ofrecimiento de una fuente conocida. Valor y satisfacción El producto ó servicios. tendrá éxito si entrega valor y satisfacción al comprador meta. El valor es el cociente entre lo que el cliente obtiene y lo que da. El cliente obtiene beneficios e incurre en costos. Beneficios funcionales + beneficios emocionales Valor = costos monetarios + costo de tiempo + costo de energía + costos psíquicos Si el resultado es 1, el cliente se mostrará indiferente. Si es mayor ó menor que uno preferirá la opción 1 ó la 2 respectivamente. Para aumentar el valor el mercadólogo puede: incrementar el beneficio, bajar costos, ambas, subir beneficios mas que los costos y bajar beneficios menos que los costos. Intercambio y transacciones El intercambio es una de las cuatro formas en que una persona puede obtener un producto. La persona puede, producir ella misma el bienes ó servicios., usar la fuerza para obtener un producto ó pedir el bienes ó servicios. El intercambio es el proceso central del marketing, implica obtener de alguien un producto deseado ofreciendo algo a cambio. Para que exista un potencial de intercambio se deben dar 5 cosas: que haya 2 partes, que cada una tenga algo valioso......

Words: 66996 - Pages: 268

Premium Essay

It250 Chapter 1 - Intro to Databases

...Databases Chapter 1 – Intro Lab 1.2 1. Nouns: doctors, patients, drugs, side effects. 2. Major Topics: doctor Records, patient medical records, side effects / symptoms, and screening records. Lab 1.3 1. Major Topics: faculty, software, and computers. 2. Draft statement of work that includes scope, objectives, and preliminary timeline: a. Scope – A database with the ability to track faculty and staff computers and software. b. Objectives – Faculty software, version, license agreement, record of computers with software, location of computer, user access to computer, software install / uninstall timestamps, status of the computer. i. Additional: ability to track software requests and software availability. c. Timeline ii. Gathering data – gather records of the school computers and its staff, a list of software purchased and in use, interview and questionnaire information understand the faculty needs. Time: 1.5 weeks. iii. Analyzing data – Understanding the data to create data model. Know the needs of the faculty members and type of software / computers in use to determine business rules. Time: 2 weeks. iv. Normalization – Data modeling; entities and relationships normalized. Time: 2 weeks. v. Building the physical database – Create RDBMS database. Time: 4 days. vi. Testing and security – Testing using sample data. Create user permission for different levels of faculty, block out...

Words: 369 - Pages: 2

Premium Essay

Chapter 1 Management Summary

...CHAPTER 1 MANAGERS AND MANAGEMENT Competency: a combination of knowledge, skills, behaviors, and attitudes that contribute to personal effectiveness. Managerial competencies: sets of knowledge, skills, behaviors, and attitudes that a person needs to be effective in a wide range of positions and various types of organizations. Six managerial competencies: 1. Communication Informal communication Formal communication Negotiation 2. Planning and Administration Information gathering, analysis, and problem solving Planning and organizing projects Time management Budgeting and financial management 3. Teamwork Designing teams Creating a supportive environment Managing team dynamics 4. Strategic Action Understanding the industry Understanding the organization Taking strategic action 5. Global Awareness Cultural knowledge and understanding Cultural openness and sensitivity 6. Self-management Integrity and ethical conduct Personal drive and adaptability Balancing work and life demands Self-awareness and development What is an organization? Organization: a coordinated group of people who function to achieve a particular goal. Regardless of an organization’s specific goals, the job of managers is to help the organization achieve those goals. What is a manager? Manager: a person who plans, organizes, leads, and controls the allocation of human, material, financial, and information resources in pursuit of the......

Words: 1497 - Pages: 6

Premium Essay

Perloff Chapter 1 Summary

...Microeconomics Chapter 1 –Introduction- Microeconomics: * The study of how individuals and firms make themselves as well of as possible in a world of scarcity(shortage) and the consequences of those individual decisions for markets and the entire economy. * Often called price theory: emphasize the important role of the price 1.1 Microeconomics: The Allocation of Scare Resources Trade-Offs: * Which goods and services to produce: limitation of production, resources ( worker, raw materials, capital and energy) * How to produce: to produce a given output a firm needs to use more of one resource and less of another * Who gets the goods and services: the more of society’s goods and services you get, the less someone else gets Who makes the Decisions: * The government * A company Price Determine Allocations: * Market: an exchange mechanism that allows buyers to trade with sellers 1.2 Models Model: * a description of the relationship between two or more economic variables * can be used to predict the effect of a change of one variable Simplifications by Assumptions: * Example: Income threshold model of China to explain car purchasing behavior in China * Only the income is important Testing Theories: * Testing theories by checking whether predictions are correct Positive vs. Normative: * Positive statement: a testable hypothesis about cause and effect * Test the truth of a statement * Normative......

Words: 1132 - Pages: 5

Free Essay

Database Management Chapter 1

...Principles of Database Management Systems Homework 1 Ying Li 4861521 Homework 1 Exercise 1.4 Explain the difference between external, internal, and conceptual schemas. How are these different schema layers related to the concepts of logical and physical data independence? Answer: External schemas, which usually are also in terms of the data model of the DBMS, allow data access to be customized (and authorized) at the level of individual users or groups of users. Internal (physical) schemas summarize how the relations described in the conceptual schema are actually stored on secondary storage devices such as disks and tapes. Conceptual (logical) schema describes the stored data in terms of the data model of the DBMS. In a relational DBMS, the conceptual schema describes all relations that are stored in the database. Any given database has exactly one conceptual schema and one internal schema because it has just one set of stored relations, but it may have several external schemas, each tailored to a particular group of users. External schemas provide logical data independence, while conceptual schemas offer physical data independence. Exercise 1.6 Scrooge McNugget wants to store information (names, addresses, descriptions of embarrassing moments, etc.) about the many ducks on his payroll. Not surprisingly, the volume of data compels him to buy a database system. To save money, he wants to buy one with the fewest possible features, and he......

Words: 859 - Pages: 4

Free Essay

Chapter 1 Summary Nt1210

...I analyzed chapter 1 of the book and in short will briefly go over some of the key terms. First is the concept behind bits and bytes. Bits represent the concept of a binary digit. Computers record the ideas they work with electronically as bits and represent either a 1 or 0. Bytes are equivalent to 8 bits. Some tasks require only a few bytes of data, others require the computer to actually organize data into groups of thousands or millions of bytes. Computers use binary math based on powers of two. RAM (random-access memory) uses an address for each unique memory location where a byte can be stored. It is only temporary memory and will erase data once the computer is shut down. Text characters are stored in RAM as bits by the CPU. For each letter pressed on the keyboard, hidden to the user, the keyboard sends some bits to the computer. The CPU’s filing system organizes files through file concept which lets the CPU treat all the bytes in one document, one song, one video and so on as group of bytes that be refreshed as a name. Disk drives organize the storage locations based platters, tracks, and sectors. The CPU writes the file to a disk by identifying some unused sectors, the CPU must mark these sectors as used. As a result the platter, track and sectors have to be recorded and noted as holding contents so that file contents so that can file contents can be found later. Hard disk store data using magnetic using magnetic charges applied to the surface of a platter. The......

Words: 289 - Pages: 2

Premium Essay

Database Management Chapter 1 & 2

...Chapter 1: (10 points each) 1. Give an example of two related tables other than one in the textbook. Use the STUDENT and GRADE tables in Figure 1-1 of the textbook as an example pattern for your tables. Name the tables and columns using the conventions in the textbook. * I used MysqL workbench to create 2 tables 1- Customers that has customers with some of their information(primary key is “Customer ID”) * CREATE TABLE IF NOT EXISTS `mydb`.`Customer` ( * `CustomerID` INT NOT NULL, * `Name` VARCHAR(45) NULL, * `Email` VARCHAR(45) NULL, * PRIMARY KEY (`CustomerID`), * UNIQUE INDEX `Email_UNIQUE` (`Email` ASC)) * ENGINE = InnoDB 2- Purchases that has number of purchases that has been done by the customers(Pkey is PurchaseID, and foreign key is “CustomerID” from Customer table. * CREATE TABLE IF NOT EXISTS `mydb`.`Purchases` ( * `PurchasesID` INT NOT NULL, * `productID` INT NULL, * `PricePaid` INT NULL, * PRIMARY KEY (`PurchasesID`)) * ENGINE = InnoDB * * *note I made the customerID as the foreign key and the relationship is (1 to many) * * * Figure1 the Customer and Purchases tables’ relationship. * 2. For the tables you created in Question 1, what are the primary keys of each table? Do you think that any of these primary keys could be surrogate keys? * In Customer table the Primary key is CustomerID * In the Purchases table the primary key is......

Words: 1949 - Pages: 8

Premium Essay

Database Systems and How They Are Used

...Database Systems and How They are Used DBM/380 Week 1 Individual Assignment Craig Gruenbaum Instructor: Kevin Judge Database Systems and How They are used Database systems are utilized in basically every business every day. Businesses use data to perform a multitude of functions, such as sales transactions, customer queries, and the viewing of key performance indicators. Database systems are the management tool that aids in accessing this data. “In a sense, a database resembles a very well-organized electronic filing cabinet in which powerful software (the DBMS) helps manage the cabinet’s contents”(Rob, P., Coronel, C., & Morris, S, 2013). Database Architecture Database Architecture refers to the design of the database. For example, databases can be designed for a single site or multiple sites, have lots of generic data or data designed for a specific purpose, or be transactional or analytical. Take Oracle database architecture for example. “Oracle9i, Oracle8i, and Oracle8 databases are powerful, flexible, and scalable relational database management system (RDBMS) servers that run on a range of computer systems, from personal computers to largest mainframes. Oracle is designed to run effectively in a client/server environment and supports hundreds to thousands of users” (Oracle, "Migration Process", 1998). Summary Without database systems, companies would have no means by which to access the information stored in their databases. This......

Words: 497 - Pages: 2

Premium Essay

Chapter 1 Test Database Concepts

...answers the question. 1) A good definition for a database is: 1) _______ A) A text file with values delimited by commas B) A collection of related data C) A card catalogue D) A piece of software for managing databases 2) Redundancy refers to what database condition? 2) _______ A) All data is stored in tables B) You have more than one database devoted to the same thing C) The same data is recorded in more than one place in the same database D) A primary key is repeated in another table as a foreign key 3) Which best defines the function of a primary key? 3) _______ A) It uniquely identifies each record B) It is always a number C) It unlocks the data in a table D) It is the first field in a table 4) What best describes the function of a foreign key? 4) _______ A) A foreign key is at the primary key of one table repeated in another table in order to create a relationship between the tables B) A foreign key is a field telling what language the data is in C) A foreign key is a key that doesn't belong in the table D) A foreign key is redundant data 5) A database entity can best be described as: 5) _______ A) The person responsible for the database B) Something that describes a person or process C) Something the database is concerned......

Words: 666 - Pages: 3

Premium Essay

Database Design Chapter 1 Review Questions

...1. a. Data – Raw facts b. Field – An alphabetic or numeric character or group of characters that defines a characteristic of a person, place, or thing. c. Record – A collection of related fields. d. File – A named collection of related records 2. Data redundancy occurs when the same data are stored in multiple places unnecessarily. Have more than one incorrect copies of information can cause it. 3. Data independence exists when you can change the data storage characteristics without impeding the program's ability to access the data. It is lacking because of how it has to tell the computer what to do, and how to do it. Causing the program to have much more lines of code than should be needed. 4. It is a software tool that makes it possible to organize data in a database. Its functions are data dictionary management, data storage management, data transformation and presentation. 5. Structural independence exists when you can change the file structure without affecting the application's ability to access the data. If it did not exist, any change to a files structure would require several extra steps for every single record in the file. 6. Data is raw facts that have not been processed. Information is data that has been processed and given context. Databases help to organize the manipulation of data to create information by providing an organizational structure that makes relationships and connections between data explicit. 7. The DBMS serves as the......

Words: 480 - Pages: 2

Premium Essay

Database Managment - Chapter 1 Assigment

...CHAPTER 1 ASSIGNMENT 1. Part A a. Automatic information processing was introduced by James Power whose company later became known as IBM b. The emergence of reusable data opened up the horizons for database management systems. c. Data provides a competitive advantage for businesses of all shapes and sizes. Part B a. Backup and recovery technology allows database managers to sleep in peace knowing their data is safe. b. Data Security protects consumers from data theft. c. Data privacy is very important. Hospital employees, for example, are only allowed access to certain parts of the EMR system which holds patient data. 2. 1986 – When my world began… IBM becomes the first company to use a one megabit chip in the IBM 3090 1991 – The first web site was built at CERN labs and put online August 6th 1992 – Microsoft Access was released 1995 – MySQL’s initial release 1998 – Google began 2004 – Emergence of Web 2.0 2007 – Amazon releases the Kindle fostering a huge database of electronic books 2013 – MySQL is the second most widely used database management system 2015 – I take Database Management class with Mr. Ted Lee! 3. Here at the Show Me The Money Bank of Tennessee, our database systems allows us to send birthday greetings, send Congratulations to new graduates and newlyweds, reward long time clients, and off the most competitive interest rates on cars, houses, boats, etc. 4. Early data management was very time consuming. The examples of the seven years it took...

Words: 341 - Pages: 2

Premium Essay

Chapter 1 of Inventory System Documentation

...STI College – Muñoz EDSA Inventory Management System of an Appliance Store A Project Presented to The Faculty of STI College – Muñoz EDSA In Partial Fulfilment of the Requirements for the Degree of Bachelor of Science in Computer Science by Majadas, Ellayn S. Cabato, Jonathan Lal, Depak Franco, Chester John BT402A CARLEX ROL JALMASCO Project Adviser December, 2015 Chapter 1 1. Introduction: Company Background The company gets their stocks from different companies (who sells appliances) and paid it by terms. Their recording of products, sales, purchases, expenses and inventory are in manual form. The accountant manually computes and totals the amount of monthly sales, purchases, expenses, tax and inventory. In this kind of system, missing receipts, sales, purchases, expenses and inventory records are hard to track back. The manual inventory system will be replaced and organized by developing an “Inventory Management System”. Inventory Executive System is a complete inexpensive system for management of sales, purchases and payments. This system will help you in creation invoices, sale orders, purchase orders, receiving lists, payment receipts, product labels and any kinds of the reports for monitoring your business. 2.1. Statement of the problem 2.2.1. General Problem The company are currently using manual system in getting inventory. These kinds of system have lots of problems like: * Less......

Words: 433 - Pages: 2

Premium Essay

Computerized Grading System Chapter 1

...Chapter I Introduction What is Computer? Let us begin with the word ‘compute’. It means ‘to calculate’. We all are familiar with calculations in our day to day life. We apply mathematical operations like addition, subtraction, multiplication, division. and many other formulae for calculations. Simpler calculations take less time. But complex calculations take much longer time. Another factor is accuracy in calculations. So man explored with the idea to develop a machine which can perform this type of arithmetic calculation faster and with full accuracy. This gave birth to a device or machine called computer. The computer we see today is quite different from the one made in the beginning. The number of applications of a computer has increased, the speed and accuracy of calculation has increased. You must appreciate the impact of computers in our day to day life. Reservation of tickets in Air Lines and Railways, payment of telephone and electricity bills, deposits and withdrawals of money from banks, business data processing, medical diagnosis and weather forecasting are some of the areas where computer has become extremely useful. What is Information System? An information system (IS) or application landscape is any combination of information technology and people's activities that support operations, management, and decision making. In a very broad sense, the term information system is frequently used to refer to the interaction between people, processes, data, and......

Words: 2480 - Pages: 10

Premium Essay

Management Information System Chapter 1

...An example of a business using information systems to attain competitive advantage is: A) JC Penny's information system that allows its contract manufacturers to see what garments have been sold and need to be replaced. B) Toyota's legendary TPS that has created superlative efficiencies and enabled Toyota to become the world's largest auto maker C) Verizon's Web-based digital dashboard providing real-time company information for managers. D) Apple's creation of the IPod. Ans: C) Verizons Web-based digital dashboard providing real-time company information for managers. 2) Which of the following choices may lead to competitive advantage (1) new products, services, and business models; (2) charging less for superior products; (3) responding to customers in real-time? A) 2 and 3 B) 1, 2, and 3 C) 1 only D) 1 and 2 Ans: B) 1,2, and 3 3) A major criterion in deciding the most important perspectives of a business problem is: A) change management. B) usefulness. C) organizational needs. D) implementation. Ans:B) Usefulness 4) Inadequate database capacity is an example of the ________ dimension of business problems. A) people B) management C) organizational D) technology Ans:D) Technology 5) The owners of Speed-EZ, a new bike messenger service, are concerned about how they will manage their messengers once they have left the office. This is a business problem that falls into the: A) management dimension. B) technology dimension...

Words: 2622 - Pages: 11

Demi Waktu | Moto: tuning, styling | Wildling