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.
Question
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.
Solution 1
Based on the scenario, here are the entities, relationships, their attributes, primary keys, and cardinality:
Entities:
- Customer: Attributes include name (first name, middle name, and last name), date of birth, gender, login details (email, password), occupation, and contact number. The primary key could be the customer ID.
- Book: Attributes include the book title, a 50-word description, unit price, image of the book, author details, published year, edition, publisher, and language. The primary key could be the book ID.
- Author: Attributes include name, country, and expert area(s). The primary key could be the author ID.
- Magazine: Attributes include the name of the magazine, publisher, price of the magazine, image of the magazine, month and year published, and the name of the editor. The primary key could be the magazine ID.
- Stationery Item: Attributes include the item's name, unit price, image of the item, 20-word description, and item code. The primary key could be the item code.
- Order: Attributes include 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, payment type, total amount. The primary key could be the order ID.
- Delivery Status: Attributes include status type. The primary key could be the status ID.
- Complaint: Attributes include complaint details. The primary key could be the complaint ID.
Relationships:
- Customer-Order: One customer can place many orders (1:N).
- Order-Book: One order can contain many books (1:N).
- Order-Magazine: One order can contain many magazines (1:N).
- Order-Stationery Item: One order can contain many stationery items (1:N).
- Book-Author: One book can have many authors (1:N).
- Order-Delivery Status: One order can have one delivery status (1:1).
- Order-Complaint: One order can have many complaints (1:N).
To draw the Enhanced Entity Relationship (EER) diagram, you would need to use a software tool like Microsoft Visio, Lucidchart, or draw.io. Unfortunately, I can't draw the diagram here. However, you would represent each entity as a box, each attribute as an oval connected to its entity, and relationships as lines connecting the entities. The cardinality would be represented at the ends of the relationship lines.
Solution 2
Based on the scenario, here are the entities, relationships, their attributes, primary keys, and cardinality:
Entities:
- Customer
- Book
- Author
- Magazine
- Stationery Item
- Order
- Delivery Status
- Complaint
Attributes:
- Customer: Customer ID (Primary Key), First Name, Middle Name, Last Name, Date of Birth, Gender, Email, Password, Occupation, Contact Number, Delivery Address(es)
- Book: Book ID (Primary Key), Title, Description, Unit Price, Image, Published Year, Edition, Publisher, Language
- Author: Author ID (Primary Key), Name, Country, Expert Area(s)
- Magazine: Magazine ID (Primary Key), Name, Publisher, Price, Image, Month and Year Published, Editor Name
- Stationery Item: Item ID (Primary Key), Name, Unit Price, Image, Description, Item Code
- Order: Order ID (Primary Key), Customer ID, Delivery Address, Special Message, Quantity, Ordered Date, Delivery Date, Payment Type, Total Amount
- Delivery Status: Status ID (Primary Key), Order ID, Status Type
- Complaint: Complaint ID (Primary Key), Order ID, Item ID, Description
Relationships:
- Customer-Order: One-to-Many (One customer can place many orders)
- Order-Book: Many-to-Many (One order can contain many books and one book can be in many orders)
- Order-Magazine: Many-to-Many (One order can contain many magazines and one magazine can be in many orders)
- Order-Stationery Item: Many-to-Many (One order can contain many stationery items and one stationery item can be in many orders)
- Book-Author: Many-to-Many (One book can have many authors and one author can write many books)
- Order-Delivery Status: One-to-One (One order has one delivery status)
- Order-Complaint: One-to-Many (One order can have many complaints)
To draw the Enhanced Entity Relationship (EER) diagram, you would need to use a software tool like Microsoft Visio, Lucidchart, or draw.io. Unfortunately, I can't draw the diagram here, but you can use the entities, attributes, and relationships I've outlined to create it.
Similar Questions
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.
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 • 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
Case Study MCQ: The Book Nook DilemmaThe Book Nook is a family-owned bookstore with a loyal customer base. They specialize in curated book collections and personalized recommendations. However, online bookselling giants are capturing a growing market share. The Book Nook is considering digital solutions to stay competitive.Here's what they're considering:Option 1: Setting up an online store: Customers can browse and purchase books online for home delivery or in-store pickup.Option 2: Implementing a customer relationship management (CRM) system: Capture customer preferences and purchase history to personalize recommendations and promotions.Option 3: Developing a mobile app: Allow customers to browse recommendations, check book availability, and potentially order online for in-store pickup.Instructions: Analyze the case study and choose the best answer for questionUsing a CRM system to personalize recommendations aligns with which concept?Select one:a. Digital Transformation: A Whole New Ball Gameb. Digitization: Going Digital (One Step at a Time)c. Digitalization: Efficiency Boost with Digital Tools
An online retailer of books, electronics, tools, groceries and general home items does not have any physical retail stores for its operations. What is the business model followed by this online retailer?Options Brick and click Surf and click Brick and mortar Concrete and mortar
……………………… for information involves looking for information from books, publishers’ catalogues and relevant databases. A. Searching B. Dissemination C. Organisation D. Acquisition
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.