Database 1 Essay

535 words - 3 pages

1. What are the main differences between a file-processing system and a database management system?
Ans: A database management system coordinates both the physical and the logical access to the data, whereas a file-processing system coordinates only the physical access.
2. What are the major advantages of a database system? What are the major
Disadvantages of a database system?
Ans:- Advantages
a) Controlling Data redundancy
b) Data Consistency
c) Data Sharing
d)Data security

Disadvantages:-
a) Cost of hardware and software
b) Cost of data sharing
c) Database Failures
d) Complexity
3. Identify some informal queries and update operations that you would expect to apply
to the database shown in Figure 1.2.?
Ans: The database has shown the student information for smith and brown. It also represents the course details. Then it shows the intake of the ...view middle of the document...

List the responsibilities of the database manager. For each responsibility, explain
those problems that would arise if the responsibility were not met?

Ans: responsibilities of data manager:
a) Interaction with the file manager
b) Integrity enforcement
c) Security reinforcement
d) Backup and recovery

If these responsibilities were not met by a given DBM, the following problems can occur
a) If there is no manager interaction then nothing stored in the files can be retrieved.
b) Consistency constrains may not be satisfied, account balances could be low the minimum allowed, employees can earn more in overtime
c) Unauthorized users may access the database.
d) Data could be lost permanently
6. What are the main functions of a database administrator?
Ans: A database administrator (DBA) is an IT professional responsible for the installation, configuration, upgrading, administration, monitoring, maintenance, and security of databases in an organization.
Functions:-
a) Managing data security and privacy
b) Managing Data Integrity
c) Installing and upgrading the database server and application tools
d) Allocating system storage and planning future storage requirements for the database system.
e) Controlling and monitoring user access to the database
7. Discuss the main categories of data models. What are the basic differences between
the relational model, the object model, and the XML model?
Ans: Data Model can be defined as an integrated collection of concepts for describing and manipulating data, relationships between data, and constraints on the data in an organization.
There have been many data models proposed in the literature. They fall into three broad categories:
a) Object Based Data Models. Examples • Entity-Relationship • Object Oriented • Semantic • Functional
b) Physical Data Models
c) Record Based Data Models. Examples:- • Hierarchical Model • Network Model • Relational Model
 

Other Papers Like Database 1

Cloud Database Essay

2610 words - 11 pages 1. Introduction Many have known that the cost server equipment, maintenance and manpower allocation are costly. Furthermore, with the rising cost of server maintenance, electrical cost, manpower cost. New technologies such as cloud computing were introduced to provide alternatives to new and existing companies. One of the cloud computing solutions, cloud database is one of them which propose to move high costly database to be maintain by

Normalization Essay

1733 words - 7 pages Normalization of Database Tables l 4 4 4 Introduction to Normalization of Database Tables Normalization of Database Tables ISM 602 Dr. Hamid Nemati Introduction to Normalization of Database Tables 4 4 4 Objectives The idea of Dependencies of Attributes Normalization and Database Design Understand concepts of normalization (Higher-Level Normal Forms) Learn how to normalize tables Understand normalization and database design

Introduction to Databases

1165 words - 5 pages Introduction to Databases What is a Database? In its simplest term, a Database is an organized collection of related data. It is a structure that serves as a repository for end user data. A database is also commonly defined as a shared collection of logically related data and its description, designed to meet the information needs of an organization. Examples of Databases 1. When you purchase goods from a supermarket, it is likely that a

Strategic Hr

576 words - 3 pages friendly and robust. Learning outcomes On successful completion of this unit a learner will: 1. Understand data models and database technologies 2. Be able to design and implement relational database systems 3. Be able to use manipulation and querying tools 4. Be able to test and document relational database systems. Unit content 1. Understand data models and database technologies Data models: Hierarchical; Network

Database Design Process

1023 words - 5 pages database design Step     Description 1     Requirements collection and analysis 2     Conceptual database design 3     Choice of a DBMS 4     Data model mapping (also called logical database design) 5     Physical database design 6     Database system implementation (Elmasri

Nr439 Research Database Assignment

1661 words - 7 pages years.References:Collier, R. (2012) US National Library of Medicine National Institutes of Health: Hospital-induced delirium hits hard. Retrieved from http://www.ncbi.nlm.nih.gov/pmc/articles/PMC3255198/The Mayo Clinic (2012) Disease and Conditions: Delirium. Retrieved from http://www.mayoclinic.org/diseases-conditions/delirium/basics/definition/con-20033982http://www.uptodate.com/contents/delirium-beyond-the-basics | #1 Database (or collection) (30 possible

Stuffington

2139 words - 9 pages AC571_relational_database_005-019 Male Page 1 of 5 AC571_relational_database_005 Welcome to this refresher on relational database concepts. Understanding relational database concepts is a key to mastering a key theme, REA modeling. As we progress through this refresher, please pay close attention to the objectives being covered as you see on the screen. The objectives are as follows: problems inherent in the flat file approach to data

Joel Hills Paper

2675 words - 11 pages where multiple TestStand executions (threads) can independently communicate with the database. As a result the database API must allow for multiple calls to open, read, write, and close calls. Database Open Wilson will provide a single API call to connect to the database. This call returns a handle that all subsequent database calls will use. Wilson API Inputs Inputs to the Database open function shall be as follows: 1. 2. 3. 4. Database IP

Smith Consulting Database Environment

2637 words - 11 pages model is the foreign key that links to a primary key in the projects table. The entity relationship diagram (ERD) in figure 2.1 depicts this relation as well. The ERD show that one project may have many employees. Relational tables reduce redundancies by eliminating same data duplication and provide easy navigation of the database system. For instance, the database model displays a record with a unique EMP_ID number of 1 for a particular employee

Relational Databases

2149 words - 9 pages Relational Database: Design This paper evaluates four similar web databases and concludes with an overview of considerations for designing web databases. The web databases reviewed are: (a) the Academy of Motion Pictures and Arts (Academy, 2013), (b) IMDb (IMDb, 2013), (c) Complete Index to World Film (Complete Index, 2013), and (d) Labor Film Database (Labor Film, 2013). Table 1 summarizes each database in terms of purpose, target audience

Chapter 1 Essay

852 words - 4 pages Page 31, #1-10 1. Define each of the following terms: a. Data i. Raw facts, information that has not yet been process to reveal their meaning. b. Field i. A character or group of characters that has a specific meaning used to define and store data. c. Record i. A logically connected set of one or more fields that describes a person, place, or thing. d. File i. A collection of related records. 2. What is data redundancy, and which

Related Essays

Database Management Chapter 1 & 2

2003 words - 9 pages these primary keys could be surrogate keys? * In Customer table the Primary key is CustomerID * In the Purchases table the primary key is PurchaseID * Both of them can be generated by the database management system (MySQl). They can be surrogate keys by adding 1. 3. Explain how the two tables you provided in Question 1 are related. Which table contains the foreign key, and what it is the foreign key? * The Customer table has

Cs251 Fundamantals Of Database Systems Ip 1 5

1710 words - 7 pages CS251-1301B-03 Fundamentals of Database Systems Phase 1 -5 Individual Project Robert March 24th, 2013 Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18 Project Outline   My idea for a project concept is for a granite

Database 6th Ch1 And Ch2 Essay

1287 words - 6 pages Chapter 1 Databases and Database Users Review Questions 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. Answer: Data: Facts that can be recorded and that have implicit meaning Database: Collection of related data DBMS

Database Encryptin Solution Essay

1274 words - 6 pages be protected both when at rest and during movement between applications and the database. 2. 1. Database-Layer Encryption In this case, an enterprise is able to protect data as it is being written and read from a database. Database layer encryption is done at the column level within a database table. It can be coupled with access controls and database security so as to prevent theft of critical data. This level of encryption protects data