This website uses cookies to ensure you have the best experience. Learn more

Database Management Chapter 2 Essay

416 words - 2 pages

1. Besides redundancy, what other problems are associated with the nondatabase approach to processing data? Another problem with the nondatabase approach is accessing related data. In order to access data that is related to one another, you would have to open multiple spreadsheets, nondatabase systems also have way less security features than a database system.
2. What is a relationship? A one to many relationship? A relationship is an association between entities. A one-to-many relationship is a relationship where one entity is related to a group of entities, and everything in that group of ...view middle of the document...

4. What is a DBMS? DBMS stands for database management system, which is a program, or collection of programs, through which users interact with a database.
5. What is a form? A form is screen object used to maintain, view, and print data from a database.
6. What is meant by the sharing of data? Sharing data allows many different users to have access to the same data, if one user changes or updates that data the changes will be visible to all users.
7. How does consistency result from controlling redundancy? Without redundancy there is more efficiency, and with efficiency comes consistency?
8. What is security? How does a DBMS provide security? Security is the prevention of unauthorized access to the database. A DBMS provides security by assigning passwords to authorized users. A DBMS can also assign users to groups, and all the users in those groups can be restricted from certain data.
9. How is file size a disadvantage in a database environment? File size is a disadvantage because a database is a large program that occupies a great deal of disk space and memory.
10. Why can a failure in a database environment be more serious than an error in a nondatabase environment? A database is a lot more complex than a nondatabase system. If there is an error in a database everyone who is using that database will be affected, but in a nondatabase system a failure will only affect one system.

Other assignments on Database Management Chapter 2

System Inventory Essay

650 words - 3 pages |The DBMS will house |Drivers, Fleet |Ease of use – This DBMS has a | |Database Management |an information | |all the maintenance |Maintenance, and the|familiar Windows ‘look and | |System |management tool that | |data tables for |entire organization.|feel.’ | | |helps you store

Accounting System Essay

4830 words - 20 pages CHAPTER 4 RELATIONAL DATABASES SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 4.1 Contrast the logical and the physical view of data and discuss why separate views are necessary in database applications. Describe which perspective is most useful for each of the following employees: a programmer, a manager, and an internal auditor. How will understanding logical data structures assist you when

Unit 5

325 words - 2 pages 1.) Choosing a database management system requires a great deal of analysis. TRUE 2.) When choosing a database management system, you should consider system compatibility and hardware requirements. TRUE 3.) Only insert and update statements are part of a database transaction. FALSE 4.) Physical design is independent of any particular database management system. FALSE 5.) A data type is a column specification that determines what

Information Technology

3433 words - 14 pages -based personal computers and was first released in 1991. -Hypertext Markup Language (HTML): A page description language for specifying how text, graphics, video, and sound are placed on a Web page document. -Extensible Markup Language (XML): Foundation technology developed by World Wide Web Consortium (W3C), Presentation, communication, and storage of data. Chapter 6 Foundation of business intelligence: databases and info management -Database

Online Course Registration System

2760 words - 12 pages SRS Document Of Course Management System Course Management System 1. Introduction 1 1.1 Purpose 1 1.2 Scope 1 1.3 Definitions and abbreviations 1 1.4 References 1 1.5 Overview 1 2. Overall Description 2 2.1 Product Perspective 2 2.2 Product Functions 2 2.3 User Characteristics 4 2.4 Constraints 4 2.5 Assumptions and Dependencies 4 3. Specific Requirements 4 3.1 External Interface Requirement 4


2471 words - 10 pages chapter 1 of set text) has pursued which type of unmatched competitive advantage: a) offering advanced viral marketing techniques b) offering products at world’s best price c) offering sophisticated use of AdNews d) offering advanced use of email marketing 2) Given that The Nook is a bar with a small food menu, what type of data do you think this establishment should collect from a single transaction: a) amount spent by customer b) what food


1179 words - 5 pages printer, that hasbeen made sharable with other users on the network.   8 Chapter 2REVIEW OF RELATED LITERATURERelated LiteratureForeign According to Robson (2001), usability is a key requirement for users, saysElisabeth Robson, Product manager for Online Computer Library Center. The cataloguehas become a way to pull together disparate resources, including commercial resourcesand web links. management systems also allow circulation, including


318 words - 2 pages the DBMS and the application programs run on. This can range from a single PC, to a single mainframe, to a network of computers. (2) Software: The DBMS software and the application programs, together with the operating system, including network software if the DBMS is being used over a network. (3) Data: The data acts as a bridge between the hardware and software components and the human components. As we’ve already said, the database contains both the operational data and the meta-data (the ‘data about data’).

Information System

457 words - 2 pages Executive Summary The aim of current report is to critically evaluate a Non-Core Asset Disposal Database recently implemented in the Organization in a Pilot mode to replace the existing Excel spreadsheet system and based on the findings to make a recommendation to Company Management whether the current system should be extrapolated all over Organization in a regular working mode or the Pilot is inefficient and should be stopped. Updated

Database Systems For Business

2877 words - 12 pages customer has shopped at M&S may be represented in the database, but the customer would be unaware of this information. TASK 2 “A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure and file

Sniffer Technology For Detecting Lost Mobiles

651 words - 3 pages Introduction 1 * 1.1 Wireless Sniffing 1 * 1.2 Network Sniffing 2 * 1.3 Motivation 3 * CHAPTER 2 IMEI 5 * CHAPTER 3 Designing for the Sniffer 6 3.1 Sniffer base station 6 3.2 Design of unidirectional antenna 6 3.3 Software for

Similar Documents

Database Management Chapter 1 Essay

859 words - 4 pages Principles of Database Management Systems Homework 1 Ying Li 4861521 Homework 1 Exercise 1.4 Explain the difference between external, internal, and conceptual schemas. How are these different schema layers related to the concepts of logical and physical data independence? Answer: External schemas, which usually are also in terms of the data model of the DBMS, allow data access to be customized (and authorized) at the

Database Design Paper

404 words - 2 pages Design Implementation and Management (10th ed.). Mason , Ohio: Cengage Learning. 2. Coronel, C., Morris, S., & Rob, P. (2013). Database Systems Design Implementation and Management (10th ed.). Mason , Ohio: Cengage Learning. tabase design paper

Pt2520 Homework 1 Essay

305 words - 2 pages Unit 1 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1) At its simplest, a database can be seen as a collection of related data. 2) A delimited file is a file where the length of the file is limited. 3) A delimited file is one in which the data is separated by a character such as a comma. 4) All fixed length files are of the same length. 5) In relational databases

Google Adsense Essay

1588 words - 7 pages in a manner so that in future it would be easier to obtain that information. Reginald has to follow database management system, because it is good system in case of recording information. For example, customer’s information, has primary and a foreign key, suppose one column has primary key as customer id, and second column containing the information about the customer has specific reference as customer id, which is foreign key, which identifies