Describe the differences between logical and physical database design. Discuss the objectives of logical design, such as minimizing redundancy and improving data integrity, and the considerations involved in physical design, such as storage allocation and indexing. with diagram or scoring material

n the context of database design, what is the relationship between conceptual, logical, and physical design?Question 15AnswerA.They are interchangeable terms for the same processB.Conceptual design leads to logical design, which informs physical designC.Physical design comes first, followed by logical and then conceptualD.These are completely separate processes with no relationship

Which of the following describes the concept that any change made to the physical schema should not affect the logical level of the DBMS?Logical Data IndependenceLogical Data IsolationPhysical Data IsolationPhysical Data Independence

1.Question 1In which phase of the database lifecycle does the database administrator work on logical and physical design?1 pointExpand2.Question 2Which of the following database objects defines a set of actions performed in response to an insert, update, or delete on a specified table?1 pointExpand3.Question 3What is the first step to modify the configuration of an on-premises relational database?1 pointExpand4.Question 4Database partitions store subsets of data from very large databases. Which of the following environments commonly use partitions?1 pointExpand5.Question 5What is one advantage of physical backups over logical backups?1 pointExpand6.Question 6What does a database management system (DBMS) use transaction logs to do?1 pointExpand7.Question 7What is one advantage of differential backups over full backups?1 pointExpand8.Question 8Assume that a particular database issue, should it occur, is important but does not require your immediate attention. Which automated database feature should you use to inform you when this issue occurs?1 pointExpand9.Question 9Which security method verifies that users are who they say they are?1 pointExpand10.Question 10When creating a backup and restore policy, you must determine an appropriate schedule. Which of the following factors should impact your decision regarding this schedule?1 pointExpand11.Question 11When you first create a database user, how many permissions will the user generally have by default?1 pointExpand12.Question 12The GRANT connect statement connects a user or group to a database. What else does the GRANT statement do?1 pointExpand13.Question 13In MySQL, you can use

Logical Design (20 Marks) • The conceptual design to be implemented following the rules of mapping. Details of all the mapping rules to be explained in a tabular format along with the primary key, foreign key identified after the relationship is mapped. • The logical schema designed to be shown with all the files and the relationship. • For the logical schema designed, all the files required data type, size and other details to be given in a tabular format. • Logical schema designed to be shown with all the arrows to show the relationship between the parent and the child relations

. • 2h 5m. • 25 total points available.25 total pointsEnglishDueJul 22, 11:59 PM PDT1.Question 1In which phase of the database lifecycle does the database administrator work on logical and physical design?1 pointExpand2.Question 2Which of the following database objects defines a set of actions performed in response to an insert, update, or delete on a specified table?1 pointExpand3.Question 3What is the first step to modify the configuration of an on-premises relational database?1 pointExpand4.Question 4Database partitions store subsets of data from very large databases. Which of the following environments commonly use partitions?1 pointExpand5.Question 5What is one advantage of physical backups over logical backups?1 pointExpand6.Question 6What does a database management system (DBMS) use transaction logs to do?1 pointExpand7.Question 7What is one advantage of differential backups over full backups?1 pointExpand8.Question 8Assume that a particular database issue, should it occur, is important but does not require your immediate attention. Which automated database feature should you use to inform you when this issue occurs?1 pointExpand9.Question 9Which security method verifies that users are who they say they are?1 pointExpand10.Question 10When creating a backup and restore policy, you must determine an appropriate schedule. Which of the following factors should impact your decision regarding this schedule?1 pointExpand11.Question 11When you first create a database user, how many permissions will the user generally have by default?1 pointExpand12.Question 12The GRANT connect statement connects a user or group to a database. What else does the GRANT statement do?1 pointExpand