Database and Logical Modeling?

 Database:

                A database is collection of permanently stored data used by an application or enterprise. 

A database contains logically related data, which means that the database was created purpose of mind.  

A database supports shared access by many users.
·Protected access to data is controlled.
·Managed data has integrity and value.
·Based on the relational model.

Logical Modeling:

Tables are logically created for all database systems.

The logical model should be independent of usage. A variety of front end tools can be accommodated simultaneously so that the database can be created more quickly. Teradata supports normalized logical models, because we are able to perform 64 table joins and we are to perform large aggregations during queries.

A key Teradata strength is our ability to model the business of customers. Teradata Business models are truly normalized avoiding the costly star schema, snowflake. Teradata can do star schema and other types of relational modeling, but 3NF is recommended.