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

Research and investigate the following scenarios. Include an analysis by providing arguments or counter-arguments and examples where necessary:a) How do older file systems and the database approach differ in terms of the relationship between the data and the application programs?b) What is meant by the term ‘weak entity’? Why is it not possible to represent a many-to-many relationship with two tables?c) Explain what is meant by transactions in the context of a database and why they are needed. Describe the facilities that a DBMS should provide for the support of transactions.
Research and investigate the following scenarios. Include an analysis by providing arguments or counter arguments and examples where necessary: a) How do older file systems and the database approach differ in terms of the relationship between the data and the application programs?b) What is meant by the term ‘weak entity’? Why is it not possible to represent a many-to-many relationship with two tables?c) Explain what is mean by transactions in the context of a database and why they are needed. Describe the facilities that a DBMS should provide for the support of transactions.
Question 1 When multiple transactions execute concurrently in an uncontrolled or unrestricted manner, then it might lead to several problems. These problems are commonly referred to as concurrency problems in a database environment. Explain in detail, by giving examples on any TWO (2) of the common concurrent transaction execution problems.
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.
1
Question 3 Contact tracing is one of the key parameters in knowing persons who have come into contact with people who have COVID-19. The data (name, telephone numbers, address, etc) collected so far are embedded in notebooks which makes it difficult to collate. It has been proposed that a website should be built so that frontline worker all over the country can update the database. You have been given the contract to build a website for this purpose. a) You are to choose an appropriate architectural design for the website b) Design a form that would be used to collect the data c) Write and explain a php code to connect your form to a MYSQL Database NOTE: answer all question
In the section “Disadvantages of File Processing Systems,” the statement is made that the disadvantages of file processing systems can also be limitations of databases, depending on how an organization manages its databases. First, why do organizations create multiple databases, not just one all-inclusive database supporting all data processing needs? Second, what organizational and personal factors are at work that might lead an organization to have multiple, independently managed databases (and, hence, not completely follow the database approach)?
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.- Describe and contrast information needs at the strategic, tactical, and operational levels of an organization. Use examples to explain your answer. 2.- Discuss the importance and characteristics of database backup and recovery procedures. Then describe the actions that must be detailed in backup and recovery plans. 3.- Why are testing and evaluation of the database and applications not done by the same people who are responsible for design and implementation? What minimum standards must be met during testing and evaluation? 4.- What are the levels of data confidentiality? 5.- What are security vulnerabilities? What is a security threat? Give some examples of security vulnerabilities in different IS components.

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