dilshan DAD.docx - Page 1 J.D.Peiterz DAD Assignment Table of Contents Contents Acknowledgment.3 Task 1.4 1.1 Critically compare different data models

dilshan DAD.docx - Page 1 J.D.Peiterz DAD Assignment Table...

This preview shows page 1 - 5 out of 96 pages.

Page 1 J.D.Peiterz DAD Assignment
Image of page 1
Table of Contents Contents Acknowledgment ...................................................................................................................... 3 Task 1 ......................................................................................................................................... 4 1.1 Critically compare different data models such as Hierarchical, Network, Relational and justify which data model best fits the scenario ........................................ 4 1.1.1 Hierarchical database model .................................................................................. 6 1.1.2 Network database model ......................................................................................... 7 1.1.3 Relational database model ...................................................................................... 8 1.1.4 Object oriented database model ........................................................................... 10 1.1.5 Object relational model ......................................................................................... 11 1.1.7 Star schema ............................................................................................................. 13 1.2 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 ............................................................... 14 1.3 Analyse 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 23 Task 2 ....................................................................................................................................... 27 2.1 Identify entities and attributes of the given scenario and draw an ER diagram by showing different attribute types and cardinality constraints ....................................... 27 2.2 Translate the ER diagram into relational schemas by showing the relation with each through primary keys and foreign keys ................................................................... 27 2.3 Design a relational database system according to the ER diagram you have created .................................................................................................................................. 30 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 ............................................................................. 35 Task 3 ....................................................................................................................................... 38 3.1 Explain the benefits of different manipulation and query tools which can be used to design the relational database system ........................................................................... 38 3.2 Perform following SQL queries using the tables you have created and provide the output gained ...................................................................................................................... 43 3.3 Critically evaluate how different query tools can be used to obtain meaningful data with its unique functionalities ................................................................................... 46 Task 4 ....................................................................................................................................... 54 4.1 Provide a suitable test plan to support the documentation of the testing process ..54 4.2 Provide relevant test cases for the database you have implemented ....................... 55 Page 2 J.D.Peiterz DAD Assignment
Image of page 2
4.3 Create user documentation for a developed relational database system with the help of help menus, Pop ups .............................................................................................. 65 4.4 Provide evidences on how to address verification and validation ............................ 86 4.5 explain how control mechanisms have been used and the importance of these mechanisms for the security of the database .................................................................... 89 Conclusion ............................................................................................................................... 92 Self-criticism ........................................................................................................................... 93 Gantt chart .............................................................................................................................. 94 Reference ................................................................................................................................. 95 Page 3 J.D.Peiterz DAD Assignment
Image of page 3
Acknowledgment Finally, I have completed DAD assignment that our lecture given. Through this assignment I develop my future achievement and it became to me more opportunity to use in future career. Also I would like to express deep debt to Mr. Shivaram Raghu, project guide for her vital suggestions, meticulous guidance and constant motivation which went a long way in the successful completion of this project. I would take this opportunity to thank my batch-mates for their support on helping me at any time.
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 96 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture