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.
Using the Entities and Attributes you created for your business from the week
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.
