3.QUESTION 1relational databasea.d: Briefly describe row level locking and table level locking and commeit on tie prosand conse. of applying these types of locks.threats:Ransomware.SQL injection.An employee leaving the company.Brute-force password attacks.An employee making mistakes while entering data.A hacker intercepting data sent over the internet.QUESTION 2Use these two tables below to answer the following questions.Figurel (table name: Customers)PersonIDLastNameFirstName AgeMahamaNanaKwakuFrimpong232.AkuaDonkor3.Figure2 (table name: Orders)OrderIDOrderNumberPersonID778951.3.44678224563.2.245624.1.Assume that the sample table: Customers has over 2000 rows of data.Figure 2 also displays sample data in the location table.Write MySQL statement that can be used to create table Customers with PersonID beinga.auto increment.b. Write MYSQL statement to make PersonID in Orders table field a foreign key and aluupdates that happens in the parent table to reflect in the child table write the result.1. Write MySQL statement to rename Orders table to Orders detarSuppose you have the following table:Employees (empID, lastName, firstName, salary)indicates any given value):SELECT * FROM EmployeesWHERE firstName = ? AND lastName = ?SELECT * FROM Employees WHERE lastName = ?SELECT empID FROM Employees ORDER BY salarySuppose there are four indexes as follows:Index1 (empID)Index2 (firstName)Index3 (lastName)Index4 (salary)g. There is a need to improve the performance of all three of the above queries. Select twoindexes from the above list that if built and available will result in an improvedperformance being obtained for all the above queries. Explain your answer.h. Describe three disadvantages of using indexes.QUESTION 3a For each of the following transaction control terms, write a single sentence (no need forextended responses, examples or diagrams) explaining the key concenti Cascaded rollbackii Optimistic lockingiii Pessimistic lockingiv Checkpointa.modules they are studying, and results of assessments for those modultstudents (studID, name, course)modules (modNbr, title, credits)results (studID*, modNbr*, date, grade)Consider the following query:SELECT M.title, S.nameFROM students S, modules M, results RWHERE S.studID = R.studIDAND M.modNbr = R.modNbr2.

“Since you have asked multiple questions, we will solve the first question for you. If you want any…

Answered: a. Explain the support required for…

a. Explain the support required for storing semi-structured data in a relational database QUESTION 1 a, data in a database b. Describe two exon

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Which data structures is most commonly used to index databases ?
The complete picture of data stored in database is known as Schema explain?
Differences between a local area network and a wide area network have the potential to have an impact on the design of a distributed database.
Hospital system (E)ER diagram: Patients are identified by ss#, name, insurance, admittance date, and checked-out date. Doctors are identified by dss#, name, and specialty. Each patient's tests have an id, name, date, time, and results. Doctors run these tests. Convert the (E)ER diagram to a relational database schema. Find all primary and foreign keys.
Explain the concept of two-way data binding with custom data types and complex objects. What challenges may arise when implementing it?
(TCOs 1, 3) Discuss the trade-offs involved in database normalization, including the advantages and disadvantages of normalization, and under what circumstances it may or may not be appropriate.
How do data dictionaries assist in identifying redundant data entries within large databases?
Compare and contrast five (5) Database programming languages (e.g. Python, C++, SQL; but don't use these examples as your answer) by signifying each of the following for the abovementioned concepts: a) Function/Purpose b) Sample Input (Process; Coding) c) Sample Output (In relation to input) Note: Answer this thoroughly.
(TCO 2) Address each of the following:(a) Describe the major activities performed during the Database Design phase of the database life cycle (DBLC).(b) Discuss how the DBLC activities in this phase align with other activities in the software development life cycle (SDLC).(c) Explain how the activities in the Database Design phase contribute to the next phase of the next DBLC phase—Implementation and Loading.
Databases and repositories are two distinct object types. Is there a differentiation to be made between these two possibilities?
A Choice the correct answer:- 1) Storing same data in many places is called a) iteration b) redundancy c) concurrency d) enumeration 2). Larchitectures are common for web applications a) One tier b) Two tiers c) Three tires d) Centralized 3) A state that satisfies the structure and constraints of a scheme is called state. a) invalid b) true c) real d) valid 4) The database state is called. of the schema. a) intension b) extension c) expansion d) definition 5). is the basic object of ER model which is a thing in real world. a) relation b) domain c) attribute d) entity 6) attributes can have more than one value. a) composite b) simple c) multi-valued d) single valued 7) The entity is represented in ER-diagrams by. a) oval b) rectangle c) double oval d) diamond 8). attribute values are used to identify each entity uniquely. a) complex b) unique c) characters d) key 9) The relationships are displayed as in ER-diagrams. a) rectangles b) ovals c) triangles d) diamonds 10) A weak entity type…
Explain the principles of ACID (Atomicity, Consistency, Isolation, Durability) and BASE (Basically Available, Soft state, Eventually consistent) in the context of database transactions.