Term
| JUNE 6 (BASIC CONCEPTS PART 1) |
|
Definition
|
|
Term
|
Definition
-a collection (or container) of data/information.
-it is organized and structured (like a computer/ folders/subfolders)so it can be EFFICIENTLY accessed, updated, secured, etc
(photos of students in UT database)
(is a box from the past a database?)(well is it organized?)
HUMANS CONTROL DATABASES.. operating systems by themselves ARE NOT databases |
|
|
Term
| What are some examples of databases..what have you used recently |
|
Definition
*current class roster (recent add/drops)
-easy acces...who added?? which one person? UT has collective database not single..prof had to compare and do most of the work himself. not convenient. yes
*google searches-No/yes...directory of databases. ehh
*McDonalds-cash register keeps and tracks sales and food..provides insight to customer behavior. |
|
|
Term
| more examples of databases |
|
Definition
Home depot- similar to mcdonalds
Police-tickets, drunk driving...all info is entered into database.
Stock market
Weather channel |
|
|
Term
| How are these examples of DB's similar and different? Mcdonalds homedepot |
|
Definition
Mcdonalds vs. Homedepot
--databases are identical
--similar--no negotiation w/in system (2x4,coffee)
--difference--aging products and shelf life
--inventory for multiple stores..(out of 2x4's send to different store that has them)
returning things
Simalar but with adjustments |
|
|
Term
|
Definition
| observes trends, past and history ...uses complex mathematics. very similar, but nothing like homedepot vs mcdonalds |
|
|
Term
|
Definition
|
|
Term
| 1.Anatomy of a DBMS (1.components) Data Definition (1.data, 2.indices) |
|
Definition
| --1.Raw data/info (names, ids, grades, info) --2. Indices- indexes/ pointers that guide you to the right page/place. Keyword searching capabilities. takes up a lot of storage space Google is 100% indices UT web-More data, less indices |
|
|
Term
| 2.Data Manipulation (1.gui(unclebob) 2. 4gl (modern language)3. 3gl (manipulation of old databases) |
|
Definition
-- 1. GUI interface--allow you to answer easy questions...aimed at "bob's"
--2. 4GL query processors-SQL dominant language of computer. all corporate databases support SQL (used by trained professionals)
--3. 3GL manipulation( cobalt) old language ability to link old system with new. |
|
|
Term
| 3.Data Control (1. maintenence 2. security) |
|
Definition
1.) Maintenance-...housecleaning caused by changing and rearranging data
2.) security- database crashes...back ups |
|
|
Term
|
Definition
| Pointers...like the back of a book that guide you to the right place/page ...searches... |
|
|
Term
HOW IS A DATABASE USED???
BLACK-PRESENT OPERATIONAL VS. WHITE-FUTURE RESEARCH AND PREDICT |
|
Definition
(Black) Operational/Transactional Databases (most used)
1.Ongoing Business activities
2.Dynamic Data
3.Examples
inventory control
Accounting records
Order processing
Scheduling
4.Transaction Processing Systems (TPS)
(White) Analytical/DSS Databases
1. Historical/ Time-dependent Data
2. Static Data
3. Examples
Census/Demographic Records
Sales Forecasting
4. Decision Support Systems
5. Data Mining/Business Intelligence
6. Business Analytics
****this observes the changing over time (stock market) |
|
|
Term
| JUNE 7 (BASIC CONCEPTS PART 2) |
|
Definition
|
|
Term
| corporate america segratages info |
|
Definition
| time frame may,june etc., or by type (male female) designing a database is maliable...and is flexible dependent on who is setting it up. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| -logical design or organization of data -reflects basic structure "parent-child" "belongs to" "ownership " -may translate into physical file structure (hand drawn model that links to the actual database) |
|
|
Term
| hierarchical database model (HDM) |
|
Definition
| Inverted tree (with single root) -parent to child (who do you belong to) college (communication) staff-------Department(adv) staff-----instructor course/section student |
|
|
Term
| relational database model |
|
Definition
| edgar codd a relational model for large shared databases...came up with a new way to organize data.
mathematical/non structural approach
his idea was turned down by ibm and got picked up by oracle
|
|
|
Term
|
Definition
| -model is so easy to use/ abuse |
|
|
Term
|
Definition
3 relationships
man-women 1:1(one to one)dont happen often
one to Many (1:N)-happen the most
Many-Many (M:N)( happen all the time |
|
|
Term
JUNE 8
ER DIAGRAMS
ROLE OF KEYS PK&FK
M:N RELATIONSHIPS (BRIDGES)
MICROSOFT VISO TOUR
ALTERNATIVE DB MODELS |
|
Definition
|
|
Term
| relationships w/in tables |
|
Definition
bianary (2 people, 2 relationships, 2 tables)
Uniary-(loops)2 people, 2 relationships, ONE table |
|
|
Term
|
Definition
Primary key ___(pk)
Uniquely identifies record in a table
Foreign Key___(fk)
Uniquely identifies the "parent"record |
|
|
Term
| How do you represent a 1:N relationship |
|
Definition
1.Child record "Points" to its parent record
2.Fk in the child table is the PK of the Parent table
1 to many (point up)
1:1- place restriction-no two men can have the same wife
How do you represent a M:N relationship?
Break the relationship into two 1:N relationships
Store these new relationships as FK's in a new "bridge" or "composite" table. |
|
|
Term
|
Definition
- DDL-....CREATE....ALTER....DROP
- DML-...SELECT...INSERT...UPDATE...DELETE
- DCL...GRANT...REVOKE...DENY
|
|
|
Term
|
Definition
|
|
Term
DDL: Data Definition Language
|
|
Definition
CREATE---LAND READY,READY TO GO
ALTER---REMODELING, ADDING ROOMS..ALLOWS TO MODIFY ONE TABLE/OBJECT AT A TIME...(EX. UTEID)
DROP---BULLDOZER...KNOCKING OUT WHAT IS NO LONGER NEEDED...THERE IS NO UNDO. |
|
|
Term
|
Definition
- CREATE TABLE
- CREATE INDEX
- ALTER TABLE
- DROP TABLE
- DROP INDEX
*THERE ARE MANY OTHER VARIATIONS OF THE CREATE,ALTER, AND DROP COMMANDS. |
|
|
Term
|
Definition
CREATE TABLE TBL NAME (
COLUMN NAME 1 DATA TYPES ATTRIBUTES,
COLUMN NAME 2 DATA TYPES ATTRIBUTES,
TABLE ATTRIBUTES)
|
|
|
Term
|
Definition
CREATE TABLE TABLE NAME(
COLUMN NAME DATA TYPE ATTRIBUTES,
COLUMN NAME
*USE LETTERS AND DIGITS ONLY
NO RESERVED WORDS IN COLUMN
AVOID SPECIAL SYMBOLS
EX...(FIRST NAME)
DATA TYPE
CHAR (X)- (JOHN MOTE)
VARCHAR (X)
INT
DECIMAL (X,Y)
MONEY
DATE/TIME
ATTRIBUTES
NULL OR NOT NULL
DEFAULT VALUES
PRIMARY KEYS
REFERENCES (FK'S)
CHECK CONSTRAINTS (VALIDATING VALUES)
|
|
|
Term
|
Definition
CREATE TABLE tblEmployee(
- FirstName Varchar(20) Not Null
- MiddleName Varchar(20) Null,
- Last Name Varchar (30) Not Null,
- EmployeeID Int (10) identity Primary Key,
- PayType Char (1) Not Null Default "H" Check (paytype='H' or pay type='F'),
- PayRate Money Not null check (payrate>0))
*primary keys cannot be null
*Primary keys must be unique
*Identity works for intergers (do not fill gaps)
check constraignts
|
|
|
Term
| Check number of characters in X |
|
Definition
LenX counts number of charactars in X
LastName Varchar (30) Not null
Check (LEN(Last Name)>=2),
Zip Char (5) Not null
Check (LEN (Zip =5) or Check (LEN(zip=10)
|
|
|
Term
|
Definition
Clustered Index index name
On table name(Column Name 1 order,
ect :)
|
|
|
