Assignment Data Analysis and Design

Task 1: Critically compare different data models such as Hierarchical, Network, Relational and justify which data model best fits the scenario Prepare a power point presentation to critically discuss the benefits and limitations of different database technologies such as distributed database, data warehouse, Data mining, Multimedia database. Analyze different approaches such as Top down and Bottom up which can be used to design a database and justify how these approaches relate to database design Task 2 2.1 Identify entities and attributes of the given scenario and draw an ER diagram by showing different attribute types and cardinality constraints 2.2 Translate the ER diagram into relational schemas by showing the relation with each through primary keys and foreign keys 2.3 Design a relational database system according to the ER diagram you have created (Use SQL DDL statements) 2.4 Provide evidence of the use of a suitable IDE to create a simple interface to insert, update and delete data in the database Task 3: 3.1 Explain the benefits of different manipulation and query tools which can be used to design the relational database system 3.2 Perform following SQL queries using the tables you have created and provide the output gained Display the details of students who have awarded by a grade with particular lecturer’s ID and the lecturer’s name using Join queries Delete all the details of the students who have not achieved a PASSS grade Write an update query with the help of Join queries to update a particular record in the database. 3.3 Critically evaluate how different query tools can be used to obtain meaningful data with its unique functionalities Task 4 4.1 Provide a suitable test plan to support the documentation of the testing process 4.2 Provide relevant test cases for the database you have implemented 4.3 Create user documentation for a developed relational database system with the help of help menus, Pop ups 4.4 Provide evidences on how to address verification and validation 4.5 explain how control mechanisms have been used and the importance of these mechanisms for the security of the database