Reference no: EM132110235
Propose a relational database design (a set of relation schemata) for the online food ordering and delivery application illustrated in this UML class diagram:
The proposed design must satisfy the constraints of third normal form, as described in the Kent reading*, but you don't need to include attributes for handling every use scenario.
Concentrate on what you consider the 3-5 most important attributes of each class, and focus on the following modeling problems:
A menu item's inclusion in any particular order must be associated with a quantity (e.g., how many garlic bread). But the item's inclusion on the restaurant's menu has no particular quantity.
Users will search for items (like ravioli) and for categories (like pasta or Italian cuisine).
So those items and categories must each be associated with one or more restaurants. But not every restaurant will include the same items in the same categories: the organization of the menu is up to the individual restaurant.
Upload your design proposal here, together with your comments on the exercise.
Include a description of what joins on your relations would produce tuples that answer a question like: "List restaurants featuring pasta items and the specific items in that category they offer."
|
Advise billy about his legal rights
: LAW2457 - LAW OF INVESTMENTS AND FINANCIAL MARKETS - Advise Billy about his legal rights. Refer to relevant statute law and case law to support your response
|
|
Prove the inference rules for functional dependencies
: A proof should be made by using the reflexive, augmentation, transitive, decomposition, union, and pseudotransitive rules.
|
|
Prove or disprove the following proposed inference rules
: A proof should be made by using the reflexive, augmentation, transitive, decomposition, union, and pseudotransitive rules.
|
|
Prove the following statement using hals theorem
: Prove the following statement using Hall's Theorem. For any bipartite graph G=(U, V, E), if every node (either a left node or a right node) has exactly.
|
|
Propose a relational database design
: Propose a relational database design (a set of relation schemata) for the online food ordering and delivery application illustrated in this UML class diagram.
|
|
Issues in relation to cyberbullying
: What are the strategies to tackle issues in relation to cyberbullying - How would you educate organisations and individuals to protect themselves
|
|
Provide an instance that comes close to your ideal balance
: Proposed solution to resource sharing and security against unathorized resource access that you view as the ideal balance between sharing, protection.
|
|
Prove that when a binary tree with n nodes is implemented
: Prove that, when a binary tree with n nodes is implemented by using links to the left and right child, then there will be a total of n+1 null links.
|
|
What is the pipeline clock cycle
: What is the pipeline clock cycle? How long it takes to perform n operations without pipelining using the clock cycle in (a)
|