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

Similar questions

Explain why an index is only helpful if an attribute's values fall within a reasonable range. An index is only helpful in this situation.
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.
Explain the relationship in the below Entity Relationship Diagram (ERD) inyour own words.Answer the following questions by referring to the below sample data.
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?
In the Entity-Relationship (ER) model, list the many types of attributes.