Database design is the conversion of your logical data model into database objects. The advantages of a well thought out database design include the following:
? Good performance
? Parallel data usage
? Low redundancy
? Data integrity
? User friendliness
? You have created and configured a database instance (see Creating and Configuring a Database Instance).
? You have designed a logical data model.
Note the Database Design Tips.
1. Use DDL (Data Definition Language) statements to define database objects. You can create the following database objects, among others:
0 Tables and view tables
0 Columns (including suitable data types)
0 Value ranges and constraints
0 Primary keys
0 Database procedures and functions
SQL Tutorial, Data Definition
SQL Reference Manual, Data Definition
2. You create the database users and assign the required authorizations. See
SQL Tutorial, Authorization
SQL Reference Manual, Authorization
You can use either SQL statements or the Loader database tool to add data to the database. See
SQL Tutorial, Data Manipulation
SQL Reference Manual, Data Manipulation
Documentation for the Loader