New User Special Price Expires in

Let's log you in.

Sign in with Facebook


Don't have a StudySoup account? Create one here!


Create a StudySoup account

Be part of our community, it's free to join!

Sign up with Facebook


Create your account
By creating an account you agree to StudySoup's terms and conditions and privacy policy

Already have a StudySoup account? Login here

CIS 105 Chapt. 14 Notes

by: Brigette Maggio

CIS 105 Chapt. 14 Notes CIS 105

Brigette Maggio
GPA 3.9

Preview These Notes for FREE

Get a free preview of these Notes, just enter your email below.

Unlock Preview
Unlock Preview

Preview these materials now for free

Why put in your email? Get access to more of this material and other relevant free materials for your school

View Preview

About this Document

These notes cover CIS 105 Chapt. 14 Notes.
Computer Appls&Info Technology
Wood, McCarthy
Class Notes
CIS 105
25 ?




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.

Similar to CIS 105 at ASU

Popular in Computer Information Systems


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 thought­out 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 database­modeling 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.


Buy Material

Are you sure you want to buy this material for

25 Karma

Buy Material

BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.


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'

Why people love StudySoup

Jim McGreen Ohio University

"Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."

Allison Fischer University of Alabama

"I signed up to be an Elite Notetaker with 2 of my sorority sisters this semester. We just posted our notes weekly and were each making over $600 per month. I LOVE StudySoup!"

Steve Martinelli UC Los Angeles

"There's no way I would have passed my Organic Chemistry class this semester without the notes and study guides I got from StudySoup."

Parker Thompson 500 Startups

"It's a great way for students to improve their educational experience and it seemed like a product that everybody wants, so all the people participating are winning."

Become an Elite Notetaker and start selling your notes online!

Refund Policy


All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email


StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here:

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.