Introduction A-one+ is a highway engineering provider with the expertise and resources to plan, design, construct, maintain and operate motorways and trunk roads. Primary objective is to ensure motorways and trunk roads operate to the high standard set by Highways England improving user experience and environmental considerations. A scheme management tool is available at AOne+ which is an MSAccess database to track schemes through various stages and reporting with cost estimates for maintenance purposes. This document defines the approach proposed to review current database and re-develop with user friendly frontend/dashboard allowing easy update and reporting. The aim of this scoping report is to outline the understanding of the …show more content…
Again increased data, change in focus of business and decreased speed and efficiency anticipates a new development would be more beneficial than amending the current database. Following table shows the number of data tables, queries and forms which shows the complexity of the current database. Database Table Queries Forms Watchman 144 110 80 Scheme Delivery 75 148 43 The Proposed Development A meeting with the programme manager, database technologist and users at AOne+ is held to discuss possibilities and the new requirements. The aspiration is to re-develop the database increasing speed and efficiency with more functional capabilities in MSAccess 2007 optionally MSAccess 2013. The client endorsed that the database will be used by multiple users and could be shared with other areas of AOne+. Development approach Developing a database reflecting the requirements is complex and it is necessary to follow an appropriate methodological framework. The development approach would be providing client with high levels of understanding and visibility at all stages of the development process ensuring clarity and predictability. A robust and transparent project management methodology will be followed during the development cycle with minimum maintenance. The database development approach is depicted in the following diagram. Development work will be carried out in collaboration with the
Click here to unlock this and over one million essaysGet Access
A database administration framework (DBMS) is a PC programming application that connects with the client, different applications, and the database itself to catch and dissect information. A universally useful DBMS is intended to permit the definition, creation, questioning, upgrade, and organization of databases.
You understand that database technology can dramatically improve your ability to analyze information, compared to spreadsheet technology, and assist you in developing your strategic plans for the cafe. To help you familiarize yourself with databases and their associated business value you need to create a report detailing the basics of databases and why they are better for running a business than spreadsheet applications. Be sure to provide a detailed explanation of relational databases along with their associated business advantages.
The lab begins with a simple example of query development using Access; then, evolves to more complex queries which the student should perform after completing the first exercise. The student can create a query with the wizard, with query design view, or with SQL statements. The Northwind database will be used again in this lab.
Understanding the business model of enterprise and identifying the entities of that model is the first step in setting up database. Requirements analysis includes tasks of determining the needs or conditions to meet. Requirement specification document will be generated at the end of this step.
During this phase, I felt that team collaboration was very important for developing and testing a product. The relational database management system would be more appropriate to replace the existing structure of library system. But, adding new datasets in the existing data library system was the best solution keeping in view the financial constraints of the project.
First our team will talk about how Microsoft Access was used to create these tables by Huffman Trucking Database. Then how we used the tables with made up information to be tested on. Then on how we used forms in the maintenance database system. While the creation of relationships and normalization is explained in the process of using queries to search the database (University of Phoenix, 2007).
A Database Management System or (DBMS) is an essential tool for any organization or company in today’s modern world. A DBMS is “a group of programs that manipulate the database and provide an interface between the database and its users and other application programs” (Stair & Reynolds, 2011, p. 189). So in choosing the right DBMS there are many factoring issues with choosing the right one for the company or organization. When choosing a DBMS one has to think about how the system will ultimately help the company or organization with day to day processes and the goals of the company or organization.
New applications will utilize off-the-shelf software components that have been customized per Riordan’s specifications and further messaged to ensure that each application will integrate smoothly with all the others in order to create a single cohesive whole. Great effort will be made to ensure that the data structures used in each are consistent in order to simplify the creation of the enterprise’s database. To help facilitate this, we will create an umbrella application that will integrate each other system as a module. This umbrella application will be extendable as needed and will act as a single-launch point for the various systems utilized by Riordan. We will also be working closely with Riordan’s IT department to develop a bridge that will enable them to easily port their existing databases into the new one automatically.
This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS.
In the logical database design phase we build the logical representation of the database, which includes identification of the important entities and relationships, and then translate this representation to a set of tables. The logical data model is a source of information for the physical design phase, providing the physical database designer with a vehicle for making tradeoffs that are very important to the design of an efficient database.