Define entities for the database with formal written

Assignment Help Computer Engineering

Reference no: EM133459197

Questions:

Q10-12 are based on the below business case description. You are designing a relational database for an online customer ordering system for BeanStro (BS) - an organic prepared meal delivery service. You have found the following from interviews and documentation at BS. First-time customers must place an order and register themselves with such information as name, mobile number, email address, and credit card number. Each customer can place an order with multiple meal items including daily special lunch, daily special dinner, power healthy lunch, gluten-free dinner, and so forth. Each meal item has a unique product code, product name, price, and a set of standard nutrition information (e.g., calories, fat, sodium). Since each order can contain multiple product items, you are quick to recall the use of the associative entity, LineItem, for order and product - that's something you learned in a database class you took a few years ago.

Q10. Define entities for the database with formal written descriptions.

Q11. Draw an ER diagram with Chen's notation. Make sure to include attributes, cardinalities, and participations.

Q12. Justify each cardinality and participation as to why you put them so in the ERD.

Reference no: EM133459197

Questions Cloud

Identify security controls that could be implemented : identify security controls that could be implemented in the Workstation, LAN, LAN-to-WAN, WAN, Remote Access, and System/Application Domains.

Find and locate a famous fingerprint online : Find and locate a famous fingerprint online. Remember to save it for next week. Drop the fingerprint into a Word document and then using the drawing tool

Discuss three hat categories with examples : Discuss three Hat categories with examples including their motivations and goals. Describe two hacker profiles.

What are the pain points or frustrations you face : What are the pain points or frustrations you face with the technology you use in your day-to-day role

Define entities for the database with formal written : Define entities for the database with formal written descriptions. Draw an ER diagram with Chen's notation. Make sure to include attributes, cardinalities

Search for a tool that can assist us performing a pentest : search for a tool that can assist us performing a pentest. Elaborate on what its intent is and what are the system requirements. Please provide a minimum full

What services are running do you have any concerns with : What services are running? Do you have any concerns with any of the services running? If you have concerns from (b), what suggestions do you have to improve

Role is in promoting children understanding of aboriginal : Define what your role is in promoting children's understanding of Aboriginal and/or Torres Strait Islander Peoples history and culture.

Describe hard disk drive encryption : Describe hard disk drive encryption.

User Account

All Pages