Developing a Database Management System Presentation

I am Estelle Lemmer and would like to supply you with a business demonstration outlining the process Klingon Systems has followed in creating a Database Management System for The Borg Collective.

This demonstration will explain just what a Data source Management System is, just what a Relational Repository is and just why this is the best option for The Borg Collective. While describing what queries, forms and information are, it would be explained how we were holding applied and developed in creating the Data source Management System as well as directing out the benefits using these will hold for The Borg Collective.

A Database management system (DBMS) is a pc program specifically developed to store and take care of data. The repository can be queried to provide specific data required and can produce varieties and records relational compared to that data (Baltzan, Lynch & Fisher 2016).

Specifically for the Borg Collective, we have developed a repository management system to store all of your home elevators customers, stock items, suppliers and requests. You'd be in a position to run specific concerns on your computer data to see only the needed information. You would also be able to produce invoices for every single customer.

When making a relational repository, information from different dining tables can be connected to each other. In the relational database you can have one record in one table connected to many information in another desk. As seen on the slide, each of The Borg Collective's information furniture has been connected by using primary keys (yellowish key mark) discovered in each table (Beskeen et al. 2014).

There are several reason behind using a Databases Management System
Easy revise of information: It has been decided a Database Management System is the correct tool for this project and I'll outline why

In considering the data in the Borg Collective it is apparent that it is too sophisticated to only get completed in a spreadsheet. The Borg Collective has data for Customers, Suppliers, Items and Requests. A Spreadsheet is enough for one of these lists of information as an isolated list, nevertheless the Borg Collective has several lists, with a few of the info repeating and associations between data in several columns between different lists. Having to make changes to data in various lists leaves room for error. By using a data source management system, data can be stored in one place, while being referenced in various places as would be referred to later when talking about the different inquiries, forms and reports we have designed for your business. Using a Repository Management System, in case a customer's details changes it only must be done once and would automatically update in for illustration, the customer's invoice, which references it (Manning 2015).

Flexibility: Different users can access data in whichever way suits them. Whether it be a report or a form etc. Information can be queried from the databases and looked at using a variety of rational views or if indeed they so prefer the physical view can be used right where the data is stored.

Scalability: The Borg Collective is only going to develop and a Databases is the only system in a position to adequately manage a huge level of information.

Redundancy: By utilizing a Databases Management System, information only needs to be recorded in one place, minimizing information redundancy and increasing information trustworthiness.

Information integrity: Through the use of combo containers, the DBMS has been developed to restrict the types and format of data that could be inserted and therefor contributing to the integrity of the data (Baltzan, Lynch & Fisher 2016).

There are several reasons for using a Relational Repository

Minimize Duplicate Data: Having to make changes to data in various lists leaves room for mistake. Utilizing a relational database, data can be updated once across multiple desks. Because we have placed this up as a relational data source, when for example one dealer ceases trading and gets deleted from one stand, matching deletions will be prompted and take place in other dining tables, steering clear of data inconsistencies. You would've probably discovered that lots of time is spent coming into the same data into different spreadsheets. Utilizing a relational data source would considerably cut down on the quantity of data access and therefor also reduce room for mistake (Manning 2015).

Faster data entry: Establishing a relational repository we could actually offer you forms making data access faster and easier than by using a spreadsheet

Options for looking at and sorting: Utilizing a relational database, you will see the data by querying it out into varieties or reports, which may be saved to utilize over and over.

Security: Should you choose to, this data source can be encrypted and security password protected.

Several users: As your business develops, you might like to have the ability to have significantly more than one consumer employed in the database. This would be possible using the Relational Databases Klingon has set-up for The Borg Collective (Beskeen et al. 2014).

A data source query is ways to get particular information out into a reasonable view. In this manner you would not want to scroll through long lists of data in various columns and different furniture. The query gets only the required information out and exhibits it for your convenience in a new table (Beskeen et al. 2014).

Five inquiries have been designed for The Borg Collective. These questions can be set you back display the information required the following.

The query labelled Vinyl information will screen the Customers' titles and item information on only items bought in the month of Apr, weighing significantly less than 1 Kg and which is still unfulfilled. The query would also show the order variety. This query has been set-up to enable you to observe how many Star Trek Vinyl Information orders were ordered for Mother's Day but were unfulfilled because of the items being out of stock.

The query labelled Broad Category could be utilized to see how many customers surviving in Victoria, Tasmania and South Australia, have purchased items owned by a wide category from a particular Supplier. When running this query, a Supplier name should be entered, and the following information would be exhibited in a desk: The Customers' names, addresses, Item type, item explanation, dispatch Date and order quantity for all those items owned by a wide category and only for Customers residing in Victoria, Tasmania and South Australia.

The query labelled Cost Increase has been intended to update the cost Price from Luxembourgh of all items that are on order and not in stock by 5. 50% as a fresh Australian import obligation has been added for many products being brought in from the European Union

The query labelled Late Dispatched have been intended to be used when requiring an application to start to see the Queensland customers who've ordered items before the 1st of June, which is at stock, but was dispatched after 10 June. The query may possibly also show information for customers from New South Wales whose purchases are in stock and also have been dispatched after 20 June but was bought prior to the 10th of June.

The query labelled Invoice Calculated may be used to see the information on customers living in New South Wales, Queensland and Victoria, who's ordered something associated with "THE TOP Bang Theory" in-may. As this query would be used to create invoices, it has additionally been created to calculate the value and order totals.

Vinyl information will screen the Customers' labels and item details of only iKlingon has generated two forms that you might use. A databases form can be filled out on-screen which is an easy way to get into and edit data and understand between files (Beskeen et al. 2014).

The Late Requests Form will screen order details stored in the Repository Management System. It could also display the customer's age group entirely years and show a determined dispatch delay in whole days.

The Supplier Items Form will allow you to view the distributor records individually. In addition, it has a sub-form for viewing item details of items sold by that Supplier.

A survey is the best way to print out data from your data source. It offers many formatting, structure and brief summary options. You'll be able to apply different fonts and colors and add images (Beskeen et al. 2014).

Klingon has used this option to build your invoices, which exhibits The Borg Collective's company logo as well as payment details, current particular date, order details and order total.

This presentation has outlined the process which was taken to develop a Database Management System for the Borg Collective. Detailed explanations have been given on just what a Databases Management System is, just what a Relational Databases is and specifically why this was your best option for The Borg Collective. Concerns, Forms and Reports have been defined as well as described why they were developed for The Borg Collective and what their purposes and benefits will be in the business.

It is the genuine expectation of myself, representing Klingon Systems, that the Repository created would be of great advantage towards the Borg Collective and that it would streamline functions, while aiding your business functions to run more efficiently.

tems purchased in the month of Apr, weighing less than 1 Kg and which is still unfulfilled. The query would also show the order variety. This query has been set-up to be able to observe how many Legend Trek Vinyl Figures orders were purchased for Mother's Day but were unfulfilled due to the items being sold-out.

The query labelled Broad Category could be utilized to see how many customers surviving in Victoria, Tasmania and South Australia, have purchased items belonging to a broad category from a particular Supplier. When operating this query, a Dealer name will need to be entered, and the following information would be exhibited in a stand: The Customers' brands, addresses, Item type, item description, dispatch Night out and order amount for those items belonging to a wide category and only for Customers living in Victoria, Tasmania and South Australia.

The query labelled Cost Increase has been created to update the price Price from Luxembourgh of all items that are on order rather than in stock by 5. 50% as a new Australian import duty has been added for all those products being brought in from the Western Union

The query labelled Late Dispatched have been created to be used when requiring a form to start to see the Queensland customers who have ordered items before the 1st of June, which is within stock, but was dispatched after 10 June. The query could also show information for customers from New South Wales whose purchases are in stock and also have been dispatched after 20 June but was ordered before the 10th of June.

The query labelled Invoice Calculated may be used to see the details of customers moving into New South Wales, Queensland and Victoria, who's ordered something associated with "The Big Bang Theory" in-may. As this query would be used to create invoices, it has also been created to calculate the selling price and order totals.

Also We Can Offer!

Other services that we offer

If you don’t see the necessary subject, paper type, or topic in our list of available services and examples, don’t worry! We have a number of other academic disciplines to suit the needs of anyone who visits this website looking for help.

How to ...

We made your life easier with putting together a big number of articles and guidelines on how to plan and write different types of assignments (Essay, Research Paper, Dissertation etc)