Draw a data model for this book rental system

Create an activity diagram depicting the workflow of borrowing a book from a library.Include all the necessary steps involved in the process, such as checking book availability, issuing the book, recording borrower information, etc.Label each activity and decision point clearly.Use appropriate symbols and notations as per the Unified Modeling Language (UML) standards.

Develop an online book purchase system using structure concept in C and refer the following constraints.•    Define structures to represent a book and a user. Include attributes such as book ID, title, author, price.•    Use appropriate data types for each attribute and ensure encapsulation by making attributes private or protected.•    Select suitable functions to add, delete, and display books in the structure.Input:2CSE101 C++ ProgrammingDennis Ritchie2000CSE102Python ProgrammingDavid Mark 2500Output:Do you want to delete Y or N? YCSE101Successfully deleted!Remaining RecordsCSE102Python ProgrammingDavid Mark 2500

Create a structure named Book for storing book details such as title, author, edition, and price. Write a C program to input details for n books, find the highest expensive and the lowest priced books, and display their information.xxxaaaa1245yyyddd5100xxx aaaa 1 245

An online bookstore is planning to develop a comprehensive management system to streamline its operations. The system aims to handle various aspects of the business, including inventory management, customer orders, and employee roles. The primary goal is to provide customers with an efficient platform for browsing and purchasing books while allowing employees to manage orders and maintain accurate inventory records. The system should keep track of book details such as ISBN, title, author, genre, and price. Customers will have unique identifiers, and their information will include names, email addresses, and delivery addresses. Orders will be associated with customers and will include order IDs, order dates, and total order amounts. Employees will have distinct roles, and their details will encompass employee IDs, names, positions, and salaries. The relationships among these entities will define the flow of information and activities within the bookstore. Customers will be able to place multiple orders, each associated with a single customer. Orders will consist of multiple books, and each book can be part of multiple orders. Employees will process orders, and each order will be assigned to a specific employee. Additionally, employees will update inventory records for various books. The bookstore intends to use a UML class diagram to represent these entities, attributes, methods, and relationships to guide the system development process effectively. a) Draw the Class Diagram for the above scenario.

The following details are given for an online store selling books. You are asked to develop the database for the online store. There are different types of items sold at this online bookstore. E.g., books, magazines, and stationery items. Customers can register with the bookstore and order books, magazines, and other items. Customer details include a name (first name, middle name, and last name), date of birth, gender, login details (email, password), occupation, and contact number. Also, the system maintains multiple delivery addresses. Book details include the book title, a 50-word description, unit price, image of the book, author details, published year, edition, publisher, and language. One or many authors can write each book. Each author has a name, country, and expert area(s). The magazine has details, like the name of the magazine, publisher, price of the magazine, image of the magazine, month and year published, and the name of the editor. Stationery items include details like the item's name, unit price, image of the item, 20-word description, and item code. Customers will order items (books, magazines, and stationery items). The system will record the details, like delivery address, a special message to be included (e.g., birthday wish) to the receiver, quantity purchased from each item, ordered date, and delivery date. Also, the customer can enter the payment type (e.g., credit card, cash on delivery). The customer will be able to view the total amount to be paid via the system. Customers can check the delivery status via the system. Types of statuses are pending approval, packing, transit, and delivery. If the items purchased are damaged, then the Customers can return the items. Before the return, customers must make a complaint via the system for the relevant items in a specific order. Based on the scenario: Identify the entities, relationships, and their attributes, primary keys, and cardinality. Draw the Enhanced Entity Relationship (EER) diagram.