Class Notes (1,100,000)
CA (620,000)
Ryerson (30,000)
RMG (300)
RMG 300 (40)
Lecture

RMG 300 Lecture Notes - Database, Scalability


Department
Retail Management
Course Code
RMG 300
Professor
Norman Shaw

This preview shows half of the first page. to view the full 2 pages of the document.
Database Management System (DBMS) Organizes data
Entity Relationship Diagram (ERD)
Database consists of Tables
Table consists of Records
Records consists of fields
Fields consists of Bytes
When data goes in (Information Quality)
Accuracy
Completeness
Consistency
Uniqueness
Timeliness
Security:
Levels
oTable
oRecord
oField
Control
oRead
oWrite
Data Dictionary:
Field Name
Type
Form
Default Value
Validation Rule
Database Advantages Organized
Data Base Admin (DBA)
Database Capabilities:
Scalability Able to handle growth
Performance Processing Transactions
Non-redundant Storing data once and only once
Databases good for:
Updating
Adding records
Extracting info
Structured queries
www.notesolution.com
You're Reading a Preview

Unlock to view full version