⦁Design a data model using standard EERM constructs and convert this model into a relational database schema;
⦁Use UML notations to produce a design that would encompass procedural aspects of a data management system;
⦁Apply normalisation up to BCNF to a set of relational database tables;
⦁Produce SQL queries to retrieve information from one or more tables;
⦁Write a simple application program in a procedural language that interacts with a relational database.