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

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
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.
Define the ACID properties in the context of database transactions. How do they ensure data integrity?
Questions: p/s : the first column first row (highlighted) is 1 a) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.7. b) How many different data sources are likely to be used by the file you examined in problem a? c) Given your findings in Problems a and b, how would a relational database environment help eliminate the data redundancy problems? d) Given your answer to Problem c, how many tables would you use to substantially eliminate the data redundancy problems? What table structures would you recommend? e) Given your answers to problem d, show the table contents for each table. f) Identify the types of relationships (1:1, 1:M, or M:N) between the tables you defined in problems d and e. g) Create a relational schema for Problem f.
When comparing database replication and database fragmentation, what are the primary distinctions between the two?
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.
What type of scenario would fall under a siloed database issue in relation to database migration challenges? a.) Having the physical drives get damaged during migration b.) Having data be read by a third party during the transfer c.) Having disparate databases that exist within various parts of the company d.) Having personally identifiable information be acquired
a) Assume that two students are trying to register for a course in which there is only one open seat. What component of a database system prevents both students from being given that last seat? b) List four significant differences between a file-processing system and a DBMS

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