Database Design and Development

Module	Outcomes
Analysis	Identify the end-user and functional requirements of a database problem that relates to the implementation at this level.
Design	Describe and exemplify entity-relationship diagrams with two entities indicating: entity name attributes name of relationship cardinality of relationship (one-to-one, one-to-many, many-to-many) Describe and exemplify an instance using an entity-occurrence diagram Describe and exemplify a compound key Describe and exemplify a data dictionary with three or more entities: entity attribute name primary and foreign key attribute type: text number date time boolean attribute size validation: presence check restricted choice field length range Exemplify a design of a solution to the query: taables and queries fields search criteria sort order calculations grouping
Implementation	Implement relational databases with two linked tables, to match the design with referential integrity. Describe, exemplify and implement SQL operations for pre-populated relational databases, with a maximum of two linked tables: select from where: AND, OR, <, >, = order by with a maximum of two fields insert update delete equi-join between tables Read and explain code that makes use of the above SQL.
Testing	Describe and exemplify testing: SQL operations work correctly at this level
Evaluation	Evaluate solution in terms of: fitness for purpose accuracy of output