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.
The post 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 first appeared on Scholarly Guider.