User interface : Requirements eg functionality, reliability, consistency, performance, menu driven, HCI interface. 3. Be able to use manipulation and querying tools Data manipulation: Query languages; visual tools; typical tasks eg for database maintenance, inserts, updates and amendments. Queries and reporting: Query languages and query by example (QBE); formatting; functions/formulae; report writing tools. 4. Be able to test and document relational database systems Control mechanisms. example systems eg TQM(Total Quality Management); connection to requirements specification; sign off procedures. Testing procedures : test plans; test models eg white box, black box; test documentation; other eg organisational requirements; user documentation eg help menu, pop-ups, hot-spots.
Assessment Questions: As a member of the software development team, your responsibility is to design and develop database for the project. The project currently going on is to develop payroll software for the organisation. (Select organisation of your choice to collect data) Choose appropriate RDBMS. Based on the following questions, explain how you will carry out your task. Outcome LO1 Task 1 i) Critically compare different data models and schemas. Choose the best model for your database. Present your comparison in appropriate format. [M3] ii) Critically discuss the benefits and limitations of different database technologies. [P2] iii) Analyse different approaches to database design. [P3] iv) Examine database tools and techniques. [P4] Outcome LO2 Task 2 i) Create system requirements documentation for database development. [P5] ii) Design a relational database system to meet a given requirement. [M2] iii) Identify and apply a range of database tools and techniques to build the relational database system based on the system requirements specification with enhanced user interface. [M1] Outcome LO3 Task 3 i) Explain the benefits of using manipulation and query tools in a relational database system. [P8] ii) Implement query language into your relational database system and generate appropriate reports and queries. Provide one sample query. [P9]
iii) Critically evaluate how meaningful data has been extracted through the use of query tools. [D1] Outcome LO4 Task 4 i) Apply all testing procedures to critically review and test your relational database system and take responsibility to control the quality of the product. [D2] ii) Create documentation to support the implementation and testing of a relational database system. [P12] iii) Create user documentation for a developed relational database system. [P13] iv) Explain how verification and validation has been addressed in your system. [P14] v) Explain how control mechanisms have been used. [P15] vi) Demonstrate convergent, lateral and creative thinking in relational database system development. [D3] Outcomes and assessment criteria Outcome LO1 Understand data models and database technologies.
- Spring '16
- Relational Database