To manage the materials of a factory, please give the E-R diagrams.Such entity sets are involved as below:Warehouse: with attributes as Number, area and telephoneAccessory : with attributes as number, Name, Specification, priceand descriptionSupplier: with attributes as Number, name, address, telephone andасcountProject : with attributes as number and budgetEmployee : with attributes as number, name and age The relationships among these entity sets are listed as below:A kind of accessory can be deposited in more than one warehouse. Awarehouse can accommodate more than one kind of accessory.There can be more than one employee in a warehouse, and a employeecan work in only one warehouse.Some employee can leader others.A supplier can supply various accessories to various projects. Aproject can use accessories supplied by various suppliers. A kind ofaccessory can be supplied by various supplier.*

The E-R diagram is given below:

To manage the materials of a factory, please give the E-R diagrams. Such entity sets are involved as below: Warehouse: with attributes as Number, area and telephone Accessory: with attributes as number, Name, Specification, price and description Supplier: with attributes as Number, name, address, telephone and асcount Project : with attributes as number and budget Employee : with attributes as number, name and age

To manage the materials of a factory, please give the E-R diagrams. Such entity sets are involved as below: Warehouse: with attributes as Number, area and telephone Accessory: with attributes as number, Name, Specification, price and description Supplier: with attributes as Number, name, address, telephone and асcount Project : with attributes as number and budget Employee : with attributes as number, name and age

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

Instructions: Create an Entity Relationship Model (focus on the 2 processes only)
with A UML diagram please
How does an entity-relationship diagram work and what precisely is it?
Please DRAW a normalized ER diagram for the following situation: Unidiner is a university dining service organization that provides dining services to a major university.The following describes part of the business.Develop a conceptual ER diagram that captures business facts● The organization sets up a team of its staff to work on each event. Each staff has a name, salary, and some skills. Each staff can be part of different teams.● The organization assigns one of the staff as the supervisor of the team who supervises the team during the event.● Each event has a date, location and time.● For each staff in a team, there is a working start time, working end time and position defined.● The organization has menus. For each event, the university chooses one of the menus to be served at the event. Each menu has a description and a type.● Each menu contains several dishes, and each dish could be included in different menus. Each dish has a name, preparation time and some ingredients.Please…
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many-to-many relationships. Tip: Pay attention to the mark allocation shown below. Sheep farm feed supplier business rules: • All entities must have surrogate primary keys. • A contact person represents one or more suppliers, and each supplier has exactly one contact person. • A supplier supplies many feed products, and every feed product can be supplied by many suppliers. • Each feed product belongs to a specific feed type, and many feed products can have the same feed type.
Draw entity relationship diagram
How does an entity-relationship diagram work and what precisely is it?
Prepare an E-R diagram for a real estate firm that lists property for sale. Identify all entities (supertype/subtype), attributes (optional/required), unique identifiers, relationships and relationships cardinality and optionality. Resolve any M-M relationship you find. • The firm has several sales offices in several states. Each sales office has Office_Number and a Location. • Employees are assigned to work in different sales offices. Each employee has an ID and Name. • An employee must be assigned to only one sales office. For each sales office, there is always one employee assigned to manage that office. For each manager we record the start date of the management job. • The firm lists properties for sale. Each property has an ID, description and Location. Each unit of property must be listed with one (and only one) of the sales offices. A sales office may have any number of properties listed. • Each unit of property has one or more owners. owners have ID and Name. An owner may own…
Explain the practical differences between procedural and object-oriented programming languages.
Programming Language: Python 5. Write a Python function that will take a positive integer n from the user as an argument and returns 1 if n is prime, and 0 otherwise
b) An ER/EER diagram modeling your database (use appropriate symbols, and don’t forgetassociative entities where appropriate). This will be based on the business rules you created, somake sure you’ve written clear rules! (30 points)• Feel free to use an appropriate design tool you would like for your ER diagram (e.g.http://draw.io), or do it by hand and scan it in; just make sure it is legible and that itfollows the notation/style taught in class. Do NOT use other styles, such as “Visio”notation that includes PK/FK.c) A list of normalized relations (using the notation from class) that is based on your ER diagram.Be sure to include foreign keys, etc. (30 points)
Draw an example of an E-R diagram for each concept and then write the business rules for each example. associative entity weak entity unary relationship