This week introduces the basic techniques to build basic relational
database schema objects, including tables, views, sequences, synonyms
and indexes. This is an important week for you to be able to develop
your own database. The week also introduces data dictionary and
its views, which is used extensively for database management. The
following lists some important learning objectives for this week.
- Understand the concept of database schema, its relation to database
user.
- Understand database tables: columns and datatypes.
- Know how to create and modify database tables.
- Understand the concept and application of constraints.
- Know how to create and modify constraints.
- Understand the concept of views and know how to create views.
- Know how to create and use sequence.
- Know how to create and use synonyms.
- Understand why indexes are needed, and types of indexes.
- Know how to use database indexes.
Students: The content for this week is spread out in several places in your textbook. But, my class notes have all in one chapter.
Have fun.
|
