final_Draft_key_terms[1]

final_Draft_key_terms[1] - Databases DBMS DBMS utilities...

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

View Full Document Right Arrow Icon
Databases DBMS DBMS utilities Easily combine related data ad hoc searches Make reports Easily data type validation check Data domain control Other domain controls (Database management system) Group of programs that manipulate the database and provide an interface between the database and the user or database and application programs Available in many sizes and types DBMS can do important things Store important data for anyone in any form Perform routine tasks such as taxes and payroll Create reports Protect data from attacks and unauthorized access Advantages of a DBMS Reduced data redundancy Less storage space Improved data integrity It is more likely to be accurate Easier Modification and updating You only have to update the data in one place Data and program independence When you data or introduce new data or move the data you don’t have to rewrite your program for it to be compatible Better access to data and information Easy to retrieve and sort and combine and compare Standardization of data access Better overall protection of the data You only have to protect one piece of data Shared data and information resources Cost can be split up between separate areas of a business Field A name, number, or combination of characters that in some way describes an aspect of an object or activity Every field has a field name it can be fixed or variable in length Primary Key can be used to identify a member accurately Record A collection of related fields that describe an object or activity A primary key or principal key uniquely identifies a record Tuple is a Record Table Also called a file
Background image of page 1

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

View Full DocumentRight Arrow Icon
Is a collection of related records Hierarchical databases Database/ Files Records Fields Characters (Bytes) Relational databases All data is placed in two-dimensional tables called relations You can do selecting in this type of database and choose data based on certain criteria U can also do joining combining two or more tables Being able to relate tables to each other through common data elements is one of the key to the flexibility and power of relation databases Flat file No relationship between its records and is often used to store and manipulate a single table or file Most common type is CSV comma-separated values Can be read by many types of software so they are handy for sharing data Field types Numeric (Numbers) e.g., number of cd’s or price Alphanumeric e.g., include numbers or characters that cannot be manipulated Date Logical It has a yes or no answer Computed or calculated field Things like gross pay or grade point average When you add up other fields to create a new one Data types Integer Real -supports decimal Currency-support decimals Date- date and time Character-alphanumeric (fixed length) Memo-Alphanumeric Logical-true false yes/no BLOB-anything else music pic If you don’t do math on them put them in as a Character Flat file and file organizers Single user Access and Quicken Multiuser Allow many people to access the database
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.

Page1 / 8

final_Draft_key_terms[1] - Databases DBMS DBMS utilities...

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