Generate ERD of following Scenario: Identify 5- attributes per Entity excluding Primary, Foreign and Unique Key. In Mall-Management System, there are multiple shops having multiple products. Each Product can be supplied by multiple vendors (suppliers) to one or more shops. Each shop can place orders for products to one or more suppliers when inventory is shop reaches minimum level in the shop. Orders for products are automatically generated to selected suppliers by Shop. Each Product is associated with at-most one category but category can have multiple products. Shop can create different campaigns in which they can offer discounts on different products for Customers. Each Campaign have specific start and end date, after expiry of Campaign end date discounts on particular products are automatically removed. Customer can place atmost 5 orders during campaign and at-most 20 products overall during the Campaign. Each campaign is run using Google Adwords and conversion from Customer Website visit to placing order is tracked using GTM (Google Tag Manager). Suppliers have their own inventory and supplier can further place order to their sub- suppliers also.

Generate ERD of following Scenario: Identify 5- attributes per Entity excluding Primary, Foreign and Unique Key. In Mall-Management System, there are multiple shops having multiple products. Each Product can be supplied by multiple vendors (suppliers) to one or more shops. Each shop can place orders for products to one or more suppliers when inventory is shop reaches minimum level in the shop. Orders for products are automatically generated to selected suppliers by Shop. Each Product is associated with at-most one category but category can have multiple products. Shop can create different campaigns in which they can offer discounts on different products for Customers. Each Campaign have specific start and end date, after expiry of Campaign end date discounts on particular products are automatically removed. Customer can place atmost 5 orders during campaign and at-most 20 products overall during the Campaign. Each campaign is run using Google Adwords and conversion from Customer Website visit to placing order is tracked using GTM (Google Tag Manager). Suppliers have their own inventory and supplier can further place order to their sub- suppliers also.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: In the Entity-Relationship (ER) model, list the many types of attributes.

A: What is an ER Model? Theoretically and conceptually, software development uses entity-relationship…

Q: DATABASE SYSTEM DRAWING E/R DIAGRAM AND RELATIONAL SCHEMA. Draw the ERD with appropriate mapping…

A: The entity-relationship diagram in the database management system is also known as the ER diagram.…

Q: Develop ERD (Entity Relationship Diagram) for one of the following two scenarios. NOTE: No further…

A: Answer: We have drawn the the Entity relation diagram for the one of the following so we have done…

Q: STORE Store Nor Store Name Store Address Is Managed by Mgr Role Start Time Mgr Role End Time…

A: Given a relationship between store and employee both which are classes and have some properties.Here…

Q: BFY maintains a website to get customer orders. Customer can visit BFY website either directly or…

A: the diagram is an shown below :

Q: draw an er diagram with rhe informtion provided. Entities: Beach Coffee Carts Coffee Shops…

A: An Entity Relationship (ER) Diagram can be defined in such a way that it is a type of flowchart that…

Q: A prospective key is an attribute that is part of a composite primary key.

A: One primary key is a composite one. The primary key in database management systems consists of two…

Q: For the business rules given below, create a fully labeled Crow’s Foot diagram using Visio. Business…

A: Explanation: Based on the TEC requirements, the table details as follows. The Company table is used…

Q: In a composite primary key, a prospective key is a prospective characteristic

A: One primary key is a composite one.The primary key in database management systems consists of two or…

Q: Prepare a UML diagram for register a customer complaint. prepare a UML diagram for canceling a…

A: The Unified Modeling Language (UML) is a standardized visual modeling language used in software…

Q: Complete Each Entity's relationship. ex) A CUSTOMER makes many ORDER And if ther is any errors or…

A: The following relations exists in the given Entity Relation Diagram: A CUSTOMER makes many ORDER. A…

Q: To manage the materials of a factory, please give the E-R diagrams. Such entity sets are involved as…

A: The E-R diagram is given below:

Q: Develop a variation of the hybrid merge-join approach where none of the relationships is physically…

A: Introduction: The merge join is not the same as the hybrid merge join. In the merge join technique,…

Q: Create an ER diagram for a reservation system of hotel rooms considering the following facts. You…

A: The ER Entity Relationship Diagram represents the model of the reservation system of hotel rooms…

Q: Draw an ER diagram for the following scenarios: Library System Stanford University is having a…

A: Given scenario:To create an Entity-Relationship (ER) diagram for a library system at Stanford…

Q: Draw clearly from existing scenario text the Entity Relationship Diagram (ERD)

A: ERD Description: Tables: Table baby_sitter is used to hold the details of the employs. Table mother…

Concept explainers

Enhanced ER Model

The enhanced ER model is an abbreviation for Enhanced Entity-Relationship (EER) model. As you know, the entity-relationship (ER) model is a pictorial illustration of the relationship between various entities of a domain. In the case of a large amount of data with multiple interrelated entities, the ER diagrams become complex and tough to interpret. For such cases, the need for enhancement in the ER model was observed, and thus, the EER model was designed.

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1 : Introduction

VIEW

Step 2 : ERD for given scenario

VIEW

Step 3 : Explanation

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

In order to be used as a primary key, which of these characteristics must an attribute possess with respect to a single instance of the entity? There must be a maximum of one attribute instance. There must be many instances of the attribute. There must be at most one entity instance that each attribute instance describes. There must be at least one instance of the attribute. There must be zero or more instances of the attribute.
Draw an ERD for the following scenario: A department employs many employees, but each employee is employed by one department. Each employee has the following characteristics: emp_Num, emp_FName, empLName, empAdress. Each department has a code and a name. Some employees, known as “rovers,” are not assigned to any department. A division operates many departments, but each department is operated by one division. Each division has a code and a name. An employee may be assigned many projects, and a project may have many employees assigned to it. Each project has a code and a name. An assignment is characterized by a date and number of hours. A project must have at least one employee assigned to it. One of the employees manages each department, and each department is managed by only one employee. One of the employees runs each division, and each division is run by only one employee.
According to this particular standard form, none of the non-key attributes may be operationally dependent on any of the main key's components.
Swing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…
Identify the class of entity represented by each of the lettered symbols in the REA model.
You are given an E-R diagram with two entities Orders and Customers. What does the lone between the Customers entity and the Place relationship represent?