.:CS 416 - Database Management:.
| .:Lesson 1 | |
|
Intro to Databases |
.:Data
constitutes a valuable organizational resource. Thus, data resources
must be managed effectively to benefit all end users in an organization.
The data resources of information systems are typically organized
into Databases and Knowledgebases... |
| .:Lesson 2 | > > > |
| Types of Databases | .:The
relationships among the many individual records in databases are
based on one of several logical data structures or models. DBMS
are designed to provide end users with quick, easy access to information
stored in databases. Five fundamental database structures are: |
| .:Lesson 3 | > > > |
| DB Planning and Design | .:Developing
small personal databases is relatively easy using microcomputer
DBMS packages. However, developing a large database can be a complex
task. In many companies, developing and managing corporate databases
is the primary responsibility of the database administrator and
database design analysts. |
| .:Lesson 4 | > > > |
| Models and Associations | .:The
goal of designing databases is to produce an information system
that adds value for the user, reduce costs, increase sales/revenue
and consequently provide competitive advantage. |
| .:Lesson 5 | > > > |
| Normalization | .:Normalization
is a structured process that is used to design database tables carefully
to save space, minimize data redundancy and protect the data. |