Question 54 :Why are a database and a database management system essential for an online business?This type of question contains radio buttons and checkboxes for selection of options. Use Tab for navigation and Enter or space to select the option.optionABecause they are critical for storing customer and product information and catalogsoptionBBecause they are used to authenticate the Web servers and encrypt trafficoptionCBecause they provide the needed payment infrastructure, including a payment gatewayoptionDBecause they come complete with the necessary Web server software

What role does a database system play in business applications?Creating marketing materialsEfficiently storing and retrieving business dataManaging social media accountsDesigning company logosReview AnswerNext

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]

What is the purpose of a database management system (DBMS)?(1 Point)To create user interfacesTo store, organize, and manage dataTo perform automated testingTo design and develop software

What is the primary purpose of a database system?To create graphical user interfacesTo manage and organize data efficientlyTo develop mobile applicationsTo perform complex mathematical calculationsExplanation for answer

Imagine a dynamic website like an online store. How do you think SQL plays a role in managing data behind the scenes? Consider how product information, user accounts, and order details might be stored and accessed