Relational Database Management System (Dbms) - 1695 Words

Running head: TERM PROJECT Term Project and Proposal Name: University: Course: Date of submission: Abstract Business corporations often require summarized pieces of data in the form of pivot tables for efficient and strategic decision-making. However, the use of pivot tables poses certain data storage problems especially in the light of the need to have the formulas stored with data. This paper presents one data storage situation where using pivot tables for summarizing data was unsuitable because the storage was done using a Microsoft Excel Spreadsheet, stored in XLS format. The project purposes to implement the data storage using a database management system, in this case, Microsoft Access to address the problem†¦show more content†¦This paper implements the solution using Microsoft Access 2007. In this case, the table would have each Employee with the values such as Al and Clara, the Date with values like 1/05/2011, and the Status with values o, wh, and wa. This would result in several records per day but each record would represent only one Employee. With this form of normalization, it is possible and plain to create the desired pivot table. In fact, pivot tables generated from this normalized data would be able to answer questions like â€Å"which employee worked away on a certain day of the month?† Unfortunately, though, this data is stored in a way that the user would not be able to see or even use it at times. There are many benefits of using a database over spreadsheets for storing this kind of data. The following is a list of some of these benefits to the sales business and users: * Database management systems provide for restricted access to * Databases help reduce or avoid data storage redundancy * Persistent storage of data structures and useful program objects like queries and reports * Databases help enforce referential and standards * Databases help in representing sophisticated relationship among vast amounts of data * DBMS provide for database backup and recovery Data elements to be involved: entities and attributes This database system will center on capturing employee details with respect to whetherShow MoreRelatedComputer Is The Security And Reliability801 Words   |  4 Pageslayer of software so-called operating system runs the whole hardware in accordance with the user commands. The OS is the piece of software which allocates the hardware resources to the processes depending on their priority and usage. It thus protects the hardware components from being used by unwanted processes and safeguarding them in real-time. One of the crucial aspect that highlights when dragging a discussion about hardware resources is the Database. A database can be simply defined as the informationRead MoreAcs Assignment 2, University of Winnipeg Essay1448 Words   |  6 Pagesprevious question to a relational database design. Fill each table in your design with data from the previous question such that no information is lost. Show how your design satisfies the criteria for being a relational database, and why it is better to store data on disk in this way rather than all in one table. c) 7 What is database management system? What steps would the hospital ward need to take to prepare its data to be ready for producing meaningful output from the DBMS?d) 5 What are twoRead MoreRelational Database Design And The No Sql Model As The Preferred Basis Of The New Application935 Words   |  4 Pagesuse of relational database design versus the no-SQL model as the preferred basis of the new application. The requirements to consider are: 1. Intensive Usage – Facebook has millions of users worldwide and produce billions of transactions. 2. Growth of the application is expected to be 10% per annum. 3.2 Definitions It is important to look at the key characteristics of these two different models in order to understand the conclusions of this report. 3.2.1 Relational Database ManagementRead MoreCommon Components Of Digital Database Management Applications1022 Words   |  5 Pages A DBMS can also provide many perspectives of a single database schema. A perspective characterizes what information the client sees and how that client sees the information. The DBMS gives a level of reflection between the reasonable diagram which characterizes the legitimate structure of the database and the physical construction that portrays the records, files and other physical instruments utilized by the database. At the point when a DBMS is utilized, frameworks can be adjusted all the moreRead More Relational and Object-oriented Database Management Systems Essay2156 Words   |  9 PagesRelational and Object-oriented Database Management Systems A database is a â€Å"shared collection of logically related data designed to meet the information needs of multiple users in an organization† (Hoffer 709). Databases contain data records or files, such as sales transactions, product catalogs and inventories, and customer profiles. Databases allows multiple users in an organization to easily access, manage, store, and update data when needed. A database management system is softwareRead MoreLogical Data Model And Its Dbms Products1564 Words   |  7 PagesPart 2: Logical Data Model and its DBMS Products: 2.1 Logical Data Model: A logical data model is a data model for a particular problem are presented related to a specific data management technology. Without being specific to a particular DBMS product, it describes the data as much as details (Watt and Eng 2014). As we mentioned before, there is another type of DBMS involved in the logical data model such as hierarchical data model and network data model, which will be discussed in the followingRead MoreFundamentals On Database Management Systems2381 Words   |  10 PagesResearch on Database Fundamentals Fundamentals on Database Management Systems Data and Information Data are raw facts of the block of information. To be reminded that all the data will not useful information. Useful information is fulfilled from processed data. Specially, data is to be explained in order to gain information. Database A database is a well-ordered collection of data that are linked in a meaningful way, which can be contacted in diï ¬â‚¬erent logical orders. A collection of related dataRead MoreMicrosoft Vs. Multi File Database1594 Words   |  7 Pagesdifferent database technologies. Each technology offers its own pros and cons and below is a look at of the most common technologies. Single- vs. multi-file databases A notable different between technologies can be whether they are single-file or a multi-file database. Single-file database Single-file database is the simplest database structure, as it consists of unified information, which can often be used and accessed in a pre-determined manner. Complexity in a single-file database is not commonplaceRead MoreIntroduction to Databases2358 Words   |  10 PagesPart 1 Background Chapter 1 Introduction to Databases 1.1 A database management system provides a number of facilities that will vary from system to system. Describe the type of facilities you might expect, especially those that aid the initial implementation of a database and its subsequent administration. Initially, the type of facilities expected should be described. These include: data storage and retrieval, concurrency control mechanism, authorization services, integrity mechanismsRead MoreProfessional Skills For Information Systems1591 Words   |  7 PagesInformation Systems CIS5100 S1 2017 Submitted By Deepak Chander Jaikumar U1097711 10 May 2017 University of Southern Queensland The database is a collection of related data that is organized in some way so it can be accessed easily and can be managed updated. Relational database management system (RDBMS) is DBMS system that is based on relational model. In this model, data is represented in tuples. The query is the type of request for the information from the database. Database report