Question 2[15 arks] a) Discuss FOUR (4) different techniques used to secure a database. b) Describe with examples, the FOUR (4) types of problem that occur in a multi-user environment when concurrent access to the database is allowed. c) Discuss THREE (3) main issues involved in database technology.

Question 2[15 arks] a) Discuss FOUR (4) different techniques used to secure a database. b) Describe with examples, the FOUR (4) types of problem that occur in a multi-user environment when concurrent access to the database is allowed. c) Discuss THREE (3) main issues involved in database technology.

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Applications

Section: Chapter Questions

Problem 8SAT

See similar textbooks

Similar questions

a) Because of the critical importance of database technology to the smooth running of an enterprise,database systems include complex mechanisms to deliver security. Describe these securitymechanisms.b) What is the purpose of Object-relational database?c) Nowadays, Object Relational Database Management System (ORDBMS) has become verypopular. Briefly describe the approach and features of (ORDBMS).
Question 4 | (a) Give any THREE (3) advantages of implementing a distributed database system. [3 (b) Provide any THREE (3) difficulties that database designer has to face when implementing a distributed database system. (c) The components of a Distributed Database include the following: I. Network Processor, II. Remote data processor, II. Data dictionary, and IV. Local data processor. Explain the function of each of the above components.
a) Identify and discuss four distinct kinds of database systems.The statement "Concurrent transactions may create a variety of difficulties" is correct. Distinguish between some of these issues and the methods by which they may be addressed
Provide a condensed explanation of the three primary stages that comprise the physical design process.The administration of database recovery can be accomplished with any one of these three backup levels. What exactly is the purpose of having many tiers of data backup?
Can you please answer these two questions:question 8 : In a DDB environment, the term used for the ability to easily expand the number of nodes in database is called:A) node replication B) expandability C) Horizontal scalability D) vertical scalability E) ease of usequestion 9: In a DDB environment, the term used for the ability to expand the capacity of an individual node in the database is called...A) Oreferred growth B) Expandability C) node transparency D) horizontal scalability E) vertical scalability
Which of the following statement is NOT correct A. Vendors of RDBMSS don't see any possible threat and promise of OODBMS. B. Vendors of RDBMSs agree that RDBMSS not currently suited to advanced database applications, and added functionality is required. C. Vendors of RDBMSs reject claim that extended RDBMSS will not provide sufficient functionality or will be too slow to cope adequately with new complexity. D. Vendors of RDBMSs claim that they can remedy shortcomings of relational model by extending model with OO features. A) B) D)
1. The first session was focused on DBMS and Object oriented database. a) Because of the critical importance of database technology to the smooth running of an enterprise, database systems include complex mechanisms to deliver security. Describe these security mechanisms.b) What is the purpose of Object-relational database? c) Nowadays, Object Relational Database Management System (ORDBMS) has become very popular. Briefly describe the approach and features of (ORDBMS).
Discuss in detail: (a) the reasons for and characteristics of storing this information in a relational database (including talking about referential integrity and how many primary and foreign keys would be in such a database), and (b) what types of various IT controls and considerations Hiroshi should make to address his concerns. Hiroshi Yoshimura is chair of the Panda Preservation Project, which maintains a database of all panda bears across the globe. The database design includes a relational database comprising two tables. The first table stores the name, birth date, and other characteristics of panda bear parents that have been registered. In this table, each panda bear parent is uniquely identified by a registration number. The second table stores the name, birth date, and other characteristics of panda bear kids that have been registered. In this table, each panda bear kid is uniquely identified by a registration number. This second table also includes the registration…
3. Explain the following in terms of a database's security: Views: (a) authorization; (b) access controls; (c) views: Backup and recovery (d); integrity (e); encryption (f); and RAID technology (g).
Your employer needs a database. He/she is not familiar with database types. Write a memo that explains different database types and the benefits and drawbacks of each (e.g. Object Oriented, relational, object-relational). Keep in mind that your employer may not be in the field of IT so you should avoid technical jargon and provide simple yet clear explanations. Please note you will likely have to conduct some research in order to create this memo.
a) Because database technology is crucial to the smooth operation of a company, database systems incorporate complicated measures to provide security. Describe the security methods in detail. b) Why is an object-relational database used? c) Object Relational Database Management System (ORDBMS) is now widely used. Briefly discuss the strategy and characteristics of (ORDBMS).
Determine the three types of database critical events that might trigger the database recovery process. Provide illustrations of each.Create a list and have a talk about the five transaction attributes.

SEE MORE QUESTIONS

Recommended textbooks for you

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS