MIS 235 Exam #2 Review

MIS 235 Exam #2 Review - I Chapter 5 Database Processing A...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
I. Chapter 5- Database Processing A. Database - Self-describing collection of integrated records (tables, relationships, and metadata). Tables or files + relationships among rows in tables and metadata (special data). Byte - character of data, grouped into columns (fields) Rows-records = are made up of columns-fields Table-File = A group of similar rows or records. o 1-1 (home stadium to team), 1-many (team has players), many to many (Each player and game there are game stats) Primary Key= column or group of columns that identifies a unique row in a table. Every table has a key. Ex) student number is a key of the student table. Foreign Key= Different keys of a table than the one in which they reside Relationship Database= Databases that carry their data in the form of tables and the represent relationships using foreign keys ***Metadata= Data that describes data. Finds out what databases contain B. ***Database Management System= Program used to create, process, and administer a database. Ex) Access, SQL, Oracle, and DB2. It reads, inserts, modifies, and deletes data Structured Query Language= International standard language for processing a database and is used to create databases and database structures. Hierarchical= models entitles in a parent-child relationship o 1) Select*= Column 1 (What output do you want) o 2) From= Table Name o 3) Where= Conditions, if multiple tables, join in the FROM clause o 4) Group By= column list, used with aggregation o 5) Having= conditions, used with aggregation o 6) Order By= Ascending or Descending Backing up data, adding structure to provide the performance of database applications and removing unwanted data. Database Application= A collection of forms, reports, queries, and application programs that process a database. It can have multiple applications with multiple users Data entry forms are used to read, insert, modify, and delete data Reports show data in a structured context. ***Database Application Programs= Application programs process logic that is specific to a given business need. It enables database processing over the internet Lost Update Problem= Issue in which two or more users try to make changes to the data, but the database cannot make the
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
changed because it cannot sync two users Enterprise DBMS= Products process large organizational and workgroup databases. Personal DBMS= Designed for smaller, simpler database applications, 715 users. Normalization= A technique used to make complex databases more efficient. Breaks large complex tables into multiple tables, eliminates all repeating groups or records I. Chapter 6- Data Communications 1. Computer Network a. Network= Collection of computers that communicate with one another over transmission lines b. Protocol= Set of rules that two communicating devices follow. For TWO devices to communicate, they must both use the same protocol c. Local Area Network (LAN)= Computers connected (2-100’s)
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 7

MIS 235 Exam #2 Review - I Chapter 5 Database Processing A...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online