CIS 105 Chapt. 14 Notes
CIS 105 Chapt. 14 Notes CIS 105
Popular in Computer Appls&Info Technology
Popular in Computer Information Systems
This 2 page Class Notes was uploaded by Brigette Maggio on Monday January 4, 2016. The Class Notes belongs to CIS 105 at Arizona State University taught by Wood, McCarthy in Fall 2015. Since its upload, it has received 36 views. For similar materials see Computer Appls&Info Technology in Computer Information Systems at Arizona State University.
Reviews for CIS 105 Chapt. 14 Notes
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 01/04/16
CIS 105 11/17/15 McCarthy Chapter 14 Database *table is where data resides *row is a record in a data table *fields and columns*most important thing to do is to ask the table a questi on (query) *Database software is well thoughtout collection of computer files called tables that consist of records (rows) of data separated by fields (columns) that can be queried (questioned) to produce subsets of information. The records retrieved by these queries become information that can be used to make business decisions. Databases are referred to as database management systems (DBMS). In a DBMS, data is stored in computer files called tables, and tables are combined to other tables with related information, hence, a relational database. Business databases are always distributed on a computer network for multiple users. At its core a database is made up of files called tables that are related to each other. Other files that exist within a database like reports that display database information on screen or on paper, saved query files that are used to find specific populations of a databases, and forms which overlay data tables and queries for more specific views of data. Database designers construct databases by using entity relationship diagrams (ERM) which is a databasemodeling method to construct a theoretical and conceptual representation of data to produce a schema. *data base is always reconciled *when build a data base, you draw on paper first by using an entity relationship diagram *farthest left column is called a key field (won’t let a duplication in that field) *key field also lets you make relationships Database designers need to know a business. They first start out finding out what a business does and how they do it. Database software is different, requiring the end user to create their own files starting with tables, and then relating them to each other. Once the table structure is complete, the user is required to understand possible valid entries in a table’s field (column). *data validation telling the field what specifically you want to validate (capital or lowercase AZ or az) The nature and structure of a well thought out database management system helps a business avoid data redundancy. For instance, only a singular table holds personal information about a person. A person’s unique information like their name resides in just one place in the entire DBMS. *Structured Query Language (SQL) is the most widely used standard computer language for relational databases that allows a programmer to manipulate and query data. One of the most common uses of SQL is to query a table(s). For instance, a table might have the names of 10,000 book titles and their prices. If a person wanted to know which books in the data table cost more than $100.00 they could set up a SQL statement like the following: SELECT Title FROM Book WHERE Price > 100 ORDER BY Title SELECT Title FROM Book WHERE Price > 100 ORDER BY Title The first line of the SQL statement “Selects” which field in the table should be in the query’s results, in this case, the “Title” field. The second line (FROM) determines which data table to query, which holds the “Title” field. The last line determines what criteria should be applied, in this case to another field called “Price” that resides in the “Book” table. The criterion in the third line of the SQL finds books where cost is greater than $100.00. Once the SQL is run, the fourth line will sort the results. McCarthy’s Personal Life/ Background Notes: *tracking REL (real estate owned) *must reserve money per the federal government *wanted to make a form just see a fact sheet as one form *Heiman Rico (father of nuclear warfare): “You can delegate authority, but you cannot delegate responsibility.” It was all McCarthy’s fault for the bank closing in 2 months.
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'