QUESTION ONE a) James, a DBA working for a software development company was required to design adatabase management system.Required:(i) Outline two principle requirements he would consider when selecting thestorage media for the proposed database system (ii) Explain five benefits the proposed database system will deliver to thecompany (iii) List and explain three challenges James is likely to encounter whileimplementing the proposed database system b) List and explain four DML commands supported by SQL/ MYSQL [4 Marks]c) List and explain three components of a DBMS d) Explain three qualities of a good database system QUESTION TWO a) Explain the following terms as used in database systems:- (i) Database(ii) Data integrity(iii) Candidate key(iv) Relationshipb) Define the term “database normalization” c) Discuss four benefits of database normalization d) With the aid of appropriate illustrations, describe the following database models:-(i) Relational model(ii) Hierarchical mode e) Differentiate between the following database terms:-(i) Logical design & physical design Answer text

Database Management SystemsUNIT-ITwo marks questions:1. What is database? Define DBMS2. What do you mean by defining, constructing, manipulating and sharing adatabase?3. Define data abstraction. Give any two levels of abstraction4. Define query and transaction5. List the phases of database application6. List the characteristics of Database approach7. Give the disadvantages of file processing system.8. Define Metadata. Give an example9. What do you mean by program data independence and program-operationindependence?10.Define Data Model. Give the categories of data model11.Mention the following12.actors on the scene13.workers behind the scene14.What is redundancy? Which problems may arise while storing redundant data?15.List the limitations/disadvantages of DBMS16. Who is a DBA? What are the responsibilities of a DBA?17.Who are database designers? What are their responsibilities?18.What is the responsibility of backup and recovery subsystem?19.What are the advantages of using a DBMS?20.What does the isolation and atomicity property ensure?21.Define Entity, Attribute and relationship22.What is database schema, Schema diagram?23.What do you mean by database state? When do you say the database state is valid?24.Define the terms Internal, external and conceptual schema (any two)25.What do you mean by Logical Data Independence?26.What do you mean by physical data Independence?27.What is the purpose of storage manager?28.List the functions of runtime database processor29.Discuss about Data Definition language?30.Discuss about Data Definition language?31.List the functions of Database System Utilities32.Define a) meta-data b) data dictionary33.List various types of attributes?34.Explain data model and list the types of data model used?35.Define Single-Valued versus Multivalued Attributes, give example36.Define Stored versus Derived Attributes, give example37.Define Composite versus Simple (Atomic) Attributes, give example38.Composite versus Simple (Atomic) Attributes39.Define the terms i) Entity set ii) Relationship set40.Define the terms i) Key attribute ii) Value set(Domain)41.What do you mean by relationship type and relationship instances?42.Define “degree of relationship type”43.What do you mean by role names in the relationship? Give example44.What does the cardinality ratio specify? Which are the possible cardinality ratiosfor binary relationship types45.Define the terms i) Total participation ii) Partial Participation46.Define weak and strong entity types?47.What is partial key? Give example48.Who is Database Administrator?49.Definition of system designer, tool developer, operator & maintenance personnel.50.What is meant by restricting unauthorized access?51.What is deductive database system?52.Why storage definition language (SDL) is used?53.Why interfaces for DBA are used?3 OR MORE MARKS1. What are the characteristics of DBMS? Explain2. Explain the different categories of End Users in DBMS?3. Write a short note on4. DBA ii. Database Designers5. Explain the different categories of workers those are associated with the design,development and operation of the DBMS6. Explain any four advantages of DBMS7. Explain the different categories of data models8. Explain three schema architecture of database with a neat diagram9. What is data Independence? Explain their types10.What are the different database languages? Explain with example

List any four factors a database designer should consider when selecting a DBMS systemin your organization. [4 Marks]b) Wanguru Company Limited intends to introduce a new computerized system in order themanagement of its employee’s records. Outline FOUR good features you would want tosee in the implemented Wanguru database system. [4 Marks]c) KCA University uses the Database approach instead of a manual systems approach for keepingrecords. Explain any four disadvantages of using manual database approach. [4 Marks]d) Discuss FOUR components of a database management system (DBMS). [4 Marks]e) Explain FOUR classifications of relationships based on Degree. [4Marks]QUESTION TWO [15 MARKS]a) Describe the following attributes and give an example in each case:i. Derived Attributeii. Key Attributeiii. Composite Attributeiv. Single-Valued Attributev. Optional Attribute [5 Marks]b) List three types of users associated with the database implementation [3 Marks]c) Describe the following classes of database integrity and explain how they are enforced.i). Entity integrityii). Referential integrityiii). User defined Integrity [3 Marks]d) Write a simple SQL statement that can be used to insert students details into the database[4 Marks]

I have DBMS Exam can you guess the questions that refer fundamentals of database management system book of elmasri navathe. i want 20 questions with short explations

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

Describe any four disadvantages of the file-based systems (4 Marks)(b) Discuss the five components of the database management system (5 Marks)(c) Identify the roles of the following people(i) Database designer (1 Mark)(ii) Database administrator (1 Mark)(iii) Database user (1 mark)(d) With respect to information management, compare the following concepts;(i) Instance and schema (4 Marks)(ii) Tuple and attribute (4 Marks)(iii) File system and DBMS (4 Marks)(e) There are three default database schemas that found in SQL namely informationschema, mysql and test. Discuss each showing its role in DBMS. (6 Marks)