Database

Using the Entities and Attributes you created for your business from the week 1 discussions, show the tables and relationships resulting from your model in the form of an E/R diagram.  Be sure to identify key attributes and relationships across all entities.

You can use Microsoft tools like PowerPoint/Visio, or any other graphical modeling tool to create your E/R diagram.

Business from week 1:

Custom 3D Printed Jewelry

Business Overview: Custom 3D Printed Jewelry is a niche business specializing in designing, customizing, and producing 3D printed jewelry pieces such as rings, necklaces, bracelets, and earrings. Customers can choose from pre-designed pieces or request custom designs. The business uses advanced 3D printing technology to create unique, personalized jewelry items.

Possible Entities and Their Attributes

1. Customer

  • CustomerID:
  • FirstName:
  • LastName:
  • Email:
  • Phone:
  • Address:
  • JoinDate:

2. JewelryPiece

  • JewelryID:
  • Name:
  • Description:
  • Type:
  • Price:

3. Order

  • OrderID:
  • OrderDate:
  • CustomerID:
  • TotalAmount:

4. OrderDetails

  • OrderDetailID:
  • OrderID:
  • JewelryID:
  • Quantity:
  • Price:

5. Customization

  • CustomizationID:
  • JewelryID:
  • CustomerID:
  • Details:
  • DesignFile:

Database Processing and Application Software

Database Processing

  • Relational Database Management System (RDBMS): A relational database, such as MySQL, PostgreSQL, or Microsoft SQL Server, would be ideal for managing the entities and their relationships.
  • CRUD Operations: The system will require Create, Read, Update, and Delete operations to manage customers, jewelry pieces, orders, and customizations.
  • Transaction Management: To ensure data integrity, particularly for order processing and payment transactions.
  • Search and Filtering: Customers should be able to search for jewelry pieces by type, material, price range, etc.
  • Reporting: Generate reports on sales, customer orders, popular items, etc.

Application Software

  • Web Application: A user-friendly web application for customers to browse jewelry pieces, place orders, and request customizations. Technologies could include HTML, CSS, JavaScript, React.js for the front-end, and Node.js or Django for the back-end.
  • Inventory Management System: To keep track of available materials and manage inventory levels for 3D printing supplies.
  • Customer Relationship Management (CRM): To manage customer interactions, track order history, and handle customer support.
  • Design Software Integration: Integration with 3D design software (e.g., Blender, Tinkercad) to handle custom design requests and process 3D models.
CustomEssayMasters

Ready To Get Started

The Exertio is a Premium WordPress Theme, you can create your own market place website using this theme. It allows you to get a commission for hiring a freelancer or for each service sold.