01-10-2012, 12:36 PM
Introduction to Database Design
normal forms DBMS.ppt (Size: 583 KB / Downloads: 51)
Application Requirements
What kind of database?
OnLine Analytical Processing (OLAP)
OnLine Transactional Processing (OLTP)
Budget
Platform / Vendor
Workflow?
order of operations
error handling
reporting
Entity - Relationship Model
A logical design method which emphasizes simplicity and readability.
Basic objects of the model are:
Entities
Relationships
Attributes
Relationship Connectivity
Constraints on the mapping of the associated entities in the relationship.
Denoted by variables between the related entities.
Generally, values for connectivity are expressed as “one” or “many”
Team Relationships
Identify the relationships.
The player statistics are recorded at each game so the player and game entities are related.
For each game, we have multiple players so the relationship is one-to-many
Logical Design to Physical Design
Creating relational SQL schemas from entity-relationship models.
Transform each entity into a table with the key and its attributes.
Transform each relationship as either a relationship table (many-to-many) or a “foreign key” (one-to-many and many-to-many).
Tutorial
Entering the physical design into the database.
Log on to the system using SSH.
% ssh user[at]ds003.sdsc.edu
Setup the database instance environment:
(csh or tcsh)
% source /dbms/db2/home/db2i010/sqllib/db2cshrc
(sh, ksh, or bash)
$ . /dbms/db2/home/db2i010/sqllib/db2cshrc
Run the DB2 command line processor (CLP)
% db2