Design relationship database three table with epic DVD store Develop prototype, test Assessment 1-4 onlyAccess the conceptual database developed in Task 1Ensure clients considerations are implemented into designIdentify and document database attributesDetermine and document the database data typesAnalyse the information type to be stored in databaseMap conceptual model to a logical data model (such as relational model)Develop an entity relationship diagramUse correct diagram conventions with entity relationship diagram (arrows to set key constraints, thick lines to indicate bijectivity, underlined to indicate keys, etc)Normalise attributes to permit data to be queried and manipulatedCo Identify and confirm primary keys for tablesIdentify and confirm foreign keys for tablesEstablish database management system constraintsDevelop data validation rules (to ensure data entered meets expected data requirements)Identify referential integrity constraints to ensure every value of one attribute of a relation to exist as another attribute in another tableDesign indexes to help organise dataDevelop data dictionaryDocument the full database designPresent and explain the database design to the client Use clear languageEnsure communication is free from jargon