A logical data model is required before you can even begin to design a physical database. Assuming that the logical data model is complete, though, what must be done to implement a physical database?

The requirements for a logical and physical database vary by size and design parameters. A logical database must be able to access and identify all files within the storage system to operate ...

Physical: Design a model for implementing the logical model that considers the RDBMS to be used. During this phase, you’ll describe tables, indexes, and so on.

“It allows you to represent the original logical design and the physical implementation of that design and do the mapping between the two inside one data model,” said Santos. Scott Peterson, LSI Logic ...

When building up a logical design, primary keys should be identified by the actual data points in play. Generated or surrogate keys should be held in abeyance until dealing with the physical design ...

Id: 034607 Credits Min: 3 Credits Max: 3 Description. An introduction to databases and Database Management Systems (DBMS). Topics include basic concepts of database technology, an introduction to SQL, ...