Database Design Concepts part 2

This is a solution of Database Design Concepts part 2 in which we discuss in the organization a huge number or volume of data accumulated such as: customer data, product data, employee data, product delivery data, and many others data.

Database Design Concepts part 2

Database Design Concepts part 2

Task1B three distinct advantages concerning what a database management system provides to any organization

Here in the project of Fresh Burgers Now, we have used the relational database as this business  includes a lot of data and information which needs to be updated regularly and the data will increase daily. The data of Fresh Burgers Now is complex and is very large.
FreshBurgersNow currently has a large collection of raw data on its employees, registered customers, sales order, products, and so on; and data will be accessed concurrently by the employees to track down customer orders and delivery, as-well as for the owner of the franchise to decide on drastic business decisions.
The workers and franchise owner should be able to get quick answers about the raw data, make and apply quick changes to the data consistently and certain part of the data such as salaries should be restricted to the workers.To run a successful and efficient Burger business, data needs to be organized and electronically filed in a cabinet and its content managed by a collection of software programs to provide accessibility, speed, and accuracy to the data, without altering the features of the data. The collection of software programs, which also serve as an intermediary between users and the database, is called a database management system (DBMS). Using a database management system (DBMS) will help in keeping track of huge customers, service database, check sales and stock through real-time report determine the customers, and employee details, multi user capability, reduce operating expenses, as well as improve client relationship. The using relational database management system in this organization has many advantages; some of them are given below:
1.Data is stored once only: There are various advantages of this like we need not to change a lot of record in the database which is a very big relief to a database administrator. The information or data can be stored more efficiently and easily in the tables of the relational database. This makes every new user to get friendly with the database quickly and easily. This is a reason for using relational database in our database for Fresh Burgers Now. As in this business, very frequently the employees may change. The relational database will be very easy for them to learn quickly the effectively. It is very simple to add, delete and modify the data or information of the users in the tables of the relational database. If we change or modify the record of any table in the database, then the updating in all the records having a link between them will be done automatically in the relational database. This is a very big advantage of using a relational database as the administrator need to update the data in each and every table of the large and complex databases.
2.Complex queries can be easily fired: A very famous language structured query language (SQL) is used to fire the queries in the database. Now the question arises what is a need to use a query in the database. The query is used to easily add, delete and update the data or information of the user in the database. Also if the administrator or the manager of the company need to find out any specific data from the large and complex database, then instead of searching for the data in all the table, he can easily use a query and find out the data from the huge and complex database. The complicated queries can be easily used in the relational database to find out all the related data from all the tables in the database. In this project for Fresh Burgers Now we have also used various complex queries to find out some related data from all the links of the tables from the relational database.
3.Better security: In relational database, we can split our records in various tables andthe tables can be related to each other. Through splitting the data, we can give confidentiality to our tables from the unauthorized access. When any person logs in to the system by using the username and password, the system limits him to access the data due to unauthorized view. The user can see only those records whose view is authorized.
Cheap Assignment Help UK provide assignment writing service based on case study requirements in affordable prices and we are providing most flexible online assignment writing help, so book your Assignment with us, order now

Comments

Post a Comment

Popular posts from this blog

Unit 4 Managing Quality in HSC

Image
Unit 4 Managing Quality in HSC 4.1 Evaluate me thods for evaluating anchor service quality with regard to external and internal perspectives. There are numerous methods for evaluating anchor service quality such as focus groups structured and semi structured interviews panels and complaints procedures. First is Marketing as marketing depends upon the needs of the customers then second comes service marketing which helps in understanding the nature of services and the quality of services provided ; and third is the service quality models which are used commonly within the service marketing discipline. Also there can be other means like questionnaire survey with the customers to evaluate and know their feedback toward the services provided by Anchor care home. Road shows can be held for knowing the response of public. For evaluating anchor care service quality healthcare providers take interests in the different perceptions while anchor itself seeks for cost minimizing issues a...
Read more

Unit 35 Web Application Development

Image
Unit 35 Web Application Development Module Booklet Unit 35 Web Application Development Unit   Unit35: – Web Application Development Unit level 5 Unit code K/601/1510 Credit Value 15 Qualification BTEC HND in Computing and Systems Development Term Start Date 20 November 2017 Hand out date 20 November 2017 Submission Deadline 18 February 2018 Lecture 9 weeks Revision Clinic 1 Week Module Leader Rafiqul Islam Lecturer Ekereuke Udoh   Copyright Statement: This document is the product and property of the UK College of Business and Computing and therefore may not be: shared with any external third party; reproduced in full or in part; or used in any other related manner whatsoever, without prior expressed written permission. This statement is for the attention of students, staff and external parties. In the case of copyright infringement, legal action will be exercised Introduction   The internet has emerged as a do minating area of IT developmen...
Read more

Unit 5 Marketing in Travel and Tourism

Image
Unit 5 Marketing in Travel and Tourism Module Booklet   Qualification Pearson BTEC (HND) Travel and Tourism Management Unit 5 Marketing in Travel and Tourism QCF level 4 Unit code R/601/1744 Module type Core Credit value: 15 Block start date 05 June 2017 Issue date 05 June 2017 Assignment submission date 13 August 2017 Lectures and formative assessment 10 Weeks Guided learning hours 60 Module leader Mr  K.A Mayah Introduction   Aim This unit enables learners to understand the concepts, principles and role of marketing and the marketing mix, and gain skills to use the promotional mix in travel and tourism. Unit abstract The aim of this unit is to develop learners’ understanding of the key concepts and principles of marketing as they apply to the travel and tourism sector. The unit aims to equip learners with the knowledge and understanding of the key factors affecting marketing environments and the role of marketing in different industries withi...
Read more