Introduction to Databases - 2358 Words

Part 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 mechanisms and transaction support. The focus is then on facilities such as data definition, which is stored in the catalog, authorization control to manage the users. View definition, transaction support and integrity controls also aid subsequent†¦show more content†¦The examples should be given using the current DBMS that is in use. The focus is on security and recovery. Security may include authorization mechanisms and associated granting of access privileges. Views and encryption procedures may also be described. These mechanisms should be elaborated. Recovery functions include backup procedures and safe storage of the media, journaling and checkpointing, and the recovery manager. The database administration role should be linked to their use. 2.3 Explain the purpose of the ANSI/SPARC three-level architecture for a Database Management System, and describe its function giving examples to illustrate your points. Detail the components of a Database Management System, explaining in particular the specific functions of the software modules. The answer to the first part of this question is similar to that for 2.1. This question specifically asks for examples to be used, and these should be present in a full answer. To answer the second part of the question, a diagram would be useful. It may show the whole environment – users, DBMS software (expanded), data, and implicit hardware. The emphasis is on the DBMS modules, which need to be explained. These include DML precompiler, Query processor, DDL compiler, Database manager, and Data dictionary. The explanation should include how modules interact with others. 2.4 A database management system provides a number ofShow MoreRelatedcomputer fundamental1111 Words   |  5 PagesSelected objective question on Introduction to Computers with answer :Set 4 1. How many input lines are needed to construct 1024 bit coincident core plane? (a) 8 (b) 16 (c) 32 (d) 64 (e) None of the above. ANS: d 2. A digital computer is based on the principle of (a) measurement 1 / 23 Selected objective question on Introduction to Computers with answer :Set 4 (b) logic (c) multiplication (d) counting ANS: d 3. How many types of storage loops existRead MoreHuffman Trucking Service Request Sr-Ht-003805 Words   |  4 Pagesdesign for a fleet truck maintenance database, located on the Huffman Trucking IT Service Requests site. This paper will talk about how our team completed the Change Request that was on the Huffman Trucking Service Request. 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 relationshipsRead MoreAssignment 3 Business Intelligence and Data Warehouses752 Words   |  4 Pages1. Differences between the structures of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data Data Warehouse is a database which is designed to process for query and analysis rather than for transaction processing, and it is usually contains historical data derived from transaction data, but can include data from other sources while relational database optimized for online transaction which includes insertionsRead MoreAnnotated Bibliography On Non Relational Databases Essay1072 Words   |  5 Pagesof NoSQL databases has risen in the past decade as traditional relational databases cannot handle the vast amount of data as it was not designed to effectively manage such a large data collection. The following research paper gives an introduction to non-relational databases otherwise known as NoSQL. It defines what a NoSQL database is, the origins of its existence and the various types of NoSQL databases. It goes on to discuss the advantages and disadvantages of non-relational databases and the reasonRead MoreDescription Of A Relational Database1366 Words   |  6 Pagesthe gene ralized term to describe a relational database that uses no form of SQL language querying and consists of several data models to define it. My topic of this research paper is the Document Store data model. I will be covering the introduction of the model and its mechanics, how and when the model emerged, its strengths and weaknesses, and it’s real world applications. Introduction and How it Works Document Store or â€Å"Document-oriented database† is a data model within the NoSQL family, madeRead MoreWhat A Nosql ( Not Only Sql ) Database And Document Database Essay714 Words   |  3 Pages â€Æ' Table of Contents 1. Introduction 2 1.1 Purpose 2 1.2 Background 2 1.3 Resources 2 2. Body of Discussion 2 2.1 What are NoSQL Databases 2 2.2 CAP 2 2.3 Base 3 2.4 Polygot Persistence 3 2.5 MongoDB 4 Conclusion 4 References 4 â€Æ' 1. Introduction 1.1 Purpose The purpose of this report will be to understand what a NoSQL (Not Only SQL) database and document database is, specifically MongoDB while looking at the document database. 1.2 Background According to (Edlich, P. 2015) he states that â€Å"The originalRead MoreThe Security Research Of Cloud Database1442 Words   |  6 Pages The security research of cloud database Hao Xu Professor: Carol Auerbach Course Number: EAP 6110 20 Date: 12/1/2014 1. Introduction 1.1 Background In September, there was breaking news in the American entertainment world – private pictures of Hollywood movie star Jennifer Lawrence and other celebrities were leaked online by hacker who stole the pictures from their Apple’s iCloud. People were shocked by this news, and a debate was generated online on whether cloud technologyRead MoreDatabase Analysis : Olap And Database Administration1086 Words   |  5 PagesCHAPTER 14: OLAP AND DATABASE ADMINISTRATION 14.1 LEARNING OBJECTIVE AND OUTCOMES The basics objective to create a well-designed database using basic database commands. lt also provide how to manipulate the stored data and return meaningful results to help analyze the data stored. Upon completion of this chapter, they will be able to: †¢ Create, read, update, and delete data using basic SQL commands. †¢ Perform relational joins and transactions on SQL tables. †¢ Aggregate data through functions andRead MoreComponents Requirements For A Bank Operator1188 Words   |  5 PagesTask 1: Requirement specification Task1a: Stakeholders, functional and non-functional requirements for the coursework specification: Introduction There are about three stakeholders for the system given in the coursework specification identified by the writer; below is the list of them all, together with their functional requirements. The writer has also identified about four non-functional requirements. a) Bank customer (User) The functional requirements of bank customer are: 1. User Login 2.Read MoreSpeeding Up Secure Communication Of Database Using Database Administration1702 Words   |  7 PagesSpeeding up Secure Communication of Database using Database Administration Introduction Marval IT Solutions is a software development company located at Hyderabad. Our company is a strong and has long withstanding relationship with oracle services and its technologies. Our company deals with Customer Relationship Management, Customer Experience, Enterprise Performance Management, Enterprise Resource Planning, Development of Mobile applications, Web Applications. To deliver these services we use