What is the difference between data administrator and database designer?
The database designer should understand something of software development and applications structure. The designer will learn from the applications designers the data types, quantities, relationships, and desired operations (searches, sorts, updates, etc.) and work with the developers to design a structure/schema that will meet the requirements of the software application in terms of function and performance and at the same time assure data integrity. The designer will be considering matters such as unique keys, primary and foreign keys, data types, counters, naming, table relationships, search and sort elements, database normalization, search and sort efficiency, and data integrity.
