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.
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.
· Replacement of the static files: There is a clear separation between the physical and logical representation of the data
· Relational databases have another advantage of representing the domain universe
· This DBMS system is easier as compared to other DBMS for adding, removing or deleting, updating and associating the data
· With the help of relational database management system, it is an easy task for searching the specific data or for sorting them
· Database management system can be termed as various open source along with the commercial implementations of the concept based on database
· The model based on relational database management system, which can help to resolve the common errors such as duplication of data, redundancy of the unneeded data and non-optimized data relation.
Database is being used from the prospective of the model application such as mobile application and web application
Mobile application: Native mobile applications have been using the DBMS system for considering the limitations of mobile computing such as disk resources and battery. For example, SQLite, it is a kind of mobile friendly database
Web application: In web application, with the use of the architecture based on 3-tier, these applications are used as the platform of social media, education sector, banking services and many others as well. These areas of organization are utilizing the resources of database to manage their data.
Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...
55 - Completed Orders
Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...
52 - Completed Orders
Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...
102 - Completed Orders
To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...
109 - Completed Orders
JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...
202 - Completed Orders
Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...
20 - Completed Orders
Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...
100 - Completed Orders