
1.1 Analysing the important issue and the various applications of database within the organisational environment
DBMS: DBMS or the database management system considers being the accumulation of numerous programs and that provides the opportunity towards the several users and in order to store, edit and collect information or raw data. According to Wei and Yu (2014, p.16), the user always gets the opportunity to access the data or information, whenever the necessity seems high.
The database management system or DBMS comprises of five key components. The essential components of the DBMS consist of software, hardware, data, methods and the users.
Integrity:
The integrity or the data integrity defined as the accuracy, consistency and maintenance of the numerous data that stored and saved utilising the database management tool. The numerous data collected and stored in the database management system ensures the proper maintenance and making the information or data easily accessible. The key components of the integrity consist of consistency and correctness. According to Wei and Yu (2014, p.16), the data integrity or the integrity deals with the accuracy factor of the information or data and the degree of consistency of the numerous data
There consist of four different integrity entities:
Domain Rule
The domain rule associates with providing legal advices in context to setting up or creating a specific domain.
Rational Rule
The rational rule comprises of providing governing regulation and rules for each single relations.
Database R
The database rules associates with the catering of specific rules and that related with the monitoring of relations and interrelationship.
Attribute Rule
The attribute rule refers to providing values regarding attributes in a legal form.
Security:
The database management system or the DBMS consists of unique security systems and that ensures the proper safety and proper maintenance of the informations or data. The database security systems comprises of the data encryption, where the various informations or data gets protected by a security layer known as Cipher. The security measures also comprises of data backup system, which saves a copy of raw information or data in another location. The security measure also comprises of security layers and that prevents unauthorised data transmission (databasecompare.com, 2017).
Recovery
The recovery system comprises of restoring the system directly in correct stages and always checks the errors and protects the system. The recovery system also assists in the revision of files. The database can easily recovered on redundancy within the physical level.
Redundancy
The data redundancy comprises of various usefulness such as, the data must not get copied, ensuring less allocation of space, the irregularity in context to data must get minimised. The data redundancy manages and controls the replication of data.
The database integrity considers being the most important ingredient of the entire database management system. As per Labrinidis et al. (2014, p.86), the various issues generated during the process or designing of the physical structure of the whole database design. The issues can summarise as;
The method or format of choosing numerous information or data and furthermore selecting the storage procedure of the archived data need proper emphasise.
The grouping attributes of the data or information retrieved from the logical data structure or model and converting them into physical records.
The process of arranging identical structured informations or data and storing those informations or data in the secondary memory. This particular collection of data can easily saved, extract whenever required and easily updatable.
The selection of structures needs to specify and in order to make the process of connecting various identical and non-identical files and making the process of retrieving the data in a more efficient manner.
database design tool assignment help,database design software assignment help,database design example assignment help,
Best Services
Managing time was challenging for me, but I got the solution to my problems when I hired their experts. They are there to write my college projects, and I need not worry about the grades at least.
Best Services
Thanks guys, I’ve been taking their services for the past five months and was never disappointed.
Best Assignment Help Melbourne
I have so far ordered four hospitality and tourism assignments with this website. For two of the assignment they were done very nicely with all proper writing, referencing and citations and I got a good grade distinction for both of them. I am really happy with the outcome of this Australia assignment help service. My third assignment was actually a dissertation proposal and literature review writing assignment for customer relationship management hospitality course and that one needed a little bit modification as suggested by my professor. I immediately reported the feedback to Cheapassignmenthelp.co.uk and these guys provided me 2 times free rework and in the end that assignment also I got a distinction. So all is well and good for me. I normally pay a decent charge to get a decent quality assignment but I am happy with the overall quality of assignment writing, literature review is good and standard journals and references are used by the writers. Overall customer care is also very helpful and makes sure that I am given a good attention to understand my order details and any rework. Its a fast service and I have received most of my work before 2 days deadline also.
I would give you ration 10
This online assignment site has not only impressed me but my parents as well. After my school, my mother had to spare some extra time to help me with my homework’s and projects and because of this she frequently have to take half time from her office. But from the time I interact with the members of this site, all the problems are completely resolved. I can stay at home and learn under the guidance of expert and my mother no more need to take leave from her work. My grades also showed good improvements. So this site have erased our problems and helped me learn in the homely environment.
Complete your assignment with cheapassignmenthelp.co.uk
It has been a long time when I was working on the project given in the college, but still, I failed to complete it in the desired manner. The date of submission was near and I was worried about the work. Then I got to know about this site from different friends. My work was completed before the allotted time and that too in very impressive and effective way. Cheap assignments were appreciated by teachers and all my fellow classmates. It was a great feeling….
- Communication Styles Differ Culture Assignment Help UK
- Hospitality Management Simulations Assignment Help UK
- Visitor Behavior Management Assignment Help Uk
- New Graduate Application Assignment Help Uk
- Case Study Assignment Help UK
- Taxation Theory Law Assignment Help UK
- Financial Analysis Coca COla Amatil Assignment Help Uk
- Strategic Information Systems Business Assignment Help Uk
- Market structure Absolut vodka Nepal Assignment Help Uk
- Business Scenario Stitches Assignment Help Uk
- New Graduate Application Assignment Help Uk
- Leadership Models Critical Discussion Assignment Help Uk
- Taxation Theory Practice Law Assignment Help Uk
- Corporate Accounting Assignment Help Uk
- Developing Corporate communications Tool Assignment Help Uk
- Strategic Decision Making Health Care Assignment Help Uk
- Mkt 306 Marketing Strategy Assignment Help Uk
- Strategic Information System Assignment Help Uk
- Managerial Accounting Assignment Help Uk
- Database Design Concept Assignment Help Uk
- Advantages Disadvantages Using Social Networks Business Assignment Help Uk
- Visitor Attraction Management Assignment Help Uk
- Business Research Assignment Help Uk
- Health Service Old Aged People Assignment Help Uk
- System Science Engineering Assignment Help Uk
- Law Contract Assignment Help Uk
- Corporate Accounting Assignment Help Uk
- Financial Analysis Assignment Help Uk
- Human Happiness Cpm Hrm Assignment Help Uk
- Managing Human Capital Assignment Help Uk
- Integrated Capstone Project Assignment Help Uk
- Organisational Behaviour Assignment Help Uk
- Stem Cell Assignment Help Uk
- Developing Manager Assignment Help Uk
- Evaluate Marketing Opportunities Assignment Help Uk
- Commercial Law Assignment Help Uk
- Finance Funding Travel Tourism Assignment Help Uk
- Analyzing Travel Tourism Sector Assignment Help Uk
- HI5019 Strategic Information Systems Assignment Help Uk
- Human Resource Management Service Assignment Help Uk
Data Flow Diagram

Data Flow Diagram
1)Introduction
This report is prepared for the Acme Garage case study. The Acme garage specializes in repairing the cars. Presently the Acme garage update and maintain its various data such as; customer data, suppliers’ data, car parts invoice data, etc. in the Microsoft Excel spreadsheet. We investigate the overall business and business purpose of Acme garage. We observe the data flow of the business data of Acme garage and made a new database system for it, so that it can easily maintain their various business data. We choose the Microsoft Access to develop a new database system for the Acme garage.
1)Introduction
This report is prepared for the Acme Garage case study. The Acme garage specializes in repairing the cars. Presently the Acme garage update and maintain its various data such as; customer data, suppliers’ data, car parts invoice data, etc. in the Microsoft Excel spreadsheet. We investigate the overall business and business purpose of Acme garage. We observe the data flow of the business data of Acme garage and made a new database system for it, so that it can easily maintain their various business data. We choose the Microsoft Access to develop a new database system for the Acme garage.
Data Flow Diagram
2)Business Overview
Structure
The Acme garage is providing the car repairing services to their customers. When the customers comes for repairing their cars, the Acme always check the customer has paid previously for work done or not before fixing the car. After the car repair and ready to deliver to the customer, an invoice report of whole work done is provided to the user after this the customer needs to pay the full amount within 30 days.
The acme kept the detail of the customers and job in the customers file and job file respectively.The employee who is responsible for updating and maintaining the database, maintain the database. The mechanics are repairing the cars and also write the entries into the job book. Its stock the car parts which is used frequently and purchase it’s from the parts supplier regularly. The parts which are used less frequently are ordered to the suppliers when required; the Acme is invoiced by the suppliers for purchasing of these parts. Reference to the Stock file will indicate if parts required for a particular job are in stock otherwise the parts will have to be ordered in. In case where items are removed from the stock, the balance of stock needs to be reduced.The cost of the car parts is added from the invoice which is received at the time of delivery of parts. After completing the job, hours of labour are maintained in the job file and the stock file. The order file will be used to determine the parts price which will record in job file also. Finally, the job file helps to produce an invoice for the customer. At the end of the month all the invoice will be paid in full sent from the supplier.