Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me creating a ERD-diagram for the following cafe website and ordering D atabase design: specify al l the business data entities required to
Database design: specify all the business data entities required to support the transactions on your website. If your website uses MongoDB, you only need to present 1 table but your website uses SQL, you need to present multiple tables with relationships
Design documentation should include the following aspects:
1. Business rules: who can access your website and what are the activities such users can perform in the website,e.g. a customer can browse the products through search in an eCommerce website. Your expressions of business rules should be consistent with Project 1 assessment 3.
- Admin
- Admin will be the head and have their own login interface
- Admin can make any changes if they want
- Authorised user
- Admin can create different accounts for authorised users
- An authorised user can change their login
- All authorised users will have unique login
- Authorised users can have admins view
- Authorised users can add or delete any items from menu
- Caf
- A cafe can have as many items as it wants
- A caf must have a unique name
- It should include name, address (street number, unit number), postcode, and city, and can have a photo, and description
Customer
- A customer can view all the items in the menu
- A customer can order as many items as they want
- A customer can order food online
- A customer can have a booking online for any functions
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started