Write a brief explanation of your design decisions and how the business rules are implemented in your data model.

Module 2: Assignment – Translate Business Rules into Data Model Components Due: Sun Sep 1, 2024 11:59pmDue: Sun Sep 1, 2024 11:59pm Ungraded, 50 Possible Points 50 Points Possible Attempt Attempt 1 In Progress NEXT UP: Submit Assignment Unlimited Attempts Allowed Get Ready Welcome to your assignment on designing a relational data model for an online bookstore! In this activity, you will create a comprehensive data model that includes entities like books, authors, publishers, customers, orders, and reviews. By translating business rules into structured data components, you’ll develop a deep understanding of database design principles and their real-world applications. This hands-on experience will enhance your technical skills, preparing you for future academic projects and professional data management and IT roles. Moreover, working on this project will foster collaboration and communication skills as you share insights and learn from your peers. This assignment aligns with our course objectives, focusing on data modeling, normalization, and the practical application of database concepts. Explore building an efficient and scalable database system for a dynamic online business! Remember that this assignment is the base for future assignments through module 6. All these assignments together form a complete case study on the Online Bookstore Application. Supportive Materials To be successful with this assignment, review the following before you begin. Note: you may have seen these resources already as you reviewed the content on the Learning Materials page. eBook or Textbook Chapter/Unit: Chapter 2. Data Models Chapter 3. The Relational Database Model Online articles, webpages, presentations: Chapter 2_Data ModelsDownload Chapter 2_Data Models Chapter 3_The Relational Database Model Youtube.com: Data vs Information Beginning Database Design: Entities and Attributes Concept of Keys in DBMS Complete Your Work Business Scenario for Online Book Store BookSphere strives to provide customers with an extensive range of books covering diverse categories through its online platform. Customers can browse, search, and purchase books from authors and publishers. The store offers detailed information about each book, including reviews from other customers. BookSphere handles the entire process from order placement to delivery, ensuring timely updates and tracking information. Additionally, the store supports multiple shipping methods to cater to different customer needs. Business Rules Book: Each book has a unique identifier, title, genre, price, stock quantity, ISBN, and publication date. Multiple authors can write each book. A specific publisher publishes each book. Books can belong to multiple categories and subcategories. Each book can receive multiple reviews with a unique identifier, rating, comment, and review date. Author: Each author has a unique identifier, name, address, email, and phone number. Publisher: Each publisher has a unique identifier, name, address, email, and phone number. Category: Each category has a unique identifier and a name. Subcategories are linked to a parent category. Customer: Each customer has a unique identifier, name, email, password, address, phone number, and registration date. Customers can place multiple orders, each with a unique identifier, order date, shipping address, and total amount. Review: Reviews are written by customers and are linked to a specific customer and book. Order: Each order has a unique identifier, customer ID, order date, shipping address, and total amount. An order can include multiple books, specifying quantity and unit price for each book. Orders have a status (e.g., Pending, Shipped, Delivered, Canceled) with tracking information. Shipping Method: Each shipping method has a unique identifier, type (e.g., standard, express), cost, and estimated delivery time. Translate Business Rules into Data Model Components In this assignment, you will translate the business rules of an online bookstore into data model components. This involves identifying the key entities, attributes, keys (primary key, foreign key) and defining their relationships. Instructions Understand the Business Rules: Review the provided business rules for the online bookstore to understand the requirements and constraints. Identify Entities and Attributes: Determine the entities involved (e.g., Books, Authors, Publishers, Customers, Orders, Reviews). List the attributes for each entity, ensuring all necessary information is captured. Also, identify the primary keys. Define Relationships: Identify how entities are related to each other (e.g., Books can have multiple Authors, Orders include multiple Books). Determine the type of relationships (one-to-many, many-to-many) and the foreign keys required. Submit Your Work: Save the identified entities, attributes, and relationships in a document. Write a brief explanation of your design decisions and how the business rules are implemented in your data model. Submit the document as per the submission guidelines. Guidelines Word Count: Your explanation should be between 300-500 words. Format: Use a clear and professional format for your document, including headings and subheadings as needed. Citations: If you reference external sources, ensure they are properly cited. Rubric To see how you will be assessed with this assignment, review the associated rubric. If you have any questions about assignment expectations, it is always best to ask early. Submit Your Assignment Find the “Choose a submission type” section at the bottom of this assignment page (if this section is not displayed, the submission type has been chosen for you). Choose your submission type from the options listed there. Complete the assignment for the chosen Submission Type. Click the Submit Assignment button to submit. Please see “How do I submit an online assignment?” or contact your instructor if you need assistance. Module 2: Assignment Rubric Module 2: Assignment Rubric Criteria Ratings Pts Entities Structure 20 to >15 pts Meet Expectation Student identified all the entities and the attributes associated with each entity. 15 to >10 pts Somewhat Meets Expectations Student identified most of the entities and attributes associated with each entity. 10 to >0 pts Does Not Meet Expectations The student identified a few entities or attributes associated with each entity. / 20 pts Keys Identified 15 to >12 pts Meets Expectations The student identified the correct primary and foreign keys to help enforce the business rules on the entities. 12 to >7.5 pts Somewhat Meets Expectations The student identified the keys but did not accurately select some of the attributes chosen as the primary and foreign keys. 7.5 to >0 pts Does Not Meet Expectations The student doesn’t exhibit a clear understanding of the primary and foreign key concepts. Either many of the attributes chosen were incorrect, some keys were missing, or the student did not indicate any keys on the entities. / 15 pts Relationships 15 pts Meets Expectations The student identified all the relationships between entities. 15 to >6 pts Somewhat Meets Expectations The student identified most of the relationships between entities. 6 to >0 pts Does Not Meet Expectations The student did not identify most of the relationships between entities. / 15 pts Total Points: 0 do as a given instruction please and thank you

Last Completed Projects