Place Order

Conceptual Database Design

ENSURE YOU READ , CLICK ON SAMPLE PROJECT TO SEE SIMILARITY ON HOW MAIN PROJECT SHOULD LOOK

 

MAIN PROJECT

Conceptual Database Design Project Description:

Project Overview: In this project, you will demonstrate your understanding of conceptual database design principles by creating an Entity-Relationship Diagram (ERD) based on the requirements gathered from a real-world website. Analyze the structure of https://shop.pbs.org to design a composition diagram. Using this information, identify entities, attributes, and relationships and design a conceptual ERD that accurately represents the underlying data model of the website.

Project Requirements:

  1. Concentrate on the gifts tab on https://shop.pbs.org chosen website to identify entities, attributes, and relationships. Pay attention to the different types of data stored on the website and how they are interconnected.
  2. Design a composition diagram starting from products or categories. Clearly indicate the datatypes and multiplicities. Indicate any restrictions such as check constraints, enumerations etc. either on the composition diagram or below it.
  3. Design a conceptual ERD using the Peter Chen notation. Clearly define entities, attributes, primary keys, and relationships between entities.
  4. Provide a brief explanation of your design choices, including any assumptions made during the analysis process.
  5. Present your conceptual ERD in a professional and organized manner. Use appropriate software tools to create clear diagrams and ensure readability.

 

 

SAMPLE TASK (SOLUTION IS BELOW)

Design conceptual DB for the visitor (guest user) of https://www.coffeesuppliesdirect.co.uk.
Userview 1 :guest visiting the website 

You have already analyzed this and submitted the screenshots. Based on your analysis  design and submit your report containing the following:

  • Title page (with team logo, name, motto, team member info and version #)
  • Screenshots, assumption and any other explanations
  • Composition diagram
  • ERD
  • Documentation (submit only entity document and relationship document)

SAMPLE PROJECT LINK

PROJECT