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

CIT 241

by: Adriana

CIT 241 CIT 241

GPA 3.86

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

This covers everything that Coakley went over in the first week of class
Database Management
Class Notes
CIT, 241, Coakley, information, Technology, Database, Management
25 ?




Popular in Database Management

Popular in Information technology

This 4 page Class Notes was uploaded by Adriana on Saturday January 30, 2016. The Class Notes belongs to CIT 241 at Pace University taught by Coakley in Spring 2016. Since its upload, it has received 29 views. For similar materials see Database Management in Information technology at Pace University.


Reviews for CIT 241


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/30/16
Relational Databases Purpose of a Database  to keep track of things  Unlike a list or spreadsheet, a database may store information that is more complicated than a simple list Problems with Lists: Redundancy  In a list each row is intended to stand on its own. As a result the same information may be entered several time. Multiple Themes  In a list, each row may contain information on more than one theme. As a result, needed information may appear in the lists only if information on other themes is also present List Modification Issues  Redundancy and multiple themes create modification problems: o Deletion problems o Update problems o Insertion problems Relational Databases  A relational database stores information in tables. Each informational topic s stored in its own table.  In essence, a relational database will break up a list into several parts - one for each theme in the list. Relational Databases segment information by themes. Putting Pieces Back Together In our relational database, a list is broken into several tables. Somehow the table must be joined back together  In a relational database, tables are joined together using the value of the data  If a PROJECT has a CUSTOMER, the CUSTOMER_ID is stored as a column in the PROJECT table. The value stored in this column can be used to retrieve specific customer information from the CUSTOMER table. Customer Project Customer_ID 001 Project_ID 001 Customer Name Customer_ID 001 Structured Query Language (SQL)  An international standard for creating, processing, and querying databases and their tables.  Many database applications use SQL to retrieve, format, report, insert, delete, and/or modify data for users SELECT * From tblCUSTOMER Where Customer_Last 'Smith' The 4 components of a database system are:  Users  Database Application  Database Management System (DBMS)  Database A user of a database system will:  Use a database application to track things  Use forms to enter, read, delete, and query data  Produce reports Components of a Database System A user of a database system will:  Use a database application to track things  Use forms to enter, read, delete, and query data  Produce reports The Database A database is a self-describing collection of related records.  The database itself contains the definition of its structure.  Metadata is data describing the structure of the database data. Tables within a relational database are related to each other. DBMS  Serves as an intermediary between database applications and the database  Manages and controls database activities  It creates, processes and administers the databases it controls Functions  Create databases, tables, supporting structures  Read database data  Modify database data (insert, update, and delete)  Maintain database structures  Enforce rules  Control concurrency (several computations are executing simultaneously, and potentially interacting with each other)  Provide security  Perform backup and restore Example Database Metadata: A Relationship Diagram Database Contents  User data  Metadata  Indexes and other overhead data  Application metadata Personal Database Systems  Have one application  Have only a few tables  Are simple in design  Involve only one computer  Support one user at a time Microsoft Access is often used for this   Database Application and DBMS are connected Database Application  A set of one or more computer programs that serves as an intermediary between the user and the DBMS. Functions  Create and process forms  Process user queries  Create and process reports  Execute application logic  Control database applications *Referential Integrity Constraints  ensure the values of a column in one table are valid based on the values in another table A customer makes an order. Their customerID is in the CUSTOMER table and their order is in the ORDER table. You must have both values existing in their appropriate tables. SQL Syntax Table names: all caps Column Name: First letter cap, rest lowercase


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."

Amaris Trozzo George Washington University

"I made $350 in just two days after posting my first study guide."

Bentley McCaw University of Florida

"I was shooting for a perfect 4.0 GPA this semester. Having StudySoup as a study aid was critical to helping me achieve my goal...and I nailed it!"


"Their 'Elite Notetakers' are making over $1,200/month in sales by creating high quality content that helps their classmates in a time of need."

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.