Unit17 Database Design Concepts
This assignment is based on the concept of database design, which is helpful for storing the data in a secured manner and avoiding the possibility of data redundancy. In this assignment, it is required for developing an understanding of the concepts and issues regarding the database management system as well as its design. Moreover, there is a requirement of practical skills for translating that previous understanding into the creation of all the complex databases and into the design as well. The objective of making this assignment is to understand the advantages, issues and applications of the DBMS and databases. In this assignment, there are 3 tasks which are required to be done, each of the tasks have various objectives, moreover, for completing this assignment, a research based on case study has been done. In addition to it, for giving an effective reflection and for getting the best outcome, various supportive materials such as websites, books and journals have been involved. This assignment is also based on the analysis of methodology related to the development of the database, for that, there is a need of database developer, who can analyze it and evaluate the entity relationship.
1.1 Analyzing the key issues and application of databases within the environment of organization:
A database can be referred to the structured system or management or organization of files in accordance with a specific data model. Relational database is the collection of data items, which are organized as a set of tables, the relational data model can be the base of relational databases. Furthermore, database management system or DBMS can be considered as an important aspect of data processing and data storing. DBMS involves various data models which are evolving into various software packages of DBMS (Siau and Rossi, 2011, p.250). There are various commercial DBMS available in the market such as ORACLE, SQL, INGRES and Sybase.