Assignment title: Information


Explain usage of a number of different types of information systems in commercial use; K2. demonstrate an understanding of emerging trends in database technology; K3. describe the different models of database management systems (hierarchical, network, relational, object); K4. design a relational database for a provided scenario utilising tools and techniques including ER diagrams, relation models and normalisation; K5. describe relational algebra and its relationship to Structured Query Language (SQL); Skills: S1. interpret entity-relationship diagrams to implement a relational database; S2. demonstrate skills in designing and building a database application using a commercially available database management system development tool; S3. use a query language for data manipulation; Application of knowledge and skills: A1. design and implement a relational database using a database management system; A2. utilise a query language tools and techniques to obtain data and information from a database