Please enable JavaScript.
Coggle requires JavaScript to display documents.
Chapter 9 (Data Design) (DBMS Component (USERS, DATABASE ADMINISTRATORS,…
Chapter 9 (Data Design)
data design concept
data structures
DBMS Advantages
scalability
economy of scale
enterprise-wide application
stronger standards
DBMS Component
USERS
DATABASE ADMINISTRATORS
RELATED INFORMATION SYSTEM
Data manipulation language
schema
physical data repository
web based data design
objective to connect to the web
data security
characteristic -refer slide 12
data design term
entity
table or file
field
record
key field
primary key
candidate key
foreign key
secondary key
referential integrity
rules that are set to avoid data inconsistency
drawing ERD
relationship
one to one
one to many
many to many
Cardinality
crow's foot
data normalization
unnormalized design
first normal form
second normal form
third normal form
CODES
type of codes
sequence codes
block sequence codes
alphabetic codes
category codes
abbreviation/mnemonic
significant digit codes
derivation codes
cipher codes
action codes
data storage and access
tools and techniques
data warehousing
data mining
logical vs physical storage