We today’s lecture we will: Define key database design terms, explain the role of database design in the is development process, transform E-R or class diagrams into normalized relations, merge normalized relations from separate user views into a consolidated set of well-structured relations, choose storage formats for fields , translate well-structured relations into database tables, explain when to use different types of file organizations, describe the purpose and appropriate use of indexes.